WriteSpreadsheet
Generate an OpenDocument Spreadsheet .ods file by injecting user inputted JSON data into a built-in template.
Last updated
Was this helpful?
Generate an OpenDocument Spreadsheet .ods file by injecting user inputted JSON data into a built-in template.
Task version: 1.0.0
Required Frends version: 5.7+
Required .NET version: 8.0
Compatible Agents: Crossplatform
Payload : String
JSON data array to be written into the file.
Default: -
Example: [ { "Name": "John", "Age": 40 }, { "Name": "Jane", "Age": 30 } ]
FilePath : String
Full path of the destination for the new .ods file.
Default: -
Example: C:\temp\foo.ods
ActionOnExistingFile : ActionOnExistingFile
Defines how the file write should work if a file with the new name already exists.
Possible values:
Overwrite: Defines how the file write should work if a file with the new name already exists.
Throw: Defines how the file write should work if a file with the new name already exists.
Default: 1
Example: ActionOnExistingFile.Throw
IncludeHeaderRow : Boolean
If true, the Task will recognise the keys of the JSON payload as headers and write them into the .ods file as the first row of the spreadsheet.
If false, the Task will only write the values of the JSON payload and not implement the keys as headers.
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
FilePath : String
Full path to the newly created .ods file.
Example: c:\temp\foo.ods
Error : Error
Error that occurred during task execution.
Example: object { string Message, Exception AdditionalInfo }
Changelog for Task Frends.Odf.WriteSpreadsheet.
Initial implementation
Last updated
Was this helpful?
Was this helpful?