conversion

[Former Member]

Hi,

this is vinod, actually i have one problem with conversion is,

actually my flatfile data is in excel but saved as .csv so while updating tht file it shows unerror....

how can solve this problem.

THIS IS URGENT PLZ GIVE ME REPLY ASAP

Message was edited by:

vinod kumar

[Former Member]

Hi Vinod,

Use this FM to get the data from excel sheet to Internal table

ALSM_EXCEL_TO_INTERNAL_TABLE

Regards

Arun

[Former Member]

Hi,

Do it like this,

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = l_w_filename

i_begin_col = l_w_begin_col

i_begin_row = l_w_begin_row

i_end_col = l_w_end_col

i_end_row = l_w_end_row

TABLES

intern = it_excel_table

EXCEPTIONS

inconsistent_parameters = 1

upload_ole = 2

OTHERS = 3.

IF sy-subrc <> 0.

MESSAGE ID sy-msgid TYPE sy-msgty NUMBER sy-msgno

WITH sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.

ENDIF.

ENDMETHOD. "data_upload

Then you have to arrange an Internal table as it comes in ROW, COLUMN and VALUE

Reward if useful!

[Former Member]

try this function module TEXT_CONVERT_XLS_TO_SAP'

[Former Member]

try with

TEXT_CONVERT_TEX_TO_SAP or

TEXT_CONVERT_XLS_TO_SAP or

TEXT_CONVERT_CSV_TO_SAP

Regards

Prax