My goal is to read a range containing sheetnames in excel-sheet 1, and insert 7 empty rows in excel-sheet 2 which contains those sheetnames.
I have the following questions:
- Howto convert datatable column to array? How do I know what the columnname of the datatable is using assign to convert?
- Howto to let UIpath insert rows on every excelsheet of which the name is in the (converted) array? The 'insert/delete rows" activity needs a sheetname. How can you loop through the sheetnames which have been read?
If possible, please show me an example project, because I have difficulties placing the text answers in UIpath.
Thank you in advance,