create excel file in background

[Former Member]

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.

[Former Member]

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

[Former Member]

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

or

loop at itab1.

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

append itab.

endloop.

''-->delemeter

[Former Member]

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

[andreas_mann3]

hi,

use that logic for splitting:

A.