Excel Sheet Issues

[Kamesh]

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

[Divyashreem (Divyashree Muddagangaiah)]

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.

[Kamesh]

@Kamesh

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

how to copy the entire sheet to another sheet

[Divyashreem (Divyashree Muddagangaiah)]

use bala reva’s copy sheet activity.