topic Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE in Application Development and Automation Discussions

Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member — Fri, 14 Jun 2013 12:46:19 GMT

Hi All,

I am using FM named ALSM_EXCEL_TO_INTERNAL_TABLE in my report.

I am unable to upload one open office excel file.sy-subrc value is showing as 2(upload_ole).

Is it problem with open office?

The code is given below:-

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                = p_file
      i_begin_col            = 1
      i_begin_row            = 9
      i_end_col              = 123
      i_end_row              = 60000
    TABLES
      intern                  = it_excel
    EXCEPTIONS
      inconsistent_parameters = 1
      upload_ole              = 2
      OTHERS                  = 3.

Please let me know for any solutions.

Thanks and Regards,

Ati

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member — Fri, 14 Jun 2013 14:10:17 GMT

For open office it will not work. In excel or king soft it will work.

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member — Fri, 14 Jun 2013 15:18:27 GMT

Hi,

If you have open office in your system, then some basis settings need to be made. Try using MS Excel it is already integrated with SAP so no issues. In kingsoft the downloading will work fine, but i am not sure with uploading.

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member — Fri, 14 Jun 2013 18:54:35 GMT

Microsoft Office is integrated tightly with SAP frame work. Even Text Editors are sync to use the Word and its Underlying Options, That is the reason why text editor is opened as an MS word(if installed in your system). Similarly for Data Upload from legacy system, Excel is used and is more advisable as the mutual conversions happens easily

Use Excel file and the problem will be solved.

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member — Fri, 14 Jun 2013 19:02:34 GMT

Hello Ati,

What is the reason you need to upload the file while keeping it open? File must be closed before uploading. Close the thread if problem solved.

Prabir.

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

arindam_m — Sat, 15 Jun 2013 09:56:51 GMT

Hi,

I think Open Office integration is still not available you can try to save the excel in 2010 or older formats and try.

Cheers,

Arindam

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

former_member209120 — Sat, 15 Jun 2013 10:33:03 GMT

Hi Ati,

Save your openoffice(calc) file as .xls and try like this

TYPE-POOLS: TRUXS.

DATA: RAW_DATA TYPE TRUXS_T_TEXT_DATA.

DATA: BEGIN OF ITAB OCCURS 0,

COL1,

COL2,

COL3,

COL4,

END OF ITAB

CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'

EXPORTING

* I_FIELD_SEPERATOR =

* I_LINE_HEADER =

I_TAB_RAW_DATA = RAW_DATA

I_FILENAME = 'C:\openoffice.xls'

TABLES

I_TAB_CONVERTED_DATA = ITAB

EXCEPTIONS

CONVERSION_FAILED = 1

OTHERS = 2 .

Regards,

Ramesh.T

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

former_member209120 — Wed, 19 Jun 2013 04:08:55 GMT

Hi Ati,

Your problem solved or not?

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member — Wed, 19 Jun 2013 04:38:52 GMT

hi,

try use function module KCD_EXCEL_OLE_TO_INT_CONVER, it works for open office also.

if possible try creating the same file using Microsoft excel and try executing with your program..

regards..

anusha.

Re: Problem using ALSM_EXCEL_TO_INTERNAL_TABLE

Former Member — Wed, 19 Jun 2013 08:32:15 GMT

Hi,

Try using the FM TEXT_CONVERT_XLS_TO_SAP