Hi All, I have a excel containing many different ID, how can I put each ID into a new sheet? I have attached excel for reference, sheet 1 is input and other sheets are expected result. Please noticed that actually I won’t know how many ID will be contained in sheet 1, therefore I wont know how ma…

Steps: Read Range Activity to read the data from Sheet1, saved in DataTable DT1 Integer Variable for setting the Sheet names, say intCounter (default value = 1) For Each Loop Activity for each row in DT1 DataTable variable, Assign Activity DT2 = new DataTable Assign Activ…

Thanks but error occur in assigning DT2 = row.CopyToDataTable ÇopyToDataTable’is not a member of 'System.Data.DataRow

Also I understand your concept but each ID may appear in many rows. Therefore we need to set condition to compare the value of first column

Add a row to DT1 with headers for filtering or add headers in the excel file directly For Each Loop Activity for each row in DT1 Assign Activity, intLookUpId = row(1) Filter Data Table Activity, Rows Filtering Mode, Keep Column: “I…

Hi @raymondhui Can you check this . It may useful to copy data and convert to data table. [image] BalaReva.Excel.Activities Community Feed Hi Friends, I have included some new activities in the “BalalReva.Excel.Actities”. Activities 1.Copy Data activity - It copies t…

Seperate datatable into different worksheets

Help

balupad14 (Balamurugan (BalaReva)) December 27, 2018, 9:57am 6

Hi @raymondhui

Can you check this . It may useful to copy data and convert to data table.

Regards
Balareva

Topic		Replies	Views
Create new excel sheet for every value in a DT Help	18	2484	July 27, 2019
How to copy mutiple rows into different excel sheets Studio studio , question , activities_panel	17	731	August 30, 2023
Convert two tables on one Excel sheet into separate datatables where row numbers are variable Help datatable , activities	3	4479	January 24, 2018
Copy dataTable row to another dataTable Help datatable , excel , activities	12	20998	October 14, 2018
How to create separate DataTables in a For Each Activity and extract these DataTables to separate sheets in Excel Help studio	4	1260	November 9, 2018

Seperate datatable into different worksheets

Related topics