Do anyone come across a performance issue when deleting a first row in a 20,000+ rows Excel file using OpenXML SDK v2.0? I am using the delete row coding suggested in the Open XML SDK document. It takes me several minutes just to delete the first row using Open XML SDK, but it only takes just a second in Excel applicaton. I eventually ...
I am trying to open and refresh an excel 2003 spreadsheet via ole. However I am getting the error "Add method of Workbooks class failed" with no further information. The code works in unit tests, and works on 3 servers but fails with the error on our web server. It is being run from a service app running under the Local System Account...
I am writing a JBOSS web app with Struts2 and would like to produce reports in PDF and XLS format. How can I do this? Are there popular packages that can do this for me? ...
Hi, I need to export huge amount of data from ado.net datatable(which i get by db query) to excel. I tried the following way : 1. Create excel object with workbook/worksheet @ server side...and use memory stream to write whole document to client side. But this gave me "out of Memory exception". bcoz my memory stream was was so huge. ...
how to import excel 2007 file containing 0.4 million records into mysql table ? please suggest appreciate any help ...
I try to avoid using excel too much but when I do I like using structured references as they seem a lot cleaner to write. If I create a table called "table1" with columns "col1" and "col2" how would I reference the first row in "col1" using a structured reference in another table? I have tried the syntax =table1[[#this row],[col1]], and ...
Excel sheet is subtitled but need now to do a count of the items in each grouping so need to find subtilted rows by using a macro and count the number of items in each grouped section (column a) placing the count value in the relevant subtitled row in Column A. no idea where to start can anyone help. Running the subtilteld function aga...
Hi, I am writing each row data in datatable to client side as a comma separated string using response.write and using the following code to get it downloaded at client side. HttpContext.Current.Response.Clear(); // Clear the Response Object HttpContext.Current.Response.ContentType = "application/ms-excel"; HttpContext.Current.Response....
How to check if a specific Column has Integer on each cell, and if it contains a string, Insert a blank cell to row in question. ...
I've got a problem using pyExcelerator when reading some xls-files. There're some python scripts i wrote, that use this library to parse XLS-files and populate database with info. The templates for the files these scripts parse may vary and i sometimes reconfigure the script to handle them. With the one of the templates i ran into pro...
Hi, I need to generate a report in Excel format using Jasperreports. I am using iReports 3.7.0 The reports gets generated with no issues except the size of empty cells. Can somebody please tell how to avoid the highlighted cell being enlarged. Also the normal cells are also a little larger than their content. ...
Hi, I need to export huge amount of data from ado.net datatable(which i get by db query) to excel. I tried the following way : 1. Create excel object with workbook/worksheet @ server side...and use memory stream to write whole document to client side. But this gave me "out of Memory exception". bcoz my memory stream was was so huge. S...
I have an excel spreadsheet with calculations I would like to use in a Django web application. I do not need to present the spreadsheet as it appears in excel. I only want to use the formulae embedded in it. What is the best way to do this? ...
In Excel 2003 I'm getting a Runtime error 1004: "application-defined or object-defined error" on the last line of this code (commandtext = abc) Sub SCommandTxt() Dim abc as string abc = Sheets("Totals").PivotTables("PivotTable2").PivotCache.CommandText Sheets("Totals").PivotTables("PivotTable2").PivotCache.CommandText = abc End Sub T...
to open up an excel file, do I need any special references? I want to access the rows programmatically. ...
I was wondering if there was a way of using the Cell function rather than Range with MATLAB's ActiveX commands? Perhaps someone has a solution to my problem. I have many lists of data and all of varying sizes, for example: List 1 has 10 List 2 has 13 List 3 has 3 ... I would like to take that data and export it to a new sheet in Excel...
Hello all, I've this function that I use to calculate the linear trend of some data: private string Trend(object conocido_y, object conocido_x, object nueva_matriz_x) { string result = String.Empty; try { Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application(); result =...
I'm writing an xml file to be consumed by excel. excel wants this: <Cell><Data ss:Type="Number">25</Data></Cell> I'm writing this... <Cell> <Data ss:Type="Number">25</Data> </Cell> I get that EXCEL is picky, but since I'm using XElelments, how do i control the formatting of the output? here is my code to write a cell. foreach...
Hi, I am using oledb to read data from an excel file and store it in a dataset. My excel file contents are like as follows: 0 0 somestring somestring 500 200 somestring somestring When i checked the contents of my data set, the values of Columns 1 & 2 are not stored as integers but rather as DateTime values. How will I make i...
I'd like to generate a dynamic Excel file on request from Django. The library pyExcelerator does this, but I haven't found any way to use the contents of the Excel file without generating a server-side temporary Excel file, reading it, using its contents and deleting it. The problem is that pyExcelerator only way to extract the contents...