Csv Scan
This activity can be used to read and write data from a Csv file.
Figure 1
Drag and Drop the Csv Scan activity from the Excel MS Excel automation package. Proceed to fill all pertaining details in the appropriate fields.
Figure 2
As mentioned above,you have an option to Read Data from the Csv file, as well.
Figure 3