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. |