excel

Non-Sequential Range

Can I set a Range Object to be equal to a set of non-sequential cells? I want my Range to be equal to cells A1, A3, A5 etc, where I can pick and choose the rows and columns at will. ...

MS Excel connection with vb.net

I have used the connection string below but I am getting an error when trying to create a table Dim ConnString As String = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & strFName + _ ";Extended Properties=""Excel 12.0 Xml;HDR=YES;IMEX=1""" Cannot modify the design of table 'tablename'. It is in a read-only database. ...

How to identify whether an Excel file conforms to Excel 95 or Excel 97 specifications?

How to identify where the Excel file use Excel 95 or Excel 97 specifications? i.e., which version of BIFF they uses. ...

How do you use the Excel function trend?

How do you use the Excel function trend? How do you fill the condition? ...

vba: getting value of a cell across all tabs

Greetings, I'm trying to write a vbscript function that collects the value of a cell ("E1") across all tabs of an excel document into an array (Reviewers). I wrote the following code, but the data is not being stored into the array, can someone please tell me what I'm doing wrong? this is the code: http://img24.imageshack.us/my.p...

How do I ensure that only one of a certain category of job runs at once in Hudson?

I use Hudson to automate the testing of a very large important product. I want to have my testing-hosts able to run as many concurrent builds as they will theoretically support with the exception of excel-tests which must only run one per machine at any time. Any number of non-excel tests can run concurrently, however at most one excel t...

Control 2 separate Excel instances by COM independently... can it be done?

I've got a legacy application which is implemented in a number of Excel workbooks. It's not something that I have the authority to re-implement, however another application that I do maintain does need to be able to call functions in the Excel workbook. It's been given a python interface using the Win32Com library. Other processes can ...

Read specific Coloumns from Excel files with C#

I wanna to read some excel files and convert to my own excel template.I want to read B coloumn every line.(B1,B2,B3... going like this.) If there is a number in this coloumn ; in B3 there is number like "1,2,3,4,5,6,7,8,9"than i ll get this whole line and take it to an array[i].If there is "5" number in B4 than it ll get this whole line...

Return background color of selected cell

I have a spreadsheet which cells in are colored meaningfully. Does any body know how i can return the background color value of a current cell in Excel sheet? ...

Split Data Into Named Excel Files

I'm working with a set of data from SQL Server that I'd like to get into a group of Excel files. This task needs to be automated to run on a monthly basis. The data looks like Site ID FirstName LastName ------ ------- --------- --------- North 111 Jim Smith North 112 Tim Johnson North 113 Sachin Tedulkar South 201 Horatio...

I need to show excel data on a presentable web page or word doc?

I have survey results which are formatted in excel fine. I then need to show these results indivually wiht the headings on a presentable word doc or wewb page? s there any weay to do this. For example: column one - comlumn 2 result 1 - result 1 result 2 - result 2 to comlumn 1 result one column 2 result one column 1 res...

Edit existing excel files using jxl api / Apache POI

Hi All, I am interesting and would like to learn more on java , how write into existing excel sheets / manipulating the existing data. I was wondering if you could give me an idea on how to edit an existing excel file and saves it using the jxl api / Apache POI or perhaps give me a sample program on how to edit some data in an existing ...

Exporting from SSRS to Excel with no headers

Is there a way to export to excel from an SSRS report so that the header that displays on the first page of the report is omitted only in the excel export? Currently, it adds a frozen frame to the top of the worksheet. ...

Is there a way to decode numerical COM error-codes in pywin32

Here is part of a stack-trace from a recent run of an unreliable application written in Python which controls another application written in Excel: pywintypes.com_error: (-2147352567, 'Exception occurred.', (0, None, None, None, 0, -2146788248), None) Obviously something has gone wrong ... but what?[1] These COM error codes seem to be...

Can you get rid of the "Microsoft Office Excel has encountered a problem" dialog?

You know the one I mean: Is there a way to disable this? I'm writing an application to automatically test a large number of Excel spreadsheets which are used in a critical environment. Many of these sheets do crazy things which crash Excel. When Excel crashes I want it to terminate ASAP and without user-intervention. I definitely ...

Is is possible to insert an image into an excel cell via COM?

I have used automation to insert values into a cell, however I have never seen any documentation, for example, that demonstrate inserting anything other than text and/or formula's. Has anybody been able to insert an image from an external application? ...

Sql Server to Excel via a Web Service

I would like to know the best way to transfer data from a web service to an excel worksheet (office 2007). I am not interested in outputing a report to excel from a web site. In our scenario a user will be using excel (with a number of macros and such) and will request about 11000 rows of data from the server to a worksheet. Anyone ha...

Find and Remove some text in Excel Worksheet with c#

Hi , i wanna find some text for example "Joe" and remove it from where it is in Excel Worksheet with C# ? ...

What's the simplest way to import a System.Data.DataSet into Excel?

In .NET 2.0 (in this case VB), is there a standard API that'll serialize a DataSet object into a stream that can be saved as a tab-delimited file and opened directly in Excel? Or does one have to create the delimited file manually by iterating through the members of the table collection? In this case, the DataSet's small, consisting ...

.NET - 3rd Party Grid Control - AutoFill

Anybody know of a good 3rd Party grid control that supports AutoFill (like Excel does). Also a good export to Excel and import (paste) from Excel would be handy also. I'm mainly interested in a WinForms grid that can do this, but would also be curious if there is a Silverlight grid or ActiveX grid with AutoFill capabilities. ...