Excel 2007 vs Excel 2003: where to ?

[longbeach75]

hi,

Since Excel 2003 is a major problem when dealing with Excel reports that have a lot of rows per sheet, i would like to use Excel 2007 instead.

 

File size limitations surprisingly crop up quite frequently in larger Excel work-books. Excel 2007 certainly changes this, with support rising to a massive 16,384 columns and a staggering 1,048,576 rows – up from 256 columns and 65,536 rows, respectively.

 

Is there a way to specify the Excel version in the code ? in the Excel API ?

Or is it recognized automatically ?

What if I have both versions installed ?

 

By the way, I am still looking for a working solution to deal with big reports and avoid the error The maximum number of rows permitted on a worksheet been exceeded .

 

Thanks

[szaharia]

If you want to open your xls files with Excel 2007, you have to tell Windows which is the new default opener for xls type.

In order to do that, if you're on a windows xp machine, open a Windows Explorer and click on the Tools menu. Select Folder Options..., and in the opened dialog click on the File Types tab. In the Registered file type area select the XLS type and then click on the Change button related to 'Opens with ...' label.

In the new opened dialog click on Browse and then find and select on your computer the .exe file associated with Excel 2007. Make sure the 'Always use the selected program to open this kind of file' checkbox is selected. Click Ok, Ok again, and that's all.

 

Concerning the other problem, you said that the generated xls is dreadfully huge (~1GB ) one. This could be a problem for Excel itself. Or for your resources too. Did you try to open a 1GB file (any xls file, not particularly generated with JasperReports) in Excel?

 

If the problem persists with 2007 too, maybe another solution would be to split your select, in order to reduce the rows number: you could get first 10000 rows, then next 10000 rows, and so on, and generate separate xls files for each 10000 rows result set.

 

hth,

sanda

Post edited by: shertage, at: 2007/07/30 09:18

[Teodor Danciu]

Hi,

 

The JR 2.0.1 release introduces a new exporter parameter called MAXIMUM_ROWS_PER_SHEET, that would create a new sheet every time the content surpasses the given number of rows on the current sheet.

 

I hope this helps.

Teodor

[longbeach751]

very cool, thanks a lot