topic conversion in Application Development and Automation Discussions

conversion

Former Member — Thu, 26 Jul 2007 05:23:58 GMT

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

Re: conversion

Former Member — Thu, 26 Jul 2007 05:41:02 GMT

Hi Vinod,

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

ALSM_EXCEL_TO_INTERNAL_TABLE

Regards

Arun

Re: conversion

Former Member — Thu, 26 Jul 2007 07:06:05 GMT

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!

Re: conversion

Former Member — Sat, 28 Jul 2007 02:58:01 GMT

try this function module TEXT_CONVERT_XLS_TO_SAP'

Re: conversion

Former Member — Sat, 28 Jul 2007 10:36:41 GMT

try with

TEXT_CONVERT_TEX_TO_SAP or

TEXT_CONVERT_XLS_TO_SAP or

TEXT_CONVERT_CSV_TO_SAP

Regards

Prax