Or copy the original file first, with standard Java tools, then open, edit, and write the copy with POI.
On Mon, Nov 12, 2018, 13:34 Andreas Beeker <[email protected] wrote: > Hi Rob, > > although this is more memory consuming, how about opening your template > file via (File-)InputStream and using Workbook.write(new > FileOutputStream(..))? > > Andi > > On 12.11.18 22:25, Rob Sargent wrote: > > How does one read in an excel file then "save as" new file? > > > > I'm transforming xlsx input to a very different xlsx output. I open the > original, do my work in a new sheet, then save to a new file. > Unfortunately, if the original is writable by me, then my new sheet gets > saved in the original file (and in my new file too). If the original is > not writable by me I get a nasty little stack trace about cleaning up open > file(s). My new file has all the sheets (original and additional) as > desired. > > > > Thanks > > > > > > > > --------------------------------------------------------------------- > > 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] > >
