Merged cells from excel file

[ramshiva_reddy]

Hello All,

I have downloaded a file from an website. It has few columns merged, just like we find merge& center in excel. Column- A,B,C and Column- E,F,G,H. How can I unmerge them?
Please help me with this issue.

[mkankatala (Mahesh Kankatala)]

Hi @ramshiva_reddy

You can use Read range workbook activity to store the data in to the datatable.
In the read range workbook give the cell range as “A:C”
Then use write range workbook activity to write the datatable to excel. Then it will write the A,B,C columns in one excel.

Do the same for Column E,F,G,H then give the cell range as “E:G”

Hope it helps!!

[ramshiva_reddy]

Thank You bro. It worked

[mkankatala (Mahesh Kankatala)]

Thank you @ramshiva_reddy

Happy Automation!!