Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Saving excel file as .csv via OLE program

Former Member
0 Kudos

Hi all,

in my abap OLE program i'd like to save an excel file as .csv file with ";" separator according to the frontend settings. Unfortunately the file is saved with "," separator (and not ";").

Here is the code:

<<...

call method of e_newappl 'SAVEAS'

exporting

#1 = path

#2 = '23' ....>>

I also tried 6, 22, 24 as #2 parameter values, with the same result. Running the program in differents workstations (all with ";" separator in the general settings) sometimes i get a file with ";" and sometimes with ",".

Is there a way to always get the .csv file with ";"? Or at least to check what separator will be used?

Thanks for replies.

1 REPLY 1

Former Member
0 Kudos

hi,

please check this similar thread for the answer

thanks