-
Products and Technology
By Category
-
Groups
Activity Groups
Industry Groups
Influence and Feedback Groups
Interest Groups
Location Groups
Customer Only Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
Products
Learning and Support
-
- Products and Technology
- Groups
- Developers
- Partners
- Events
- Help Center
- Topic Pages
-
Explore SAP
- Explore SAP
-
Products
- Products
- SAP Business Suite
- Artificial Intelligence
- Business applications
- Data and analytics
- Technology Platform
- Financial Management
- Spend Management
- Supply Chain Management
- Human Capital Management
- Customer Experience
- SAP Business Network
- View products A-Z
- View industries
- Try SAP
- Partners
- Services
- Learning and Support
- About
- SAP Community
- Groups
- Interest Groups
- Application Development and Automation
- Discussions
- Re: Excel multiple sheet upload
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Excel multiple sheet upload
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Mar 02 4:52 PM
- SAP Managed Tags
- ABAP Development
Hi
I can upload a single worksheet from Excel into an internal table in SAP, but need to upload from complex excel worksheets ie. from multiple named tabs in Excel. Is this possible, and if so, please can you help and advise me how?
Many thanks
Sunni
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Mar 03 7:30 AM
- SAP Managed Tags
- ABAP Development
Hi,
I have done the same requirement of uploading from multiple sheets of a excel file into internal tables recently. Here is what I have done....
1. save the excel sheet as XML file.
2. use XML class (IF_IXML) and its corresponding methods to read the data.
This method is little complex as it requires a fair amount of knowledge in ABAP Objects.
Kamal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Mar 03 7:30 AM
- SAP Managed Tags
- ABAP Development
Hi,
I have done the same requirement of uploading from multiple sheets of a excel file into internal tables recently. Here is what I have done....
1. save the excel sheet as XML file.
2. use XML class (IF_IXML) and its corresponding methods to read the data.
This method is little complex as it requires a fair amount of knowledge in ABAP Objects.
Kamal
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎2005 Mar 03 11:21 AM
- SAP Managed Tags
- ABAP Development
I don't have much experience of ABAP objects (did the course last year & never used it since), and our requirement is quite urgent. I had hoped for an easier method, but if that's the only way then I'd like to try. Do you have sample code you could share with brief explanation of where to put the tab name please?
Kind Regards
Sunni
Bluesky