I just want In existing excel sheet add some more in only column name header .I trying to achieve like this as mentioned in attachment.But this is not work I am not sure it will work or not.So can any one tell me this will work or not or how to achieve this
Are you adding columns or renaming existing columns? If you are renaming column 37 in your example, that syntax should work fine. If you are trying to add columns, you should receive an error, what is it?
NO I did not receive any error but my requirement is to add new column in existing excel sheet.only header(column name) not data.But this not work for me
If you are adding it to an excel sheet, and your data is in a table…then use this activity:
If it is not saved as a table, just use the write cell activity and write the column header to the next available cell in row 1.