ConvertToJSON
Converts Excel file to JSON. https://tasks.frends.com/tasks/frends-tasks/Frends.Excel.ConvertToJSON
Last updated
Was this helpful?
Converts Excel file to JSON. https://tasks.frends.com/tasks/frends-tasks/Frends.Excel.ConvertToJSON
Task version: 2.2.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: Sheet1
UseNumbersAsColumnHeaders : Boolean
If set to true, numbers will be used as column headers instead of letters (A = 1, B = 2...).
Default: false
Example: true
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: DDMMYYYY
ShortDatePattern : Boolean
If set to true, dates will exclude timestamps from dates.
Default false
Default: false
Example: true
Success : Boolean
Indicates if the conversion was successful.
Example: true
ErrorMessage : String
Exception message.
Example: An error occurred...
JSON : String
Excel-conversion to JSON.
Example: "{"workbook":{"workbook_name":"ExcelTestInput2.xls","worksheet":{"name":"Sheet1","rows":[{"RowNumber":1,"Cells":[{"ColumnName":"A","ColumnIndex":1,"ColumnValue":"Foo"},{"ColumnName":"B","ColumnIndex":2,"ColumnValue":"Bar"},{"ColumnName":"C","ColumnIndex":3,"ColumnValue":"Kanji働"},{"ColumnName":"D","ColumnIndex":4,"ColumnValue":"Summa"}]}]}}}"
Changelog for Task Frends.Excel.ConvertToJSON.
Open Excel files with FileAccess.Read to support read-only files
Updated the Newtonsoft.Json package to the latest version.
Change how the Json is constructed.
Added CancellationToken to the Task.
Refactored code to be more simple.
Added two helper classes Row and Cell.
Updated the documentation with better descriptions and examples.
Nuget package should not contain the FrendsTasksMetadata.json files.
Initial implementation
Last updated
Was this helpful?
Was this helpful?