Skip to Content
0
Former Member
Jun 02, 2008 at 03:49 AM

Add header in FM SAP_CONVERT_TO_XLS_FORMAT

4201 Views

Hi

I am using fm SAP_CONVERT_TO_XLS_FORMAT to download data to excel. I want to add header in excel.pls help me.

CALL FUNCTION 'SAP_CONVERT_TO_XLS_FORMAT'
  EXPORTING
   I_FIELD_SEPERATOR          = 'X'
*   I_LINE_HEADER              = t_header
    i_filename                 = p_pcfile
*   I_APPL_KEEP                = ' '
  tables
    i_tab_sap_data             = it_material
* CHANGING
*   I_TAB_CONVERTED_DATA       =
 EXCEPTIONS
   CONVERSION_FAILED          = 1
   OTHERS                     = 2