I have, in the past, used a variant array to populate a range of multiple Excel cells. I'm wondering, is there a way to do the same thing with cell formatting? I'd rather not go cell by cell, and it'd be nice to minimize the number of calls to get an Excel range... ...
I'm trying to write a method to transpose tables in Word using Visual Basic and the Excel object model. However, I'm having trouble using paste special with the copied Word object, since its not just plain text. Is it possible to force a plain text paste with transpose? Is there a better way to do this? My current code is as follows: ...
I've got a report requirement that is: Have 3 worksheets that is data pulled from a SQL database (easy.. done) Find an Excel document on the network, and copy all the worksheets into this report (??) I've been searching and the only thing I could find was to use EXCEL as a datasource.. where you would then select * from sheetname. T...
I have the following macro: %macro export_set_excel(data,tabname); PROC EXPORT DATA= &data. OUTFILE= "&results." DBMS=EXCEL REPLACE; SHEET=&tabname.; RUN; %mend export_set_excel; My problem is that sometimes this macro doesn't delete the tab if it already exists. Is there anyway, from SAS, that I can check if...
I am trying to return the list of columns names from a DataSet in C# based on an Excel Query I have performed. I am ok doing this (well I think), see code below. However, three of my column headings are Dates and the column name is displayed as F4, F5, F6. I have looked further and found that the Type (.getType) report System.Double but ...
I'm working on a program that often does Excel exports from hypermassive database tables. One test case I'm doing right now does about 300k rows by 40 columns into one xlsx worksheet. It completes in about 6 minutes or so, taking about 1.1GB RAM, but I've run into a major hangup - after exactly 300 seconds have passed, I see this patte...
How to add an image into the Excel header and footer using any Java open source API ? I tried with Jexcel API. It doesn't have an option to add the image into the header or footer. ...
Basically I have a lot of historical data, consisting of IPs, Contacts, and various other fields. Originally we kept all this data in an Excel spreadsheet. I recently created an Access Database with this historical data. Now I am wondering if there is any way to use VBA or something else to autofill fields in the Excel spreadsheet using ...
Hi, I am trying to read excel 2007 file through php. I found one such example on PHP COM manual but it only works on windows system since COM objects require MS Excel to be installed. Since I have Linux machine that code doesn't work for me. Does anybody know the workaround for this? Due to some restrictions, I don't want to use any ...
i want to get rid of all the carriage returns in my cell. how do i do this ...
I think the title says it all. Eventually, I want to move the cell to the location where the last error occured. Edit: Forgot to say that I'm using Excel 2003. ...
Hi, How to convert a week number to a month ? For example, 162 weeks = 37,26 Month (so 37 Months if we around the number). Have you an idea ? ...
I have a worksheet populated via a data-source which lists dates, vertically as well as horizontally. The dates vertically are items which require action. The dates horizontally are the coming working week dates. At this time, all I want to do is select the corresponding column of the horizontal row based on whats found in the vert...
I am exporting gridview to Excel in windows application successfully, but the problem is when I am going to Merge some range of cells in that excel sheet, it raises a windows dialogue box. So each and every time I am merging those cells it does not give any exception but it's showing a dialogue box. I dont want that dialogue box, how d...
Hi all, I have a dashboard which is a gridview. I've a button to export the gridview data to excel which is already working fine. The only problem is that the column names are not user friendly and I want to change it while populating the data from the gridview. The column name of the gridview is not coming to the excel at all. It's ju...
hello, using asp.net 3.5 I am trying to generate a formatted excel spreadsheet and the way i am doing it is: 1.Format the excel sheet with data 2.Save it as an xml spreadhseet 3.View it in notepad/textpad and remove the "data" from the xml and have a content holder such as "DYNAMICDATA" 4.Build dynamic xml for data and replace the ...
Hi.. I am trying to open excel workbook 2003 using VSTO. but i am getting error again again like " Project cannot be created because the application add-in is not working correctly and might have been disabled. To check for disabled items in the Microsoft Office application, open the Help menu, click About Microsoft Office Word or Abo...
I routinely graph time series data in Excel, and I find the default Excel date-axis labeling on line graphs to be very ugly. In particular, 1) Dates are often rotated horizontally or vertically, which compresses plot area real estate and makes the date labels harder to read. This is because there are two many major tick marks. 2) Label...
I am using OLE with Perl to build a few charts in Excel. The data is in four different worksheets depending on which of the four tests it is for. The problem is that I don't know how to set the chart to look at all of the data when I don't know how long it will be. I know to use; $last_col = $sheet -> UsedRange -> Find({What => "*", Se...
I have code in C# like this. xlWorkBook = xlApp.Workbooks.Open("data.xls", 0, true, 5, "", "", true, Microsoft.Office.Interop.Excel.XlPlatform.xlWindows, "\t", false, false, 0, true, 1, 0); I have data.xls file where .exe are located. When I compile and then run .exe, I'm receiving error that data.xls could not be found. What I do w...