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
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: 

How to put information in the different tabs of same excel sheet

Former Member

‎10-13-2005 7:44 AM

0 Kudos

Hi all,

How to download information in the different tabs of same excel sheet.

EG data.xls is the excel sheet name

and sheet1 , sheet2 , sheet3 are different tabs of it.

Is there any standad function module for this .

If somebody is having idea abt it , Please guide.

Regards,

Shikha Jain

3 REPLIES 3

Former Member

‎10-13-2005 7:58 AM

0 Kudos

Hi Shikha,

You can do this by using the DOI interface for spreadsheets. Take a look at:

http://help.sap.com/saphelp_47x200/helpdata/en/e9/0be83b408e11d1893b0000e8323c4f/frameset.htm

Regards,

John.

Former Member

‎10-13-2005 8:07 AM

0 Kudos

Shikha;

Regards.

Where you want to download information.

If you want to upload it through BDC then every sheet is saved inm the tab delimited format so for every sheet you have to make a text (tab delimited file.

Siddarth

Former Member

‎10-13-2005 12:26 PM

0 Kudos

Hi,

Use this function module EXCEL_OLE_STANDARD_DAT for different worksheet( pivot table)

Thanks