Reading Cells is extremely slow

Topics: Developer Forum
Jun 8, 2007 at 1:36 AM
Edited Jun 8, 2007 at 3:28 AM
Edited: Please ignore this post, my error.

I am importing an xlsx spreadsheet with 15 columns and about 100 rows. It takes over a minute for this import to complete.

I have used this code example:
http://www.codeplex.com/ExcelPackage/Wiki/View.aspx?title=Reading%20data%20from%20an%20Excel%20spreadsheet&referringTitle=Home

Are others having the same problem?
Jul 2, 2007 at 10:57 PM
Hi
For me it getg slower and slower the more data i write to the excel sheet, finally the thread dies out in total.
Excel 2003 supported 65000 rows, Excel 2007 a lot more, however Excel package is gone at 4000 rows. Have you found the same problem???

/Magnus
Sep 21, 2007 at 8:45 PM
Hey I am having similar troubles with both reading and writing to excel files. It takes upwards of a minute to do approx. 7x600 cells which seems to be way longer than it should be considering it only takes a fraction of a second to read/write the same info to text files. What was the error that you had that was causing you trouble? I am guessing that I am having the same issue. Anyone else have trouble with this or have a solution?