Hi, I don't see a quick way to do this as we do not expose the name of the temporary file and the resulting file could have a slightly different size as we likely add more metadata and also because we hold a configurable number of rows in memory which will be written out from time to time...
So I would probably not invest a lot here, but rather put in a reasonable limit based on rows/cells or number of sheets (depends on how the data is actually structured here) which will not exceed the limit in all cases. Having 10 or 15 mb file size shouldn't make a big difference if you are splitting them anyway, or? Dominik. On Thu, Jul 9, 2015 at 9:42 AM, vijayinani <[email protected]> wrote: > Hi, > > I am using the POI SXSSF API to generate large excel files in Java. > The files generated will be used as an input to other system. The problem is > that the other system do not accept the files more than 15 MB. > > I need to split excel files such that if the temporary zipped file created > is exceeding the limit, then the file should be split. How do I handle this? > Is there any way (method) to get the file size of the temporary file created > and written to the disk so that once the threshold is reached, I can start > creating a new file? > > Please suggest. > > Thanks and Regards, > Vijay Inani > > > > > -- > View this message in context: > http://apache-poi.1045710.n5.nabble.com/Split-the-excel-file-generated-using-SXSSF-tp5719327.html > Sent from the POI - User mailing list archive at Nabble.com. > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
