For the complete documentation index, see llms.txt. This page is also available as Markdown.

CreateFromCsv

Task to create an .xlsx file from data stored in .csv file

Task version: 1.2.0

Required Frends version: 5.7+

Required .NET version: 8.0

Compatible Agents: Crossplatform

Task Parameters

Name
Description

SourcePath : String

Path to the .csv file.

Default: - Example: C:/workdir/data.csv

SheetName : String

Name of the sheet to write to.

Default: - Example: FirstSheet

Delimiter : String

Delimiter.

Default: ; Example: ;

DestinationFileName : String

Name of the file to write to.

Default: - Example: MyNewData

DestinationDirectory : String

Path to the folder where the file will be saved.

Default: - Example: C:/results

Name
Description

ContainsHeaderRow : Boolean

This flag tells the reader if there is a header row in the CSV string.

Default: True Example: true

TrimValues : Boolean

This flag tells the reader to trim whitespace from the beginning and ending of the field value when reading.

Default: True Example: true

SkipRowsFromTop : Int32

If the CSV string contains metadata before the header row,

you can set this value to ignore a specific number of rows from the beginning of the csv string.

Default: 0 Example: 2

SkipEmptyRows : Boolean

A flag to let the reader know if a record should be skipped when reading if it's empty.

A record is considered empty if all fields are empty.

Default: False Example: false

IgnoreQuotes : Boolean

A flag to let the reader know if quotes should be ignored.

Default: False Example: false

AdjustColumnsToContents : Boolean

Adjusts the width of all columns based on their content.

Enabling this may cause high memory usage.

Default: False Example: false

FileExistAction : FileExistAction

What to do if the output file already exists.

Possible values:

  • Throw: What to do if the output file already exists.

  • Overwrite: What to do if the output file already exists.

  • Rename: What to do if the output file already exists.

Default: - Example: Throw

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

Task Result

Name
Description

Success : Boolean

Indicates if the task completed successfully. Example: true

OutputPath : String

Path to the output file. Example: C:/results/MyNewData.xlsx

Error : Error

Error that occurred during task execution. Example: object { string Message, Exception AdditionalInfo }

Error.Message : String

Summary of the error. Example: Unable to create file.

Error.AdditionalInfo : Exception

Additional information about the error. Example: object { Exception AdditionalInfo }

Task Changelog

Changelog for Task Frends.Excel.CreateFromCsv.

[1.2.0] - 2026-07-17

Changed

  • Updated copyright information to comply with Frends platform standards

[1.1.0] - 2026-02-23

Fixed

  • Ensure FrendsTaskMetadata.json is included in NuGet package

[1.0.0] - 2026-02-09

Added

  • Initial implementation

Last updated

Was this helpful?