topic Re: Convert internal table to CSV format in Application Development and Automation Discussions

Convert internal table to CSV format

marisa_quaresma — Tue, 09 Nov 2010 17:28:28 GMT

Hi.

I have an internal table with 83 columns. And I am using the function SAP_CONVERT_TO_CSV_FORMAT to convert it to the CSV format. The problem is that in the excel file it only appears 26 columns have anyone faced this problem?

Re: Convert internal table to CSV format

Former Member — Tue, 09 Nov 2010 17:39:58 GMT

how are you getting the data into Excel?

Re: Convert internal table to CSV format

MrWhan — Tue, 09 Nov 2010 18:07:44 GMT

Are you using the semi-colon as your delimiter when opening the text file with Excel?

Re: Convert internal table to CSV format

former_member211627 — Tue, 09 Nov 2010 18:20:05 GMT

Hi, other thing that you can do is, create a internal table with a simple field with 2000 characters length. Fill this internal table with all the columns that you have separated by comma ",". Use the function to download the internal table "GUI_DOWNLOAD" and specify the file with CSV extesion.

When you open the file, it will be open with Excel.

Let me know is this helped you.

Regards

Jesus Martinez

Re: Convert internal table to CSV format

Former Member — Tue, 09 Nov 2010 18:23:27 GMT

Why don't you try with the function Download


DATA:  ZM_FICHERO(128),
             ZM_TIPO(3),
            ZM_TIPRES(3).

 CALL FUNCTION 'DOWNLOAD'
   EXPORTING  CODEPAGE    = SPACE
      FILENAME                        = 'C:\'
      FILETYPE                         = 'DAT'
       ITEM                                = 'REPORTE'
  IMPORTING  ACT_FILENAME     = ZM_FICHERO ' -->  Name of file to be saved
     ACT_FILETYPE     = ZM_TIPRES
       FILESIZE            = ZM_TAMANO   '--> size
  TABLES     DATA_TAB         = TI_DATA '--> ITAB 
  EXCEPTIONS INVALID_FILESIZE = 1
             INVALID_TABLA_WIDTH = 2
             INVALID_TYPE     = 3.

Re: Convert internal table to CSV format

Former Member — Tue, 09 Nov 2010 18:26:18 GMT

GUI_DOWNLOAD supports transfers up to 1024 bytes, not 2000...

Re: Convert internal table to CSV format

_IvanFemia_ — Tue, 09 Nov 2010 23:02:57 GMT

Hi,

why you do not export data in native excel?

try to read these blogs

[abap2xlsx - Generate your professional Excel spreadsheet from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20046] [original link is broken] [original link is broken] [original link is broken];

[xlsx2abap - Read and edit your Excel files from ABAP|http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20791] [original link is broken] [original link is broken] [original link is broken];

Code of this SCN Community project is shared on [Code Exchange|https://cw.sdn.sap.com/cw/groups/abap2xlsx]

Regards

Ivan

Re: Convert internal table to CSV format

Former Member — Wed, 10 Nov 2010 04:06:44 GMT

hi,

in that case you create a program in se38 then define your structure or table, define itab ,then use

loop at itab.

call function module download.

end loop.

in download function module uncomment exporting, file name, file type and infront it_tab=itab.

you get your all data.

use filetype as dat format

Sulabh

Edited by: sulabh agrawal on Nov 10, 2010 5:07 AM

Re: Convert internal table to CSV format

marisa_quaresma — Wed, 10 Nov 2010 09:55:20 GMT

Hi.

I am using the semicolon separator. However I cannot use the function guidownload or the download one, because I need to export this excel as an attach in an email. I cannot export in native excel since it was requested to send it in CSV format.

Re: Convert internal table to CSV format

marisa_quaresma — Wed, 10 Nov 2010 10:44:45 GMT

Thank you Jesús Martinez, your answer solved my problem. But I had to put a semi colon ';' intead of the coma.

Best regards,

Re: Convert internal table to CSV format

former_member211627 — Tue, 16 Nov 2010 21:30:29 GMT

You are welcome, we are here to help us. Any other question, please let me know.

Have a great day!

Re: Convert internal table to CSV format

SwarSneh — Fri, 04 Oct 2024 12:14:35 GMT

I have another issue with the FM SAP_CONVERT_TO_CSV_FORMAT. Everything works fine with this when we pass internal table as input but when we have uuid fields in the internal table, the output values do not appear properly. It comes as #﬍㻿必#쪞嗺賻 . Can anyone help here?