OraFAQ Forum: Weblogic & Application Server

Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Export to Excel File (SIM 12.0)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Export to Excel File [message #482483]

Thu, 11 November 2010 22:59

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.

Report message to a moderator

Re: Export to Excel File [message #482484 is a reply to message #482483]

Fri, 12 November 2010 00:03

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Export to Excel File [message #482487 is a reply to message #482484]

Fri, 12 November 2010 00:08

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.

Report message to a moderator

Re: Export to Excel File [message #482492 is a reply to message #482487]

Fri, 12 November 2010 01:19

Littlefoot
Messages: 21823
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.

Report message to a moderator

Re: Export to Excel File [message #482502 is a reply to message #482492]

Fri, 12 November 2010 02:42

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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 30 20:01:45 CST 2025