Hi, I have workbook with ~ 10 sheets. Some of them are quite big. I need to update just one. Is it possible to load given sheet on request ie. not to load whole workbook model? (provided I have no links/dependency between sheets). Is it possible in principle? I want to ask before I try to dig into code. Then on write I would save only sheets which are loaded. (main reason for this is memoru usage and also performance as creating complete model takes long).
I read some questions/discussions regarding this but it was lazy loading on row level. I think on sheet level it might be easier as sheets are separated in xlsx file. Thanks Marek