uploading excel file into the program

[Former Member]

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]

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

Regards,

Rich Heilman

[Former Member]

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]

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]

Hi,

check this..

http://www.sapdevelopment.co.uk/file/file_upexcel.htm

Regards

vijay

[Former Member]

also check this...

the Above is In OLE

Regards

vijay

[Former Member]

Hi Mohan,

Try Function module 'ALSM_EXCEL_TO_INTERNAL_TABLE'

Regards,

Raj