I've been working with POI to create a basic workbook with data that is either textual or numeric, but with no special cell formatting required.
After many iterations I discovered that everything has to stay in-memory until a write is issued (HSSF and XSSF workbooks). At least based on my experience so far. My question is whether or not this is true? Can a workbook be updated with each new sheet that is added, thereby reducing the amount of data kept in memory? Does the workbook have to be closed and reopened after a write of a sheet so that another sheet can be added? Thanks. Les
