The row limit is still in effect. You can certainly split the report over
two or more workbooks, but the amount on a single workbook is the same.
How to do it? I would look at third party controls personally. Software
Artisans (
www.softartisans.com) has a component callled OfficeWriter for
Excel that is nice and rather fast. I have not played with it in recent
years, but it is where I would personally look if I were doing this now.
There are some UI Grids that include export to excel. Some that come to mind
are Syncfusion's Essential Grid and Telerik's RAD Grid. I would imagine
Infragistics, Component One, Component Art and Dev Express all have the same
feature. You would have to ask the company(s) how they handle more than
65,000 rows or download trial versions and play.
--
Gregory A. Beamer
MVP, MCP: +I, SE, SD, DBA
Subscribe to my blog
http://feeds.feedburner.com/GregoryBeamer#
or just read it:
http://feeds.feedburner.com/GregoryBeamer
********************************************
| Think outside the box! |
********************************************
"hangar18" <so************@wipro.comwrote in message
news:84**********************************@b31g2000 prf.googlegroups.com...
Hi,
We are exporting data from a grid view to excel using the standard
Response.Content type etc...
But we would like to create new worksheets in case there are more than
65000 rows.
I know that in my webserver, MS Office is not installed.
I am looking at the option of using Office Web Components.
My question is:-
Is there any other way which this can be acheived?
Thanks
- Soni