Need help doing changes in Excel
Comments
-
We are trying to read and edit an excel file using Decisions.
We need your help in achieving below tasks :- Copying entire row from excel along with styles and formatting and pasting it in a specified location.
Reading data from a checkbox" control
- Copying entire row from excel along with styles and formatting and pasting it in a specified location.
-
This documentation may be what you are looking for here: [url=https://documentation.decisions.com/edit-update-excel-document/]https[/url][url=://documentation.decisions.com/edit-update-excel-document/]://documentation.decisions.com/edit-update-excel-document/ [/url]
1. Copying entire row from excel along with styles and formatting and pasting it in a specified location. I have attached 2 examples that showcases how to interact with Excel/CSV. The one that is more in tune with what you are looking for is called Get Row Flow. This flow takes in the Excel sheet, gets the row that you specify, and sets the value on the row that you want to specify. I believe this is what you are looking for, if not please let me know. The second example showcases how to use the CSV to list mapping step. This flow creates a new csv file after you have decided to add a new row in the first and second forms. Both of these flow include send email steps in which you will have to put your email to verify the reuslts that you are looking for here.
2. Reading data from a “Check box” control, i.e. knowing whether the Checkbox is checked or not. This request has come in previously. Currently there is a feature request to have this ability, but this is slated for future releases. However; if you edit the settings of the checkbox in excel you can link it to a cell. This cell will now either have TRUE or FALSE depending on if the check box is selected. You can then read this value with Decisions.
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