Excel
Actions for creating, reading and editing Excel workbooks and CSV files without opening Excel.
The Excel folder of the Process Designer toolbox works with .xlsx workbooks (and .xlsm), old .xls files and .csv files.
| Action | What it does |
|---|---|
| Export To CSV | Exports a list to a .csv file. |
| Export To XLSX | Exports a list to an .xlsx file. |
| Read Range from CSV | Reads a block of cells from a .csv file. |
| Split Workbook To CSV | Splits a sheet into several .csv files. |
| XLS To XLSX | Converts an old .xls file to .xlsx. |
| Create Workbook | Creates a new workbook with one sheet. |
| Get Sheet Names | Lists the sheets of a workbook. |
| Insert Sheet | Adds a sheet. |
| Rename Sheet | Renames a sheet. |
| Delete Sheet | Removes a sheet. |
| Apply Formula | Writes a formula into a range of cells. |
| Copy Paste | Copies a range to another sheet or workbook. |
| Get Named Range | Finds the sheet and cells of a named range. |
| Read Range | Reads the values and formulas of a range. |
| Get Last Used Row | Returns the last used row of a sheet. |
| Parse OLE Date | Turns an Excel date number into a date. |
| Split Workbook | Splits a sheet into several .xlsx files. |
The actions that change a workbook (Insert, Rename, Delete Sheet, Apply Formula, Copy Paste) use the same File variable for input and output: after the step it holds the changed file.