Loading Part of a Workbook to Memory

Hi there,

I am using “Aspose.Cells” Version=“22.9.0” in my .net 6.0 project.
In one of my APIs, I receiving an excel file (file system), worksheet name, row start, row end, column start and column end. Output is a model (json) of that part of excel.
The excel file might contain lots of data (i.e. many worksheets, lots of data in each of them).
Loading an entire workbook to memory might be a big overhead.
Is there a way to load only part of the workbook to memory. Even only a specific sheet? Or even better, part of a specific sheet?

Thanks in advanced,

Shlomi

@shlomi.z,

To load only one specific worksheet, the most simple way is to use LoadFilter, some examples:

To load specific range of one worksheet, you may use LightCells, documents for your reference:

For LightCellsDataHandler.StartSheet(Worksheet), you should only return true for the sheet that you want to process. For other apis such as LightCellsDataHandler.StartRow(int),ProcessCell(Cell)…, you should only return true when the cell is in your expected range.