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: 

How to get the data into ABAP internal tables from multiple sheets of an Excel sheet without OLE or classes/interfaces?

Former Member
0 Kudos
95

Hi Experts,

I have to read the data from multiple sheets.

I have gone through the links below to do the same also achieved the solution but very slow in retrieving the data.

http://wiki.scn.sap.com/wiki/display/Snippets/Read+multiple+sheets+of+an+Excel+file+into+SAP+through...

http://scn.sap.com/docs/DOC-40448

I tried with 6 rows and 6 columns in 2 sheet but it is taking too long to get the data into ABAP internal tables.

But in actual requirement, I have 2000 rows and 20 columns in each sheet. With this data it will definitely takes more time if I follow above approaches.

Can anyone suggest the alternative solution to get the data into ABAP internal table from multiple excel sheets with less time?

Thanks in advance.

3 REPLIES 3

custodio_deoliveira
Active Contributor
0 Kudos
40

Hi,

The best approach IMO is to use ABAP2XLSX:

Regards,

Custodio

0 Kudos
40

Hi Custodio,

Thanks for the quick reply.


I have referred the links provided and to get data from excel to ABAP internal table I have gone through the below link


http://scn.sap.com/people/alvaro.tejadagalindo3/blog/2009/02/05/excel-ole-and-abap--create-fancy-rep...


In this link I see that OLE has been used to get the data and this will not work out for me.


Could you please suggest the alternative?



Thanks and Regards,

Shailaja Chityala.

0 Kudos
40

Hi,

The link I provided IS an alternative. It does not use OLE; instead it uses the community project abap2xlsx.  There are many links in the end of the blog post where you can learn how to do what you need.

Regards,

Custodio