Upload Excel with different Tabs contains data

[Former Member]

Hi All,

Is it possible to upload data into SAP from EXCEL file having 5 to 6 tabs containing data. All tabs data should go to different Internal tables or same internal tables.

Any help will be appreciated.

Regards

[Former Member]

Hi,

Use the fm:

ALSM_EXCEL_TO_INTERNAL_TABLE

eg:

types:  l_yprice_object_id type yprice_object_id.

DATA: itab TYPE STANDARD TABLE OF alsmex_tabline WITH HEADER LINE,
      filename type rlgrap-filename.

*  Set the path and filename to the file in filenet

  filename = 'C:\My Documents\..........'.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
  EXPORTING
    filename    = filename
    i_begin_col = 5
    i_begin_row = 2
    i_end_col   = 5
    i_end_row   = 10000
  TABLES
    intern      = itab.

Regards,

Subramanian

Edited by: Subramanian PL on Jul 25, 2008 11:32 AM

[Former Member]

Hi Subramanian,

Will this upload the data from the single excel sheet which is having Multiple spread sheets in it.

Can you please clarify my query.

Regards,

Venkatesh

[Former Member]

Hi,

Check these Threads...

[Different tabs|]

[Reading data from different tabs|]

Hi check this link

http://sap.ittoolbox.com/groups/technical-functional/sap-dev/downloading-excel-sheet-with-multiple-t...

Regards

Narin Nandivada

[former_member188685]

in SDN this is Discussed some time back.

checck the weblog