ConvertToCSV
Converts Excel file to CSV.
Last updated
Was this helpful?
Converts Excel file to CSV.
Task version: 1.1.0
Required Frends version: 5.5+
Required .NET version: 6.0
Compatible Agents: Crossplatform
Path : String
Path to the Excel file.
Default: C:\tmp\ExcelFile.xlsx
Example: C:\tmp\ExcelFile.xlsx
ReadOnlyWorkSheetWithName : String
If empty, all work sheets are read.
Default: -
Example: Sheet2
CsvSeparator : String
Csv separator.
Default: ;
Example: ;
ThrowErrorOnFailure : Boolean
Choose if exception should be thrown when conversion fails.
Default: true
Example: true
DateFormat : DateFormats
Date format selection.
Possible values:
DEFAULT: Date format selection.
DDMMYYYY: Date format selection.
MMDDYYYY: Date format selection.
YYYYMMDD: Date format selection.
Default: 0
Example: Default
ShortDatePattern : Boolean
If set to true, dates will exclude timestamps from dates.
Default: false
Example: false
Success : Boolean
Conversion's status. False if conversion fails.
Example: false
CSV : String
Excel-conversion to CSV.
Example: "Foo,Bar,Kanji 働,Summa\r\n1,2,3,6\r\nKuva,1,2,3\r\n,,,\r\nFoo,,,\r\n,Bar,,\r\n"
ErrorMessage : String
Exception message.
Example: Error while converting Excel file to CSV
Changelog for Task Frends.Excel.ConvertToCSV.
Open Excel files with FileAccess.Read to support read-only files
Fixed Options.ShouldReadSheet method to check if the Sheet name equals to the given name.
Documentation updates
Initial implementation
Last updated
Was this helpful?
Was this helpful?