Comma-to-Point Export file

[matthijs-ys]

H guys I've got myzelf a little pickle over here.

I'm using a script, I plucked of the internet and adjusted slightly, that converts one os my worksheets in excel into separate XML files. The script does work perfectly however there is one isue. The values I use in Excel are devided with a comma -> 184,6mm. This needs to remain like this in excel due to exporting to steps as wel. However the XML files I'm exporting need to have values separation with a point -> 184.6mm.

This means that somewhere in my script I need a string that says so, but since I'm an engineer and not a IT specialist I cant figure this one out.. hoping you guys no something that might help me.

this is my current script:

Please Login or Register  to view this content.

[Parth007]

Please use code tags while posting code... (Press #)

You can try below one.. i dont know much still give it a try

Please Login or Register  to view this content.

[matthijs-ys]

Changed the Sheet names to Sheet3 (which is the sheet I am using) But sadly it stil doesn't work..

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[matthijs-ys]

Stil nothing but thnx for the reply..

[bulina2k]

Hello there!
You might need to change the system separator (regional settings) before writing in the text file. Check this out.

You should change the separator manually first to see if that resolves your problem.

[matthijs-ys]

The comma needs to remain as it is in the excel doc. Only the xml export file needs changed.