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

Help Studio
,
1

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

2

@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

5

Hi @Srini84

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.

6

Hello,
I have a very similar need to the issue presented by Prasad Verma. The one additional need that I have to Prasad’s original request is that I need to append (new row added to latest row) in the sheet. If you have a representative xaml for this issue that would be most appreciated.

Background: Data Table has 13 columns, Excel sheet has 48 columns - so need way to map data over.
Thank you!

7

Hi @DARREN_THOMPSON,

Can you brief your issue or share the sample excel, which would be easier to solve the issue.

Regards,
@90s_Developer