Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

multiple xl sheets create and transfer to application server

Former Member
0 Kudos
296

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

3 REPLIES 3

former_member215542
Active Participant
0 Kudos
131

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.

0 Kudos
131

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

0 Kudos
131

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.