How to Read two Column values of an Excel file and Store in a Datatable with two seperate columns


#1

Hi Guys,

I am trying to Read the Columns of Excel and Storing the data in Datatable by using AddRow activity but when i add them to the Datatable they are add in a single Column is there a way to Store the Values in two seperate columns in Datatable


#2

Hello!

You just have to pass the variables like a array. So each value will be inserted in a different column.

Example:

Regards,