Column not found

[supermanPunch (Arpan)]

@helpplease

I’ve ticked “add headers” when i read range

Hi @helpplease ,

I believe you’re using the Write Cell activity, for that the error states that the column not found because the Write Cell would need the column names like A1, B1, C1, …

I believe you are missing a Step on converting the Datatable column name / the Column Name value that you have to a Excel Letter Column Name. Do check the post below, which also discuss the same topic :

Add 3 columns based on on existing columns

@ManjunathReddy , The above expression alone is not sufficient, You should also add the Index or row number to it. UiPath.Excel.Helpers.ExcelUtilities.ConvertColumnIndexToColumnLetter(DT.Columns.Count+1)+"1"