Reading second sheet of excel file while uploading

[Former Member]

Hello Freinds,

I want to read second sheet of an excel file while taking the data from excel file into an internal table.

Kindly help me with a FM which would take the sheet number too with the input OR a suitable option.

[Former Member]

Hello Freinds,

I want to read second sheet of an excel file while taking the data from excel file into an internal table.

Kindly help me with a FM which would take the sheet number too with the input OR a suitable option.

[Former Member]

Hi JAZZ,

It is possible.

Check the following link:http://www.sap-img.com/abap/uploading-multiple-multitab-excel-sheets-or-ranges.htm

Regards,

Vimal.

[Former Member]

Hi,

To Convert Excel file to Internal table use this FM.

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

may b it help u.

regards,

Archana

[Former Member]

Hi ,

Try these links:

Or

Try using this FM: 'TEXT_CONVERT_XLS_TO_SAP'

Thank You.

Regards,

Dhanalakshmi L

[Former Member]

Hi,

Try this link

http://www.sap-img.com/abap/upload-direct-excel.htm

Regards,

Manish

Edited by: MANISH GUPTA on Aug 4, 2009 8:38 AM