GitHub user isagi-y0ichi added a comment to the discussion: Is There a Better Architecture Than Per-Formula Ephemeral Workbooks?
@centic9-dt thanks for your insight ! - we are doing something similar , for each formula since we know the depdencies have a CSVAcessor wrapper over a csv , which i use to prepopulate the workbook with the data then populate the formula itself and then run evaluate - when i checked for "cleaning" the cells after every formula evaluations haven't profiled the reason yet , i found heap spikes , thats the reason i resorted to just generate a new notebook , leaving it to the gc will look at if upgrading jdk to 21 works + profile it a better way had last done it over 6-7 months ago do you have any other ideas on how i can achieve this workflow more efficiently - dont want to implement the formula myself still want to leverage poi formula evaluation and report creation - have it in xlsx only since there operations heavily use google sheets and find it easier to just upload and we configure the data source with manual schema validation - maintain the same easy onboarding flow GitHub link: https://github.com/apache/poi/discussions/1061#discussioncomment-16876679 ---- This is an automatically sent email for [email protected]. To unsubscribe, please send an email to: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
