APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Create multiple worksheets in one excel file from APEX

JessiMay 29 2013 — edited May 30 2013

Hi,

I very need help to create a custom multiple worksheets in one Excel file from APEX framework. I’ve been researching but can’t find answers.

What I try to accomplish is create a page that displays a chart, when a user click export data, the app. will export data and display data in excel spreadsheet. The excel spreadsheet will contain more than one worksheet (each worksheet contains specific data) and user can save the excel file. I’m thinking about buying 3rd party software ora_excle. Does anyone have suggestion of this product?

I download ora_excle trail version and create a function returns blob (http://stackoverflow.com/questions/12733336/create-xls-file-using-pl-sql-without-going-through-xml). The blob is excel file but I don’t know how to display in APEX. Could someone please help?

My current environment…

Apex 4.1.0
Database Oracle 11g
Excel 2010

Thanks,

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 27 2013

Added on May 29 2013

#apex-discussions

1 comment

1,807 views