Database entities represent external databases which can be integrated with a flow. To add a database within the portal, navigate to the folder System > Designers > Integrations > Databases,...
Using the Split Excel Column component in a Flow, the data in an Excel spreadsheet’s column that is separated by a delimiter can be split into several columns and then displayed in a data grid or...
This tutorial demonstrates how to Create an Excel Document in the Flow. Additionally, this tutorial demonstrates how to apply different Styles to this Excel Document. Create New Excel File step can be...
This tutorial demonstrates how to use specific Steps in the Flow Designer to get values from an Excel Document, and how to Update values in the Excel Document (Set Values, Replace Values, Delete Row,...
This tutorial shows how to use Run Flow For CSV step. This step can be found in Data > List > Excel and CSV category in the ToolBox. Example: In this Example we will use Run Flow For...
This tutorial demonstrates how to convert data from Excel Document to a Simple List of Strings using CSV To List Mapping step from Data > List > Excel and CSV category in the ToolBox. Example: We...
This tutorial shows how to use CSV To List Mapping and List To CSV Mapping steps from Data > List > Excel and CSV category in the ToolBox. Example: In this Example we are going to create...
This tutorial demonstrates how to use CSV To Object Mapping step. This step can be found in Data > List > Excel and CSV category in the ToolBox. Example: In this Example we are going...
This tutorial demonstrates how to use For Each Excel Or CSV Row step. This step can be found in Data > List > Excel and CSV category in the ToolBox. Example: In this example we are going to create...
The Import Excel or CSV flow component loads tabular data from CSV or Excel-formatted files. The function of this step is to import an excel or csv file into a data type.
The Convert Excel to Csv component converts Excel-formatted tabular data to CSV format. To use the Convert Excel to Csv component in the Flow Designer, drag it to the workspace from the Components panel's Data > List > Excel and CSV category.
The Convert Csv to Excel component converts CSV tabular data to the Excel format. To use the Convert Csv to Excel component in the Flow Designer, drag it to the workspace from the Toolbox panel's Data > List > Excel and CSV category.
Using the Split Excel Column component in a flow, the data in an Excel spreadsheet's column that is separated by a delimiter can be split into several columns and then displayed in a data grid or converted into a CSV file.
The CSV Editor form component allows for the editing of CSV-formatted tabular data, such as a spreadsheet.
The Import Excel or CSV component iterates through the rows of a spreadsheet and attempts to create a data object from that row. The Import Excel or CSV component can be found in the Toolbox tab, under...