Can we split excel file using Aspose DLL?

Aspose.Cells Product Family
1

We are using Aspose 8.2.2 version.

We have one excel workbook with one sheet. It is of 2 GB, can we split that excel file so that number of rows are equally distributed to split sheet. Please let me know sample C# code for the same.

2

@Mufaddal53,

There is no direct way for the task. You may try to use Range.Copy, Cells.CopyRows or Cells.CopyColumns method to copy data from your main worksheet to other sheets (you have to insert multiple sheets into the workbook first). Then, you may remove the source (main) worksheet after the data/contents are inserted into different worksheets.

See the documents for your reference.
https://docs.aspose.com/cells/net/copy-ranges-of-excel/
https://docs.aspose.com/cells/net/copying-rows-and-columns/

Hope, this helps a bit.