Hi Guyz, hope you are doing well, So basically I want to write 6 rows in single excel sheet, if I have more than 6 rows to write, it should be written in new sheet within the same file. E.g if I want to write 8 rows, first 6 rows should be written on Sheet1 and the remaining in Sheet2. Like wise if…

@Daniyal_Tahir You can check this xaml table.xaml (12.7 KB) for the logic to create new sheet in the excel. It is also had skip and take logic as per your scenario.

@Daniyal_Tahir have a look on following links: for the concept: [image] Process repeated for each multiple rows Studio @christine.tzenghy let me introduce a general approach that can be also adopted to more case specific details. Assumptons: DataTable with 8 Rows Seg…

@ppr Its not adding on another sheet, will BalaReva activity of add sheet is feasible for this?

[image] Daniyal_Tahir: not adding on another sheet We can try with simple write range with new sheetname which will get created automatically if it is not there @Daniyal_Tahir

@aanandsanraj Its perfect logic. But the thing is my values are in System.Data.DataRow which I am unable to convert it in Integer.

@Daniyal_Tahir Instead data row use datatable variable. After read the excel pass the variable in that logic

@Daniyal_Tahir Logic is same a described in the links. It is just modified to write out the Excel Sheets Variables: [grafik] Flow: [grafik] Statements: NoOfSegments = Convert.ToInt32(Math.Ceiling(dtData.Rows.Count / SegmentSize)) segment = Enumerable.Range(0,NoOfSegments).ToList RowSet = dtD…

Adding Sheets till specific value

Help Activities

ppr (Peter Preuss) September 19, 2021, 7:35pm 2

@Daniyal_Tahir
have a look on following links:

for the concept:

other demo

Topic		Replies	Views
How to copy set of records to new sheet Studio studio , question , activities_panel	7	1019	September 14, 2022
Writing datatable into multiple excel Help datatable , excel , activities , question	4	1456	November 11, 2019
Write to another sheet if excel rows is full Forum question	12	1287	May 20, 2024
Copy Pasting Data From One Sheet To Another Activities excel , activities , studio	8	567	February 8, 2023
Create multiple sheets in excel file based on records Forum datatable , excel , question	1	1429	March 27, 2022

Adding Sheets till specific value

Related topics