SetConnect

ExportXLS2CSV

File::ExportXLS2CSV
Description
Exports an Excel spreadsheet to a CSV-file.

Note-1: Requires Microsoft Excel to be installed!

Note-2: If you get the following error: "SaveAs method of Workbook class failed" try the following:

On x64: create the following folder: C:\Windows\SysWOW64\config\systemprofile\Desktop
On x86: create the following folder: C:\Windows\System32\config\systemprofile\Desktop
Options
Excel file
The MS-Excel workbook (xls file).
Sheet Name
The name of the sheet that must be exported. If left empty, the default sheet will be exported.
CSV output file
The CSV output file.
Always Overwrite
When checked, will overwrite the outputfile if it already exists.
Auto Create Directories
When checked, will automatically create all directories of the outputfile.
Skip First Record
When checked, the first record (row) of the excel file will not be exported.
Append
When checked, the exported data will be appended to the outputfile.
Always Quote Values
When checked, the values in the csv file will always be quoted.
Use System List Separator
Uses the "List Separator" as defined in the Regional Settings as the column separator sign.
Use Custom Separator
Uses the specified custom separator sign as the column separator.
Skip Rows
Skip the configured rows in the output.
Skip Columns
Skip the configured columns in the output.

Documentation

Release notes