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.4K All Categories
- 81 General
- 13 Training
- 209 Installation / Setup
- 1.2K Flows
- 110 Rules
- 270 Administration
- 213 Portal
- 497 General Q & A
- 711 Forms
- 346 Reports
- 3 Designer Extensions
- 48 Example Flows
- 58 CSS Examples
- 1 Diagram Tile
- 7 Javascript Controls
- 187 Pages
- 5 Process Mining
- New Features
- 186 Datastructures
- 70 Repository
- 230 Integrations
- 29 Multi-Tenant
- 27 SDK
- 81 Modules
- 59 Settings
- 26 Active Directory
- 12 Version 7
- 35 Version 8
- 143 Lunch And Learn Questions