Turn a .csv file into a .xlsx workbook. Quantities become numbers so they will sum, and reference numbers keep their leading zeros
Inputs
| Name | Type | Required | Default | Description |
|---|---|---|---|---|
CSV File Path csvPath | file | Required | — | — |
Excel File Path excelPath | file | Required | — | The .xlsx file to create |
Sheet Name sheetName | string | Optional | Sheet1 | — |
First Row Is Headings hasHeaders | boolean | Optional | true | — |
Delimiter delimiter | string | Optional | , | — |
Output Variable outputVariable | variable | Optional | ExcelFilePath | — |
Output
$outputVariableStringThe path of the workbook that was created
Compatibility
WindowsLinuxAttendedUnattended
Related activities
Close Excel Workbook
Save and close the Excel file
Convert Excel to PDF
Save the workbook, or one sheet, as a PDF
Execute Excel Macro
Run an automated macro inside Excel
Manage Named Ranges
Name a range so formulas can say =SUM(Sales) instead of =SUM(Sheet1!$B$2:$B$500), and keep meaning the right cells when rows are inserted
Recalculate Excel Formulas
Recalculate the workbook's formulas and save. Use after writing values other formulas rely on
Refresh Workbook Data
Run every query, connection and PivotTable cache in the workbook again, waiting for the background ones to finish before saving. Needs Windows with Microsoft Excel installed