Class/methods used to read data from Excel

[Former Member]

Hi,

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

Regards,

Vara

[Former Member]

Hi,

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

Regards,

Vara

[RichHeilman]

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

[RichHeilman]

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

[Former Member]

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

Regards,

vara