topic Re: Error in bdc. in Application Development and Automation Discussions

Error in bdc.

Former Member — Tue, 29 Dec 2009 06:54:53 GMT

Hi all,

I am getting an error excel file cannot be processed while using function TEXT_CONVERT_XLS_TO_SAP to upload an excel file.

Can anyone help me in resolving it.

Thanks in advance,

Neela

Re: Error in bdc.

vinod_vemuru2 — Tue, 29 Dec 2009 07:01:41 GMT

Hi,

Make sure that the excel is closed before upload. I hope you are using .xls file. If you are using office 2007 it saves the file as .xlsx by default. Convert this to 2003 format and upload.

Your subject and actual question are no where matching. Please use proper subject to get fast responces

Thanks,

Vinod.

Edited by: Vinod Kumar Vemuru on Dec 29, 2009 12:32 PM

Re: Error in bdc.

Former Member — Tue, 29 Dec 2009 07:04:06 GMT

Hi Vinoth,

It is 2003 and not 2007.

Re: Error in bdc.

vinod_vemuru2 — Tue, 29 Dec 2009 08:26:58 GMT

Hi,

Can you post the piece of code for upload? Are you getting any exceptions from FM or error message?

Thanks,

Vinod.

Re: Error in bdc.

Former Member — Tue, 29 Dec 2009 09:07:16 GMT

Maybe u can use this part of code;


  DATA: lv_file TYPE rlgrap-filename value 'sample.xls'.
  DATA: t_internal TYPE zalsmex_tabline OCCURS 0 WITH HEADER LINE.

  CALL FUNCTION 'Z_ALSM_EXCEL_TO_INTERNAL_TABLE'
    EXPORTING
      filename                      = lv_file
      i_begin_col                   = 1
      i_begin_row                   = 3
      i_end_col                     = 16
      i_end_row                     = 65536
    TABLES
      intern                        = t_internal
*   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.

Re: Error in bdc.

Former Member — Tue, 29 Dec 2009 09:10:32 GMT

Hi,

Use the function module as shown below.

CALL FUNCTION 'ALSM_EXCEL_TO_INTERNAL_TABLE'
      EXPORTING
        filename                = l_file
        i_begin_col             = 1  "Begin of COLUMN
        i_begin_row             = 2  "Begin of ROW
        i_end_col               = 256  "End of COLUMN
        i_end_row               = 65536  "End of ROW
      TABLES
        intern                  = t_intern   "Internal Table for Excel-Data
      EXCEPTIONS
        inconsistent_parameters = 1
        upload_ole              = 2
        OTHERS                  = 3.

Re: Error in bdc.

Former Member — Thu, 31 Dec 2009 05:46:16 GMT

Thank u all my issue is resoved,

Regards,

Neela