multiple xl sheets create and transfer to application server

[Former Member]

Guys,

I have 3 htm files in 3 different itabs and need to create single XL file with 3 different sheets and transfer into

application server.

Most of the example in the discussion group tells about how to save it in desktop which is of no use to me.

Could anybody has any solution?

Any help is highly appreciated.

REgards,

Harsha

[former_member215542]

You can achieve this only by using excel transformation. Refer the link below on how to do that

Once transformed, you would get a string which is actualy an excel file.

You can then use the steps in the link below to save the xml string to application server

https://scn.sap.com/thread/1504300

Hope this helps.

[Former Member]

HI Pulkit,

I need to create multiple sheets in an XL sheet, once the file is int he memory.

I can transfer the same to application.

Could you throw some  light on that?

REgards,

Harsha

[former_member215542]

Well yes, I do understand that you need to create an excel file with multiple worksheets...

Thats why I mentioned the first link, where you can use XSLT transformation to create an excel file with data in multiple worksheets

In that link, it is explained how to populate data from an internal table in worksheet 1, Look for tags between <Worksheet ss:Name="Sheet1"> </Worksheet>. You need to perform something similar between <Worksheet ss:Name="Sheet2"> </Worksheet> for the second internal table and you can continue this way till the number of internal tables you have or the max number of worksheet excel supports.