Create excel file with multiple sheet on application server in background

[Former Member]

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

[guillaume-hrc]

Hi,

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

Best regards,

Guillaume

[Former Member]

Hello,

Check this thread:

If useful reward.

Vasanth

[Former Member]

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.