One of the goals of our application is to be able to open existing Excel files, modify some small amount of content and then resave the file. Currently in order to do this, it requires us to load the entire document into memory which can be a big cost.
I’ve seen the light cells implementation but that doesn’t seem to fully cover what we need unless I’m misunderstanding the use case there. I was hoping to be able to use load filters to say load the document with only chart information, remove one chart + resave the file. The problem is this causes the other data of the excel that was not loaded to be lost on save. Is there anyway to to accomplish something like this?
Some examples of use cases where we would want to limit the amount of data we load:
- Open the Excel and remove one chart of the document
- Open the Excel and remove the content from a single cell
- Open the Excel and remove a comment from a cell
We would ideally like to do the above operations without needing to load the full document into memory while opening / saving. I didn’t seem like this was a feature Aspose supported but wanted to check and see if I missed anything.