topic Re: Create excel file with multiple sheet on application server in background in Application Development and Automation Discussions

Create excel file with multiple sheet on application server in background

Former Member — Sun, 04 Mar 2007 14:43:49 GMT

I have a requirement to run a batch job to create an excel file with multiple sheet from internal table, save the EXCEL file on application server (UNIX environment). I have searched the forum but most of these blogs mentioned about save the file on presentation server or using OLE method. Can this be done and how? Can some one send me some example

Thanks

Re: Create excel file with multiple sheet on application server in background

guillaume-hrc — Mon, 05 Mar 2007 10:54:29 GMT

Hi,

Without using tremendous efforts, you could generate XML that is readable by Excel in the newest versions.

Best regards,

Guillaume

Re: Create excel file with multiple sheet on application server in background

Former Member — Mon, 05 Mar 2007 10:59:19 GMT

Hello,

Check this thread:

If useful reward.

Vasanth

Re: Create excel file with multiple sheet on application server in background

Former Member — Tue, 06 Mar 2007 15:25:09 GMT

Thanks. But still it creates the excel with multi sheet on the PC not on UNIX side.

I can create regular excel file on UNIX but not EXCEL with multi sheet in background mode and store on application server.