Community
Application Development and Automation 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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Creating the Multi Sheet dynamically in the EXCEL Sheet

Former Member

‎2006 Jul 18 1:03 PM

0 Likes
725

Hi experts,

i have developed one RFC to capture some DATA in one internal table.Atlast i am populating the data for the downloading in EXCEL format and also am seggregating some data by putting some heading called "no date report" and one more is "with data report".but its coming in one sheet with above 2 headings the data.but as per the Requirement,they want the 2 sheets for each heading should be created dynamically in the EXcel sheet in .Is there any standard FM to create the multi sheet in the EXCEL sheet dynamicaly???.

Any suggestion can be appreciated.

Thanx in Advance.

Regards,

HPP

Hi experts,

i have developed one RFC to capture some DATA in one internal table.Atlast i am populating the data for the downloading in EXCEL format and also am seggregating some data by putting some heading called "no date report" and one more is "with data report".but its coming in one sheet with above 2 headings the data.but as per the Requirement,they want the 2 sheets for each heading should be created dynamically in the EXcel sheet in .Is there any standard FM to create the multi sheet in the EXCEL sheet dynamicaly???.

Any suggestion can be appreciated.

Thanx in Advance.

Regards,

HPP

Reply
1 REPLY 1
Read only

Former Member

‎2006 Jul 18 1:06 PM

0 Likes
527

There is no standard code for the same.

The following thread has the code which will put data into multiple sheets

Regards,

Ravi

Note : Please mark all the helpful answers