topic Re: uploading excel file into the program in Application Development and Automation Discussions

uploading excel file into the program

Former Member — Sun, 04 Feb 2024 06:10:59 GMT

Hi,

My excel file contains four sheets inside. Each sheet contains data.

When i upload this file using Function "UPLOAD" and data format of "DAT", how is the data transferred into internal table.

How is the data in various sheets of excel file is transfered into the internal table of the ABAP program.

Thanks for the response.

RichHeilman — Thu, 04 May 2006 18:56:45 GMT

I believe that you will need to use OLE in order to upload all four sheets.

Regards,

Rich Heilman

Former Member — Thu, 04 May 2006 19:02:02 GMT

I cannot tell you if it's possible to transfer all 4 sheets in 1-shot, but use this function module:

TEXT_CONVERT_XLS_TO_SAP

This converts data from 1 sheet to internal table.

Former Member — Thu, 04 May 2006 19:05:43 GMT

Hi,

Does all the 4 sheets contain same fields..

I guess the data for fields matching the internal table would be filled up properly..

n for the remaining it doesnt get filled in proper manner..

OLE would be a better solution for this.

Regards,

Tanveer.

Please mark helpful answers

Former Member — Thu, 04 May 2006 19:07:27 GMT

Hi,

check this..

Regards

vijay

Former Member — Thu, 04 May 2006 19:10:59 GMT

Hi Mohan,

Try Function module 'ALSM_EXCEL_TO_INTERNAL_TABLE'

Regards,

Raj

Former Member — Thu, 04 May 2006 19:11:55 GMT

also check this...

the Above is In OLE

Regards

vijay