To start with I would like to say that I am new with UIPath and I still haven’t figured it out how to correctly work with it. I watched tutorials but none show exactly what I need.
Well, let’s dig in…
I have to read “input.xls” file, get its data(it has no headers), then make new “output.xls” file WITH headers and then insert data to it based on header name.
For example: I read whole data from input.xls, then create new DataTable with headers like: name,lname, age. After that I shall take whole column(like column ‘A’) and insert it into output.xls files column that has age header. Hope I wrote everything clearly.
Or to make it easier - How to take column ‘A’ from input.xls and insert into column ‘H’ to output.xls and if it is possible to name that column “add header” before inserting.
Or maybe there is same topic already with solution and someone can provide link to it?
Thank you in forward for any help!