Imports data from a file in .xlsx (excel) and .csv format, into a section - table widget or spreadsheet.
Where you can use action:
Workflow, Button
Action step in workflow
Section in designer
Data in excel
Data imported into section
Differences in inserting data between editable and hidden cells
Note that cells must be editable in order to import values into them. When row modification is enabled, imported data is added in new rows. When modification is disabled, imported values are inserted into existing rows, but only in editable cells.
In a situation where the cell in the middle is not editable, all columns will be displayed, except for the column that has been set as non-editable.
Spreedsheet with Editable set row modification
Spreadsheet with a non-editable column
But, when a cell is hidden, the column is not skipped, but the values are shifted.
Parameters:
Section (type: text) - the name of the section into which the data will be imported
Attachment (type: text)(optional argument - only on button) - attachment type cell or section "Attachments" into which the file is to be imported
Number of header lines (type: number) - the number of lines to be skipped in the import into the section
CSV delimiter (type:text) - separator type
0 Comments