Excel File Format Problem while downloading in ALV...

Former Member · ‎03-31-2009

Hi All,

My program gives an ALV Grid Output which contains the file download button , when I choose spread sheet as the file format , the actual data starts only from 4th line and the lines above it contain date, heading etc and the rest are blank. Is it possible that I can download only the records in the grid output with the column names and not the unnecessary log?

Also the format is not proper excel format, this same file will be used for upload into another program using the Function Module 'TEXT_CONVERT_XLS_TO_SAP'. When I load the file saved in the above format, this Function Module always fails.

Please let me know any solution for this problem

Thanks in Advance.

Former Member · ‎03-31-2009

Installing SAP GUI Patch Level 8.

Former Member · ‎03-31-2009

Hi ,

Problem should be identified as Garbage values in Excel. There is a SAP note avaliable for this .

Which will be implemented when you will install SAP GUI patch level 8 on your machine.

This will surely resolve your issue.

Thanks

Former Member · ‎03-31-2009

Hi Dagny ,

Use XML Transformations to download ALV data to Excel and use FM

'ALSM_EXCEL_TO_INTERNAL_TABLE' to upload data from Excel to SAP.

Regards,

Suneel G

Former Member · ‎03-31-2009

The data which comes in the beginning is not junk data, even if we downloda from SE16, those lines appear, the lines for example are :

31.03.2009 Dynamic List Display 1

The first line is the above line, followed by two blank lines, then comes the column names, then again a blank line ( I do not want this blank line too ), then comes the actual data.

Hope this is clear. Are you talking about this data only ? Will it can be avoided by installing the patch you have mentioned?

Please let me know .

Thanks in Advance.

Former Member · ‎03-31-2009

This FM ''ALSM_EXCEL_TO_INTERNAL_TABLE' ' needs to specify the Begin and End column and Row which is not possible in our case as we do not know the amount of data in the excel file.

Former Member · ‎03-31-2009

Hi,

For using this function module: 'TEXT_CONVERT_XLS_TO_SAP'

You have to declare:




TYPE-POOLS truxs.

DATA: it_raw TYPE truxs_t_text_data.
*      internal table declared to be passed in the
*      function module used to convert data from xls to sap

*&---------------------------------------------------------------------*
*&Function module called to upload xls data into an 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_file                 "file path browsed
    TABLES
      i_tab_converted_data = it_upload[]            "int table populated
    EXCEPTIONS                                             with data
      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.

Hope it helps

Regards

Mansi

Former Member · ‎04-01-2009

Mansi,

I know how to use the TEXT_CONVERT_XLS_TO_SAP FM. My problem is not how to use this FM. Please read my first question.

Thanks.

Former Member · ‎04-01-2009

Hi

try this code----

&----

*& Form DOWNLOAD_EXCEL_TEMPLATE

&----

text

----

--> p1 text
<-- p2 text

----

FORM download_excel_template .

TYPES: BEGIN OF lt_data,

field1(20),

field2(30),

field3(20),

field4(20),

field5(20),

field6(30),

field7(15),

field8(10),

field9(10),

field10(20),

field11(20),

field12(10),

field13(20),

field14(20),

END OF lt_data.

DATA: lv_file TYPE rlgrap-filename,

li_data TYPE STANDARD TABLE OF lt_data,

wa_data TYPE lt_data,

lv_pathcheck type c,

lv_file1 type string.

wa_data-field1 = ''.

APPEND wa_data TO li_data.

REFRESH gi_header.

wa_header-name = 'Company Code'.