Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Export to Excel File (SIM 12.0)
Export to Excel File [message #482483] Thu, 11 November 2010 22:59 Go to next message
jagadeesanes
Messages: 10
Registered: July 2010
Location: Bangalore
Junior Member
Dear All,

I am trying to export the results from SIM application to excel in SIM 12.0. If number of rows is less than 65536 then no problem. If the number of rows is increased this limit then i couldnt open the excel file. It shows that "Cannot open the Excel file. It is corrupted."

I am using jxl.jar file for this Export to excel.

Please help me in this. Waiting for your kind reply..

Jagadeesan E.S.
Re: Export to Excel File [message #482484 is a reply to message #482483] Fri, 12 November 2010 00:03 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
As far as I can tell, Excel 2007 is capable of handling 1 M rows per sheet so, if you can afford to upgrade MS Office, that could solve the problem. Otherwise, no idea.
Re: Export to Excel File [message #482487 is a reply to message #482484] Fri, 12 November 2010 00:08 Go to previous messageGo to next message
jagadeesanes
Messages: 10
Registered: July 2010
Location: Bangalore
Junior Member
Thanks for your kind reply Mr. Littlefoot.

I am having MS Excel 2007 only. The error is in jxl.jar file only. if the number of rows less than 64k then no issues. If it exceeds that limit then only problem.

Please kindly help me on this.
Jagadeesan.
Re: Export to Excel File [message #482492 is a reply to message #482487] Fri, 12 November 2010 01:19 Go to previous messageGo to next message
Littlefoot
Messages: 21805
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:

The error is in jxl.jar file

Unfortunately, I can't help as I don't know anything about it. Hopefully, someone else will be able to provide assistance.
Re: Export to Excel File [message #482502 is a reply to message #482492] Fri, 12 November 2010 02:42 Go to previous message
jagadeesanes
Messages: 10
Registered: July 2010
Location: Bangalore
Junior Member
Thanks a lot for your kind effort...

Waiting for reply... Anyhow thanks once again..

Dear all, Please help me on this..

Jagadeesan
Previous Topic: Reg
Next Topic: WEBADI: How to increase message column width?
Goto Forum:
  


Current Time: Mon Mar 18 22:56:46 CDT 2024