topic Re: Class/methods used to read data from Excel in Application Development and Automation Discussions

Class/methods used to read data from Excel

Former Member — Thu, 06 Oct 2005 22:11:04 GMT

Hi,

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

Regards,

Vara

Re: Class/methods used to read data from Excel

RichHeilman — Thu, 06 Oct 2005 23:32:52 GMT

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

Re: Class/methods used to read data from Excel

RichHeilman — Thu, 06 Oct 2005 23:54:13 GMT

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

Re: Class/methods used to read data from Excel

Former Member — Fri, 07 Oct 2005 01:26:48 GMT

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

Regards,

vara