Copying Excel data from one workbook to another

[Cormac (Cormac White)]

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

[Dominic (Dominic Arul Collins)]

@Cormac, Here we have ,

Copy dataTable row to another dataTable - #2 by Sachin_Desai

Regards,
Dom

[balupad14 (Balamurugan)]

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.

BalaReva.Excel.Activities

Hi Friends, I have included some new activities in the “BalalReva.Excel.Actities”. Activities 1.Copy Data activity - It copies the data from Excel Sheet to the clipboard 2.Delete Data activity - It deletes the data in the Excel Sheet 3.Clipboard To Datatable activity - It converts the clipboard to Datatable Namespace [image] 1.Properties Copy Data activity [image] Sample File : CopyData.zip (8.1 KB) 2.Properties of Delete Data activity [image] Sample : DeleteData.zip (6.9 KB) 3.…

Regards
Balamurugan.S