How to add headers in the data table

Help
1

how to add headers to a sheet which is headerless.
my excel sheet is like this
image

2

I want to add City Name on coulmn 1 and Index Value on Column 2 as Headers

3

@rajat_dhammi
lets assume you have read in the excel into a datatable. Add Headers was ticked Off, as no header cols were present in the Excel

the auto generated Column names can be changed by using an assign activity:
left side: YourDataTable.Columns(0).Columnname(0)
rightside: “YourNewColName” - City Name

4

I do not have headers in my sheet.
i have to add my own custom headers.
how to do that?

5

AddHeaders - When selected, the column headers from the specified spreadsheet range are also extracted. By default, this check box is selected (set to True).

taken from: https://docs.uipath.com/activities/docs/excel-read-range

when not ticked addd Headers the columnnames are generated automaticly
changing the columnnames can be done as described above

6

Bro, you do not understand my query.
i know we can select tick on add headers and it will generate automatically headers
But in the excel file , which i am working , there are not headers at all. How to add custom headers by our own

7

read range,
customize column name
write range

result is excel with headers

Or
insert a new row on first position and writing there the needed Column names into cells

1 Like
8

Thanks buddy

9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.