How to search for a record without loading the complete workbook in memory

Aspose.Cells Product Family
1

Hi,

Is there any way to find a record with a particular cell value without loading the complete workbook/sheet in memory, as it throws outofmemory error when i try loading a huge sized workbook into memory. It would be really grateful if you could respond me on this ASAP, as this issue completely stops me from continuing my work. Thanks a ton for helping me on this issue.

Thanks.

2

Hi,


Well, I am afraid, there is no such feature (in Aspose.Cells) to get/find a cell value without loading the workbook in the memory, you need to first load the workbook, then you can search your data in the cells of the worksheet.

If your Workbook’s size is huge, please make sure that you have enough memory allocated for the big process, you would need approx.10 times or more RAM of your original file size to load the file by Aspose.Cells APIs. Please make sure you have that much RAM available for it.

By the way, you may load/open your specific worksheet(s) in the big Workbook, then find your data, see the topic for your reference (if it helps you):
http://www.aspose.com/docs/display/cellsnet/Load+only+Specific+Sheets+in+a+Workbook


Thank you.