topic Converting .xls sheet into .csv sheet in Application Development and Automation Discussions

Converting .xls sheet into .csv sheet

Former Member — Thu, 07 Feb 2008 12:47:24 GMT

Dear All,

Is there any program available which will convert an excel sheet into .csv sheet.

If anyone has worked on this then please forward me the code for the same.

Regards,

N.Jain

Re: Converting .xls sheet into .csv sheet

Former Member — Thu, 07 Feb 2008 12:49:52 GMT

hi Nishu,

Check out this related thread

Regards,

Santosh

Re: Converting .xls sheet into .csv sheet

Former Member — Fri, 08 Feb 2008 06:09:59 GMT

Hi,

The above said link has put the data from excel sheet into the internal table. Does anybody has the sample code now to download the contents of internal table into csv sheet.

Regards,

N.Jain

Re: Converting .xls sheet into .csv sheet

Former Member — Fri, 08 Feb 2008 06:35:33 GMT

Hi Nishu,

Use the following code

data: fname type string value 'C:\file.csv'.

CALL FUNCTION 'GUI_DOWNLOAD'

EXPORTING

FILENAME = fname.

FILETYPE = 'ASC'

WRITE_FIELD_SEPARATOR = ','

TABLES

DATA_TAB = itab

EXCEPTIONS

FILE_WRITE_ERROR = 1

NO_BATCH = 2

GUI_REFUSE_FILETRANSFER = 3

INVALID_TYPE = 4

NO_AUTHORITY = 5

UNKNOWN_ERROR = 6

HEADER_NOT_ALLOWED = 7

SEPARATOR_NOT_ALLOWED = 8

FILESIZE_NOT_ALLOWED = 9

HEADER_TOO_LONG = 10

DP_ERROR_CREATE = 11

DP_ERROR_SEND = 12

DP_ERROR_WRITE = 13

UNKNOWN_DP_ERROR = 14

ACCESS_DENIED = 15

DP_OUT_OF_MEMORY = 16

DISK_FULL = 17

DP_TIMEOUT = 18

FILE_NOT_FOUND = 19

DATAPROVIDER_EXCEPTION = 20

CONTROL_FLUSH_ERROR = 21

OTHERS = 22

Here above declare file variable fname of type string and pass the file path. In the function module 'itab' is the internal table where you have data that needs to be exported to .csv file and make sure that you have given WRITE_FIELD_SEPARATOR = ',' which is comma separator.

Here I am assuming that you have taken data from excel sheet to internal table 'itab' using Santhosh posting message.

Regards,

yellappa.

Edited by: yellappa m on Feb 8, 2008 12:07 PM

Re: Converting .xls sheet into .csv sheet

Former Member — Fri, 08 Feb 2008 06:48:13 GMT

Use the FM SAP_CONVERT_XLS_TO_SAP to upload the data in the excel sheet and then convert the data into CSV format by using the FM SAP_CONVERT_TO_CSV_FORMAT.

And then use the FM GUI_DOWNLOAD to download the data .

Reward if helpful.

Thanks,

Avanish Joshi