CSV/Excel to data table and vice versa (with a step-by-step example)

In this section, we will see how to extract data from an Excel file into a data table and vice versa. We will achieve this by:

• Reading an Excel file and creating a data table using data from the Excel file
• Creating a data table and then writing all its data to an Excel file

Reading an Excel file and creating a data table by using data from the Excel file

We have an existing Excel file and we are going to use it in our project:

1. Drag and drop the Flowchart activity on the main Designer window. Also, drag and drop the Excel application scope inside the Flowchart.
2. Double-click on the Excel application scope. You have to specify the path of your workbook/Excel...