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

uploading excel file

Former Member — Fri, 25 Jun 2010 09:06:18 GMT

hi experts,

i had an requirement to upload excel file data to bdc and i found an example but in that why we will use the type-pools truxs

and there r two records but while uploading it is showing only the second record

Edited by: k.vinu.karthik on Jun 25, 2010 11:07 AM

Re: uploading excel file

Former Member — Tue, 29 Jun 2010 08:48:35 GMT

Hi,

try to use the FM ALSM_EXCEL_TO_INTERNAL_TABLE . This will transfer the data from excel file to an internal table ...which further u can use.

Thanks & regards,

Preetesh

Re: uploading excel file

OttoGold — Tue, 29 Jun 2010 09:34:13 GMT

Check the FM mentioned in the blog: /people/otto.gold/blog/2010/06/23/happy-reporting-with-excel-iii-there-and-back

FUNCTION text_convert_xls_to_sap.

Otto

Re: uploading excel file

Former Member — Tue, 29 Jun 2010 10:16:14 GMT

Hi,

The example you have seen there the FM TEXT_CONVERT_XLS_TO_SAP is used to upload the data from excel file.

The type-pools truxs is used because, the type of export parameter of the FM is defined in the type-pools truxs.


  CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
*   I_FIELD_SEPERATOR          =
      i_line_header              = 'X'    " If your excel file has header then put X, otherwise leave blank
      i_tab_raw_data             = it_raw
      i_filename                 = p_v_file
    TABLES
      i_tab_converted_data       = p_it_data
 EXCEPTIONS
   conversion_failed          = 1
   OTHERS                     = 2
            .
  IF sy-subrc <> 0.
    MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno
            WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  ENDIF.

You have passed value 'X' to parameter i_line_header, so the 1st line is not displaying.

Regards

DKS

Re: uploading excel file

Noorie — Thu, 01 Jul 2010 09:47:50 GMT

Hi,

There are may function modules for load data from Excel to SAP internal table.

few of them are

1. 'TEXT_CONVERT_XLS_TO_SAP'.

2. ALSM_EXCEL_TO_INTERNAL_TABLE,

3. GUI_UPLOAD with delimited as tab.

sample code:

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING
FILENAME = P_FILE
I_BEGIN_COL = '1'
I_BEGIN_ROW = '3'
I_END_COL = '300'
I_END_ROW = '5000'
TABLES
INTERN = EXCL
EXCEPTIONS
INCONSISTENT_PARAMETERS = 1
UPLOAD_OLE = 2
OTHERS = 3.

LOOP AT EXCL.

CASE EXCL-COL.
WHEN '0001'.
WA_MAIN-MATNR = EXCL-VALUE.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
INPUT = WA_MAIN-MATNR
IMPORTING
OUTPUT = WA_MAIN-MATNR.

WHEN '0002'.
WA_MAIN-AENNR = EXCL-VALUE.
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
EXPORTING
INPUT = WA_MAIN-AENNR
IMPORTING
OUTPUT = WA_MAIN-AENNR.
WHEN '0003'.
WA_MAIN-WERKS = EXCL-VALUE.
WHEN '0004'.
WA_MAIN-VERID = EXCL-VALUE.
WHEN '0005'.
WA_MAIN-TEXT1 = EXCL-VALUE.
WHEN '0006'.
WA_MAIN-ADATU = EXCL-VALUE.
WHEN '0007'.
WA_MAIN-BDATU = EXCL-VALUE.
WHEN '0008'.
WA_MAIN-PLNTY = EXCL-VALUE.
WHEN '0009'.
WA_MAIN-PLNNR = EXCL-VALUE.
WHEN '0010'.
WA_MAIN-ALNAL = EXCL-VALUE.
WHEN '0011'.
WA_MAIN-STLAL = EXCL-VALUE.
WHEN '0012'.
WA_MAIN-STLAN = EXCL-VALUE.
ENDCASE.

AT END OF ROW.
APPEND WA_MAIN TO IT_MAIN.
CLEAR : WA_MAIN.
ENDAT.
ENDLOOP.