Displaying Excel as GridView

Dec 9, 2010 at 9:36 AM
Edited Dec 9, 2010 at 10:31 AM

 

Hi all!

I would like to display Excel as GridView and would like to know how this could be accomplished.

I tried reading Excel file and creating html table to display it, but performance wasn't very good :(

Took too much time to display a couple of thousands of rows :(

 

Hope someone can help me! Thanks all for your effort!

 

Regards, Max

Coordinator
Dec 10, 2010 at 1:35 PM

Hi,

Reading a couple of thousand rows should not take more than a couple of seconds, of course depending on the number of columns and the size of the workbook.

Check out sample 8, it loads 65000 rows 5 columns (in about 5 seconds on my dev machine).

How long time does it take to write your HTML to disc?

Jan

 

Editor
Dec 10, 2010 at 2:06 PM
Edited Dec 10, 2010 at 2:07 PM

I agree with Jan, I think your problem is rendering html table....you can try some tweaks like: remove white spaces and disable viewstate ( reduce page size ), use li/lu instead table, etc.