Add new excel row
Comments
-
Is there a step that can add a row into a designated excel file? I am interested in adding this to my flow.
-
Yes, the [b]Insert Row[/b] and [b]Delete Row[/b] steps will respectively add or remove a row in an Excel file.
For its File input, map that to the Excel file you wish to edit, and change the File Type inputs mapping type to Constant so you can select the files extension type via a dropdown menu. The Worksheet Number input asks which worksheet in the excel file is going to add/remove the row while the Row Number input designates the row number of the new row. Finally, the Ignore First Row input boolean toggles if you wish to count the first row which may/may not contain headers.
Howdy, Stranger!
Categories
- 4.1K All Categories
- 61 General
- 11 Training
- 201 Installation / Setup
- 1.1K Flows
- 106 Rules
- 260 Administration
- 212 Portal
- 489 General Q & A
- 693 Forms
- 333 Reports
- 3 Designer Extensions
- 47 Example Flows
- 51 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 178 Pages
- 5 Process Mining
- New Features
- 178 Datastructures
- 69 Repository
- 219 Integrations
- 28 Multi-Tenant
- 27 SDK
- 76 Modules
- 56 Settings
- 25 Active Directory
- 12 Version 7
- 35 Version 8
- 66 Lunch And Learn Questions