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: 

download data from .XLSX file to internal tableusing OLE2 object

kamalakar_reddy2
Explorer

‎2012 Jan 27 10:25 AM

0 Kudos
370

Hi all,

Currently in my abap program is we are able to downlaod data from .xls excel file to internal table using OLE2 object.

But it is not doing the same with the .XLSX excel 2007 file.

I need to upload data from .XLSX file to internal table using OLE2 objects.

Is it possible ?. If yes kindly help me in solving this issue.

Thanks in advance,

Kamalakar

3 REPLIES 3

former_member205763
Active Contributor

‎2012 Jan 27 10:34 AM

0 Kudos
88

check these blogs: they refer to a SCN codex project abap2xlsx:

kamalakar_reddy2
Explorer
In response to former_member205763

‎2012 Jan 27 10:48 AM

0 Kudos
88

Hi Karthik,

Thanks for the information iam able upload data into .xlsx i need to download from .xlsx file to internal table

My requirment is end user wont have 2007 fomat installed in his system he just want to upload in to database tables using my program. is it possible ?

Thanks,

Kamalakar.

former_member205763
Active Contributor
In response to former_member205763

‎2012 Jan 27 11:26 AM

0 Kudos
88

Hi Kamalakar,

As i understand, your requirement is to read excel files to sap correct?

https://cw.sdn.sap.com/cw/groups/abap2xlsx

check this project: abap2xlsx which is sap to xlsx ofcourse, but in the source files of this project you also have xlsx reader.

check abap2xlsx code repository there you have one ZDEMO_EXCEL15 which mentions of a reader for xlsx files, see if you get any help from that.

Regards,

Kartik