Saving a CSV-file as a Excel-file
Posted: Thu Dec 19, 2019 12:50 pm
Hello,
I'm starting from a CSV-file which I need to save as an Excel-file (XLS).
I'm trying to this by using these code :
I need to have the fields seperated. How can I establish that?
Thanks a lot in advance for any help.
I'm starting from a CSV-file which I need to save as an Excel-file (XLS).
I'm trying to this by using these code :
- Code: Select all Expand view
- * cBest = CSV-file
oBook := oExcel:WorkBooks:Open(TRIM(cBest))
oBook:SaveAs("Test.xls")
oBook:Close()
oBook := oExcel:WorkBooks:Open("Test.xls")
I need to have the fields seperated. How can I establish that?
Thanks a lot in advance for any help.