How to Map columns in a datatable to columns in a excel sheet

Hi,

I want to Map the columns in data table to a specific column in excel sheet. like column1 of data table need to column name “Location” in excel.

Thanks
Prasad Verma

@prasadverma.m

Welcome to forums

instead of using column 1 as below

row(1), you can make as row(“Location”)

So even the index changes you will get the column name

Thanks

Hi @ksrinu070184

I didn’t understand your answer.
I want data from data table to be loaded into excel sheet in below format.
DT_Sample
Name Age Location
xyz 23 India
ABC 47 US

Excel_Sheet
A B C D E
Name LastName Age Designation Location

How to map columns from DT_Sample to columns in Excel_Sheet as per the column names.
Write range is entering data in subsequent columns.

Thanks.