ReadSpreadsheet
Receive an OpenDocument Spreadsheet .ods file and extract tabular data from the first sheet, converting it into JSON format.
Last updated
Was this helpful?
Receive an OpenDocument Spreadsheet .ods file and extract tabular data from the first sheet, converting it into JSON format.
Task version: 1.0.0
Required Frends version: 5.7+
Required .NET version: 8.0
Compatible Agents: Crossplatform
FilePath : String
Full path of the target .ods file to be read.
Default: -
Example: c:\temp\foo.ods
ContainsHeaderRow : Boolean
If true, the Task will recognise the first row of the .ods file as headers.
If false, the Task will treat the first row of the .ods file the same as all other rows.
Default: True
Example: true
ThrowErrorOnFailure : Boolean
Whether to throw an error on failure.
Default: True
Example: true
ErrorMessageOnFailure : String
Overrides the error message on failure.
Default: -
Example: Custom error message
Success : Boolean
Indicates if the task completed successfully.
Example: true
Data : Object
A JSON array containing one object per extracted spreadsheet row.
Example: [ { "Name": "John" }, { "Name": "Jane" } ]
Error : Error
Error that occurred during task execution.
Example: object { string Message, Exception AdditionalInfo }
Changelog for Task Frends.Odf.ReadSpreadsheet.
Initial implementation
Last updated
Was this helpful?
Was this helpful?