topic Re: Excel multiple sheet upload in Application Development and Automation Discussions

Excel multiple sheet upload

Former Member — Wed, 02 Mar 2005 16:52:45 GMT

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

Re: Excel multiple sheet upload

Former Member — Thu, 03 Mar 2005 07:30:48 GMT

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

Re: Excel multiple sheet upload

Former Member — Thu, 03 Mar 2005 11:21:56 GMT

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