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
- 2.1K All Categories
- 18 General
- 155 Installation / Setup
- 991 Flows
- 86 Rules
- 203 Administration
- 204 Portal
- 433 General Q & A
- 600 Forms
- 282 Reports
- 3 Designer Extensions
- 38 Example Flows
- 32 CSS Examples
- 1 Diagram Tile
- 5 Javascript Controls
- 139 Pages
- 1 Process Mining
- New Features
- 150 Datastructures
- 50 Repository
- 169 Integrations
- 25 Multi-Tenant
- 21 SDK
- 40 Modules
- 38 Settings
- 20 Active Directory
- 12 Version 7
- 34 Version 8