hi, i would like to ask. i want to start my automation. i have one set of data but the data header start at second column and third row so there is a space. this is my problem to start my automation. is there any way for me to delete this?.attached my sample excel
Book1.xlsx (8.7 KB)
1.Use the read range activity, check the add headers as true and store the data in a variable.
2.Use the write range activity, check the add headers as true and write the data into a new sheet and all the empty rows above the header will be removed.
Output
Hope it helps!!
Hi,
You can use “Read Range” activity and pass the cell reference as “B5” as your data starts at second column’s fifth row. store the table in a variable and write it to excel using write range activity.
Thanks,
Hi, in my workbook, only have read range and write cell. can u assist on this?
hi, can u help me with the studio x worbook? i did not have read range workbook?
hi, how to pass the variable?
1.Use the read range activity, check the add headers as true and store the data in a variable.
2.Use the write range activity, check the add headers as true and write the data into a new sheet and all the empty rows above the header will be removed.
hope it helps!!
hi, i dont have read range workbook. this is my studio x
i dont have read range workbook
hi where do i need to mark the developer as true?
where do i need to go to check the dependencis?
no i never use anything in developer