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

always error uploading excel file

Former Member — Thu, 30 Jul 2009 01:56:13 GMT

Hi gurus,

I am trying to learn how to upload excel files into internal tables and do further processing from there.

I am basing my code from [here|http://www.sapdev.co.uk/file/file_upexcelalt2.htm] . And I created a simple 3-column text file like they did in the example.

When I run the program, it always says "error upload OLE". In the debugger sy-subrc becomes 2 which means "Error Uploading OLE". I don't know what's wrong. I've tried other methods of uploading excel files, but they also produce "error upload OLE".

Our office workstations run Openoffice 3. And I created the excel file using Open Office in XLS format.

Am I doing anything wrong? Do I need to have Excel installed in my workstation? What should I do?

Thanks much

-Mozart

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 02:21:16 GMT

Hi,

I never had an error using the fm ALSM_EXCEL_TO_INTERNAL_TABLE. But im also using Microsoft Excel...May be you really need to install it

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 03:03:04 GMT

Hi,

I have used same code in my system & it is working.

I think there is some thing wrong in your creation of Excel File.

Thanks & regards,

ShreeMohan

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 03:05:39 GMT

Did you use open office?

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 03:17:03 GMT

I am using Micrsoft Office.

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 03:40:16 GMT

Hi,

Try the following code:

DATA: lv_filetype(10) TYPE c,

lv_gui_sep TYPE c,

lv_file_name TYPE string.

lv_filetype = 'ASC'.

lv_gui_sep = 'X'.

lv_file_name = pa_dfile.

FM call to upload file

CALL FUNCTION 'GUI_UPLOAD'

EXPORTING

filename = lv_file_name

filetype = lv_filetype

has_field_separator = lv_gui_sep

TABLES

data_tab = gi_zhralcon_file.

Save the excel file as tabdelimited file and then execute the code.

it will help to solve your problem.

Regards,

Rajesh Kumar

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 04:38:00 GMT

Hi,

Check whether the excel sheet is open while execution of the program.

Regards,

Deepika

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 04:43:53 GMT

type-pools : truxs.

Internal table declaartion for excel file

data : it_raw type truxs_t_text_data.

Calling the function module to upload Excelsheet data to Internal table

call function 'TEXT_CONVERT_XLS_TO_SAP'

exporting

I_FIELD_SEPERATOR = 'X'

i_line_header = 'X'

i_tab_raw_data = it_raw

i_filename = p_flname " our excel file

tables

i_tab_converted_data = it_upload " our inetrnal table

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.

Please go through it and you can get the excel file data into our Internaltable

Edited by: polisetty pramod on Jul 30, 2009 6:43 AM

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 04:45:49 GMT

Hi,

Since you are using Open Office Excel, try these FM's to upload them


text_convert_xls_to_sap
KCD_EXCEL_OLE_TO_INT_CONVERT

They work for open office applications.

Regards,

Vik

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 04:55:18 GMT

Hi mrpena,

to upload from excel use FM: ALSM_EXCEL_TO_INTERNAL_TABLE.

you create one selection screen, where you need to give the file path, starting row & end row of the excel sheet

& starting & end column of the excel sheet.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'

EXPORTING

filename = po_file

i_begin_col = '1'

i_begin_row = '1'

i_end_col = '4'

i_end_row = '2'

tables

intern = i_file

EXCEPTIONS

INCONSISTENT_PARAMETERS = 1

UPLOAD_OLE = 2

OTHERS = 3

in i_final internal table you will get all the data from excel . then you need to transfer all the data from i_final to sap structure.

Hope you understand this well.

Regards,

Tutun

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 06:08:54 GMT

hii Mrpena,

Plz check whether internal table and excel are of same sequence or not .. It should be in same sequence

just try following code. it might help

Data T_TAB LIKE  STANDARD TABLE  OF FS_TAB.
SELECTION-SCREEN BEGIN OF BLOCK B1 WITH FRAME TITLE TEXT-001.
PARAMETERS: P_FILE1 TYPE IBIPPARMS-PATH OBLIGATORY.
 SELECTION-SCREEN END OF BLOCK B1.

AT SELECTION-SCREEN  ON VALUE-REQUEST FOR P_FILE1.
CALL FUNCTION 'F4_FILENAME'
   EXPORTING
     PROGRAM_NAME        = SYST-CPROG
*   DYNPRO_NUMBER       = SYST-DYNNR
     FIELD_NAME          = ' '
   IMPORTING
     FILE_NAME           = P_FILE1.
  CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
    EXPORTING
**   I_FIELD_SEPERATOR          =
***   I_LINE_HEADER              =
      I_TAB_RAW_DATA             = T_TAB
      I_FILENAME                 = P_FILE1
    TABLES
      I_TAB_CONVERTED_DATA       = IT_DATA[]  . "Your Internal Table body

after this Your internal table have all records from excel

Regards,

Apoorv

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 09:30:58 GMT

hi all.

installing Microsoft Office 2003 solved the problem. Inside the FM, you can see SAP calling EXCEL application. It seems when SAP reads the file, it first opens Excel, then copies from there.

Re: always error uploading excel file

Former Member — Thu, 30 Jul 2009 09:31:33 GMT

thank you for your replies