Copying Excel data from one workbook to another

excel
uiautomation
activities
studio

#1

Hello,

I currently have a large excel workbook and want to divide up the data between sheets in another workbook.

I want to divide up the data based on company name. Would anyone know how to do this? I have searched the forum and could not find anything on it.

Thanks


#2

@Cormac, Here we have ,

Copy dataTable row to another dataTable

Regards,
Dom :slight_smile:


#3

Hi @Cormac,

I don’t know you got the solution or not. But the below activity can fix you problem. It has an activity called “Copy data”. It copies the data from excel.

Regards
Balamurugan.S