Frends.Excel.CreateFromCsv / 1.2.0
Summary
Writes a CSV file out as a real .xlsx workbook on a named sheet, rather than a delimited file that merely opens in Excel.
Typical use — reports meant for people to open, where column types and formatting should survive the handover
Essential parameters.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| SourcePath | String |
– | C:/workdir/data.csv |
Path to the .csv file. |
| SheetName | String |
– | FirstSheet |
Name of the sheet to write to. |
| Delimiter | String |
; |
; |
Delimiter. |
| DestinationFileName | String |
– | MyNewData |
Name of the file to write to. |
| DestinationDirectory | String |
– | C:/results |
Path to the folder where the file will be saved. |