.xls/.xlsx/.csv files are giving popup message while opening the file.

[Subbaka11]

I am using GUI_DOWNLOAD to download internal table data as Excel file, however while opening the file getting popup as 

"The file format and extension of ABC.xls’ don’t match. This file could be corrupted or unsafe. Unless you trust its source, don’t open it. Do you want to open it anyway?"

Can we remove this popup using ABAP coding? please let me know.

    CLEAR P_FILE .
    CONCATENATE P_FILE2 '\' LS_EKKO-EBELN '.xls' INTO P_FILE.
      CALL FUNCTION 'GUI_DOWNLOAD'
          EXPORTING
            filename              = P_FILE
            filetype              = 'ASC'
            write_field_separator = 'X'
          TABLES
            data_tab              = LT_PO_EXCEL
            fieldnames            = lt_header  .

[abo]

This has been asked countless times, please search the forum.

(asked AND answered, of course)

[Sandra_Rossi]

That's right, what's the reason to have a file named .xls although you create a file which is tab-delimited, not .xls. Search the forum if you don't understand what I'm saying.

[RaymondGiuseppi · Accepted solution]

Basically, Excel is warning you because you haven't generated an actual XLS, XLSX or CSV file with GUI_DOWNLOAD (or CL_GUI_FRONTEND_SERVICES=>GUI_DOWNLOAD).

• Use one of the tools that actually generates Excel or CSV files (FAQ)

[Subbaka11 · Accepted solution]

Hello Raymond,

Thanks for your response,

I have changed file name as .csv and passed below parameters to GUI_DOWNLOAD.

    CODEPAGE              = '4103'
    WRITE_BOM             = 'X'    REPORT  ZTRY_CSV.

TYPE-POOLS: truxs.
TYPES:
  BEGIN OF ty_Line,
    vbeln LIKE vbap-vbeln,
    posnr LIKE vbap-posnr,
  END OF ty_Line.

DATA: itab   TYPE table of ty_Line.

SELECT
  vbeln
  posnr
  UP TO 10 ROWS
  FROM vbap
  INTO TABLE itab.

CALL FUNCTION 'GUI_DOWNLOAD'
  EXPORTING
    filename              = 'D:\TEMP\DEMO1.CSV'
    filetype              = 'ASC'
    write_field_separator = ',' " OR 'X'
    CODEPAGE              = '4103'
    WRITE_BOM             = 'X'
  TABLES
    data_tab              = itab
*   fieldnames            =  lt_header  .
  . 

This code is generating Micro soft excel file with comma separator and creating separate columns for each field.

[RaymondGiuseppi · Accepted solution]

Actually, this is a text file with tab delimiter 😎

[Sandra_Rossi · Accepted solution]

@Subbaka11"this is a text file with tab delimiter" ... which is not intended to be used in a file named with the extension .xls (https://en.wikipedia.org/wiki/Microsoft_Excel "File formats -- Up until the 2007 version, Microsoft Excel used a proprietary binary file format called Excel Binary File Format (.XLS)")

[Subbaka11 · Accepted solution]

Hello Raymond, I using .csv extension and it is creating Microsoft excel comma separated values file, MS popup is also not coming. Will it create any issue? Please find the properties of downloaded file.

[RaymondGiuseppi · Accepted solution]

CSV is basically a text file format, so no problem should arise

[Sandra_Rossi · Accepted solution]

@Subbaka11 About "I using .csv extension and it is creating Microsoft excel comma separated values file", you don't understand, it's not because you use GUI_DOWNLOAD with a given file extension that SAP will choose the format inside the file. In Excel, a tab-delimited file is considered correctly if you use the extension .txt.txt. If you use the extension .csv, Excel will open the file by considering the tabs as part of one field. Windows says it's format CSV because of ".csv", not because of the format inside the file. Note that with WRITE_FIELD_SEPARATOR, GUI_DOWNLOAD can only generate a tab-delimited file (not CSV). The blank value is for no field separator at all, and ANYTHING NOT blank is for tab-delimited.

[RaymondGiuseppi · Accepted solution]

Consider using an FM such as SAP_CONVERT_TO_CSV_FORMAT or a class such as CL_SIMPLE_CSV_CONVERTER to generate an actual formatted CSV file.