Dec 22 2021 12:16 AM
hi Friends,
i have following sample data(more than 50000 records are there)
rollno | name |
1 | xya1 |
2 | xya2 |
3 | xya3 |
4 | xya4 |
5 | xya5 |
6 | xya6 |
7 | xya7 |
8 | xya8 |
9 | xya9 |
10 | xya10 |
11 | xya11 |
12 | xya12 |
13 | xya13 |
14 | xya14 |
15 | xya15 |
16 | xya16 |
17 | xya17 |
18 | xya18 |
19 | xya19 |
20 | xya20 |
21 | xya21 |
22 | xya22 |
23 | xya23 |
24 | xya24 |
25 | xya25 |
26 | xya26 |
27 | xya27 |
28 | xya28 |
29 | xya29 |
30 | xya30 |
31 | xya31 |
32 | xya32 |
33 | xya33 |
34 | xya34 |
35 | xya35 |
36 | xya36 |
37 | xya37 |
38 | xya38 |
39 | xya39 |
40 | xya40 |
41 | xya41 |
42 | xya42 |
43 | xya43 |
44 | xya44 |
45 | xya45 |
46 | xya46 |
47 | xya47 |
48 | xya48 |
49 | xya49 |
50 | xya50 |
51 | xya51 |
52 | xya52 |
53 | xya53 |
54 | xya54 |
55 | xya55 |
56 | xya56 |
57 | xya57 |
58 | xya58 |
59 | xya59 |
60 | xya60 |
61 | xya61 |
62 | xya62 |
63 | xya63 |
64 | xya64 |
65 | xya65 |
66 | xya66 |
67 | xya67 |
68 | xya68 |
69 | xya69 |
70 | xya70 |
now i need to split this into no of pages in same excel per page 25 records automatically with apps script or any other way, without manual copy paste, without freezing .
rollno | name |
1 | xya1 |
2 | xya2 |
3 | xya3 |
4 | xya4 |
5 | xya5 |
6 | xya6 |
7 | xya7 |
8 | xya8 |
9 | xya9 |
10 | xya10 |
11 | xya11 |
12 | xya12 |
13 | xya13 |
14 | xya14 |
15 | xya15 |
16 | xya16 |
17 | xya17 |
18 | xya18 |
19 | xya19 |
20 | xya20 |
21 | xya21 |
22 | xya22 |
23 | xya23 |
24 | xya24 |
25 | xya25 |
rollno | name |
26 | xya26 |
27 | xya27 |
28 | xya28 |
29 | xya29 |
30 | xya30 |
31 | xya31 |
32 | xya32 |
33 | xya33 |
34 | xya34 |
35 | xya35 |
36 | xya36 |
37 | xya37 |
38 | xya38 |
39 | xya39 |
40 | xya40 |
41 | xya41 |
42 | xya42 |
43 | xya43 |
44 | xya44 |
45 | xya45 |
46 | xya46 |
47 | xya47 |
48 | xya48 |
49 | xya49 |
50 | xya50 |
something above , template will be 25 per page is fixed , with some additional columns.
Dec 22 2021 09:17 AM
@Devender78 assuming all rows are same height and you want 25 rows per page then the easiest is to change the row height so that it automatically paginates accordingly. You can do that using trial and error or calculate it based on paper size, margins, and row heights (btw better to work in pixels where possible since measurements are rounded).
Alternatively you could use a macro something like this:
Sub print25()
Dim r1, last As Long
With ActiveSheet
last = .UsedRange.Rows.Count
For r1 = 1 To last Step 25
.PageSetup.PrintArea = r1 & ":" & r1 + 24
.PrintOut (ignoreprintareas = False)
Next r1
End With
End Sub