Please, read my comment to the question.
As i mentioned, you need to loop through the collection of cells in range (in your example:
A1:A720
).
Please, follow below links:
How to: Parse and read a large spreadsheet document (Open XML SDK)[
^]
How to: Retrieve the values of cells in a spreadsheet document (Open XML SDK)[
^]
How to: Retrieve a list of the worksheets in a spreadsheet document (Open XML SDK)[
^]
Steps to do:
1) declare variables:
CurrentRow
and
DestinationRow
to store the global number of processing row, currently copied row and destination row
2) while
CurrentRow<rows.count></rows.count>
in active range go to step 3
3) do:
a) copy range to another sheet
b) increase
DestinationRow+=1
until
DestinationRow<26
4) if DestinationRow=25
a) change the destination sheet (if necessary, create new one),
b) reset
DestinationRow=1;
5) loop (go to 2)