topic Re: Create Excel file with Open Dataset in Application Development and Automation Discussions

Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 11:35:24 GMT

Hi,

I need to create a excel file from itab in background with OPEN DATASET...

Is it possible?

What do you do it?

Thanks!!!

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 11:37:55 GMT

No its not possible . You can go for CSV format later u can format it in excel.

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 11:39:14 GMT

Can you post the code for CSV format?

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 11:45:00 GMT

This message was moderated.

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 11:46:22 GMT

With GUI_DOWNLOAD I have error code_page in background.

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 11:47:08 GMT

CSV means a text file, where the columns are separated by a character ";".

The best way to change a list to CSV is to create an internal table in the ABAP, with the structure of the required CSV.

You have to fill in this internal table.

Use the Function Module SAP_CONVERT_TO_CSV_FORMAT to convert the internal table into Comma separated format then download this internal table using

open dataset .........

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 11:49:26 GMT

You cannot use GUI_DOWNLOAD it is used to download the file in presenattion layer , but your requirement is to create in application layer.

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 11:54:42 GMT

Hi Navenn ...

PLS READ THE QUESTION BEFORE ANSWERING.....??????????

Dont answer for points u r nothing to do with that!!What is the question and what are you answering ?

its reportd...already

Regards

Sas

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 13:11:46 GMT

Hello,

.CSV file carries the same property as .XLS file. So you can save your data in Application server with .CSV extension. All you need to to save the file with .CSV extension is seperate all the data of the fields with comma.

types: begin to ty_final,

line type string,

end of ty_final.

data: t_final type standard table of ty_final.

loop at itab in wa.

concatenate wa-field1

wa-field2

into wa_final-line separated by ','.

append wa_final to t_final.

endloop.

Transfer t_final to application server.

Hope it helps and does not makes you angry at me :-).

Thanks,

Jayant

Re: Create Excel file with Open Dataset

Former Member — Wed, 19 Nov 2008 14:27:29 GMT

Jayant Sahu Many many Thanksssssssss