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: 

Class/methods used to read data from Excel

Former Member
0 Kudos

Hi,

I need a class/method to read data from an Excel Sheet. Please help me.

Regards,

Vara

1 ACCEPTED SOLUTION

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

You can use function module GUI_UPLOAD to upload the excel sheet into an internal table. You could also use OLE to read the spreadsheet. Check out this weblog. Make sure to check out the link to the reference guide at the bottom.

/people/rich.heilman2/blog/2005/09/12/manipulate-excel-with-ole-abap

Regards,

Rich Heilman

3 REPLIES 3

RichHeilman
Developer Advocate
Developer Advocate
0 Kudos

You can use function module GUI_UPLOAD to upload the excel sheet into an internal table. You could also use OLE to read the spreadsheet. Check out this weblog. Make sure to check out the link to the reference guide at the bottom.

/people/rich.heilman2/blog/2005/09/12/manipulate-excel-with-ole-abap

Regards,

Rich Heilman

0 Kudos

Sorry, I should have paid closer attention to your question. If you would like to use a class/method, you can also use the method GUI_UPLOAD of the class CL_GUI_FRONTEND_SERVICES.

Regards,

Rich Heilman

0 Kudos

that's fine. I used OLE....but I was not very sure about that...Thanks for your reply.

Regards,

vara