topic Re: create excel file in background in Application Development and Automation Discussions

create excel file in background

Former Member — Mon, 17 Jul 2006 06:39:23 GMT

hello all,

i need to create an excel file in a background.

i use open dataset....and it is create a file but the problem is that it put all data in one column.

is anyone know how can i split the data to a few colomns?

thanks in advanced.

dana.

Re: create excel file in background

Former Member — Mon, 17 Jul 2006 06:41:35 GMT

you can move the file to your prez server using transaction ..CG3Y.

loop at itab1.

SPLIT itab1 AT '' INTO itab-field1 itab-field2 itab-field3 .

append itab.

endloop.

''-->delemeter

Re: create excel file in background

Former Member — Mon, 17 Jul 2006 06:43:45 GMT

Hi Dana.

We modify our internal table before the open dataset command. In the new table we have one char(2000) field in which all columns out of the first table separated by a cl_abap_char_utilities=>horizontal_tab are concatenated.

I hope this info is helpful for you.

wbr

Michael

Re: create excel file in background

andreas_mann3 — Mon, 17 Jul 2006 08:24:45 GMT

hi,

use that logic for splitting: