Excel Sheet Issues

Hi Guys

I am having an excel file with three columns
Name Salary Id

Using Assign acivity DB = Dt1.DefaultView.ToTable(true,“C”)

Getting only B column but while executing I am getting the below error I had the column name as “C” even if give the column name as “Id” in the assign activity same error

before get that table to defualt view try to read the excel and write that to another sheet along with header, so that you will get to know whats the header it is reading for.

1 Like

how to copy the entire sheet to another sheet

use bala reva’s copy sheet activity.