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

[Former Member]

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.

[custodio_deoliveira]

Hi,

The best approach IMO is to use ABAP2XLSX:

Regards,

Custodio

[Former Member]

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.

[custodio_deoliveira]

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