Lazy loading of sheets in SS user model?

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 i

Re: Lazy loading of sheets in SS user model?

Hi, There’s a parseSheet method in XSSFWorkbook (the relevant class if you’d like to read/update xlsx). You could possibly subclass XSSFWorkbook and then override parseSheet to not call onDocumentRead() for the sheets you are not interested in based on their names. I haven’t tried it myself, and

Re: Lazy loading of sheets in SS user model?

If developed, this would be a really valuable feature to the community. At my day job, we can't load xlsx files larger than 4MB because they bloat to 1GB in the Java heap, the maximum that Oracle JRE 7 can allocate. If you search through the mailing lists 6-12 months back, you'll find a similar qu

Can I set a hyperlink at picture.

Hi, I'm a user of java + POI(Excel). I want to set a Hyperlink at picture. But I can't find setHyperlink Method in Picture class. Please tell me how set a Hyperlink at picture. Regards