Hello, I'm working with a spreadsheet of around 26 cols and 28k rows. I have an excess memory warning, so I wondered how I could implement a cache system. I read the documentation, but I can't find a working example to copy. If anyone could help me ;)
It's not possible to write an excel file piece by piece without reloading the whole document in memory, is it ?
@olivierstern not it is not possible. You are right, there is no sample for cache, but the code in the docs is really all there is to it. The magic thing being Settings::setCache()
@Dfred yes, you can submit a PR for each and I will take a look at them, but it might take a few days because I don't have much spare time nowadays. You could start with your "favorite" branch first maybe, so we don't do everything at once. But that's up to you