Export to Excel > 65000 Rows

[hangar18]

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

[Mark Rae [MVP]]

"hangar18" <so************@wipro.comwrote in message
news:84**********************************@b31g2000 prf.googlegroups.com...

I know that in my webserver, MS Office is not installed.

That's a very good thing, as server-side automation of Office isn't
supported at all because it's so flaky:
http://support.microsoft.com/default...US;q257757#kb2
http://support.microsoft.com/default.aspx/kb/288367

I am looking at the option of using Office Web Components.

OWC is/was a great product. Unfortunately it is now being actively
discontinued, and no longer ships with Office 2007. The latest version,
however, will continue to be supported for a few more years:
http://blogs.msdn.com/excel/archive/...17/668544.aspx
I've never used OWC, so can't confirm whether the Excel component supports
more than 65,536 rows...

Is there any other way which this can be acheived?

http://www.aspose.com/categories/fil...a/default.aspx
http://myxls.in2bits.org/wiki/Defaul...ookieSupport=1
--
Mark Rae
ASP.NET MVP
http://www.markrae.net

[Cowboy \(Gregory A. Beamer - MVP\)]

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

[ZSvedic]

On Oct 24, 7:21*am, hangar18 <[e-mail]:

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

Hi,

My recommendation is to use XLSX file format, OpenXML is
largely replacing old XLS and has support for 16 million rows.
You have my article with simple XLSX export code here:
http://www.gemboxsoftware.com/Excel2007/DemoApp.htm

You can read XLSX files with Excel 2003 and older
using Microsoft Office Compatibility Pack:
http://www.microsoft.com/downloads/d...displaylang=en

If you need more advanced stuff, we have GemBox.Spreadsheet
component which supports borders, colors, print settings etc.:
http://www.gemboxsoftware.com/GBSpreadsheet.htm

Hope I helped,

--Zeljko

[rote]

Have you taught of using SSIS(Sql server integrated Services)
That could help alot.
Patrick
"ZSvedic" <ZS*****@gmail.comwrote in message
news:22**********************************@y71g2000 hsa.googlegroups.com...
On Oct 24, 7:21 am, hangar18 <[e-mail]:

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

Hi,

My recommendation is to use XLSX file format, OpenXML is
largely replacing old XLS and has support for 16 million rows.
You have my article with simple XLSX export code here:
http://www.gemboxsoftware.com/Excel2007/DemoApp.htm

You can read XLSX files with Excel 2003 and older
using Microsoft Office Compatibility Pack:
http://www.microsoft.com/downloads/d...displaylang=en

If you need more advanced stuff, we have GemBox.Spreadsheet
component which supports borders, colors, print settings etc.:
http://www.gemboxsoftware.com/GBSpreadsheet.htm

Hope I helped,

--Zeljko