Description
Tables are an ordered collection of rows and columns. They allow you to receive data from a file and save data to files in various formats, or work with data in memory without being bound to a file. Detailed work with tables is described in the article Table processing .
Creating a table
You can create a new table from the context menu Add action → Tables → table :
Or
Or use smart search .
The created table will be displayed in the static blocks panel:
Table settings
The main
Load from file
Take data for a table from a file;
If you DO NOT load a table from a file, then each thread will have its own, independent copy of the table.
Save table changes to file
The result of working with the table will be automatically saved to the linked file;
If you load data from a file, but did not enable the Save table changes to file setting, then for each thread its own local copy of the table will be created based on the specified file. Changes to the table within threads will not affect the linked file in any way.
If the Save table changes to file setting is enabled, then all threads will work with one copy of the table and all changes will be saved to the linked file.
Leave empty file
If all the data in the table runs out, should you leave an empty file or delete it.
Custom format
You can use either your own file format or choose one of the ready-made table formats.
If a ready-made file format is selected, then you can select additional settings for working with these formats:
First row headers
Use the first row of the table for headers;
Correct display of non-latin letters in Excel for .csv files
Parse data type (if possible)
Determine the data type in the content;
Separator for .csv format
Select he separator character “;“ or “,“
Please note that when linking a table to files .csv, .xls, .xlsx, .xlsm, .ods, the work goes only with the first sheet of the document
Line Separator
Specifies what should be used to separate table rows. As a separator, you can use “Enter“, any of your own separators or several separators.
Column Separator
Specifies what should be used to separate the table columns. As a separator, the character ";", the tabulation character "Tab", any of your own separators or several separators can be used.
File path
If you have selected to load a table from a file, you must specify the path to the table file. Data from it is loaded into the table at the start of the project.
If the path to the file is not known in advance and will be calculated only during the execution of the project, then you can use the Table processing action and its Bind to file function.
View the content
Allows you to fully view the contents of the entire table. In this section, you can enable the display of control characters, set a filter to search for the desired string and cell, and also use the filter constructor.
Detailed work with a table is described in the article Table processing .