This example contains a DataFlex workspace that via commandline parameters convert an existing excel workbook (xls(x) file) into chosen export formats. For example export all sheets to CSV files.
The example can run standalone or can be used to learn how to use Excel using COM
Convert Excel workbooks to different file format
For support go to:
Start the application and pass three commandline parameters. Ordering is not important. For the potential spaces in parameters surround each argument with double quotes
Arguments
"FILEFORMAT=OLExlCSV"
"SRC=c:\srcfolder\source.xlsx"
"DEST=c:\outputfolder\dest.csv"
The program exports each sheet in its own CSV file and puts the sheet number before the last dot in the destination file.
