How to add new fields dynamically in to datatable

excel

#1

i want to get the format like


#2

now im getting the format like below


#3

which function you are using to add values to excel sheet from data table…

if you are using write range by default it will start from 1st row


#4

ya …im using write range…


#5

is there any solution to add new fields in the top of the file??


#6

if you are using write range, whats the starting row you have mentioned to add data to new excel sheet.


#7


#8

you said you need to add dynamic field value to excel sheet, in first post you have given screenshot. it looks like a some template sheet.

you want to add field(COLUMN …?) at the end of the table or something.?


#9

UiPath.Excel.Activities.ExcelInsertColumn

Inserts a new column into a table. If no position is specified, the column is inserted at the end of the table. Can only be used in the Excel Application Scope activity.


#10

Okay…
I will try this…

Thank you…