I believe I’ll have to resort to that, thanks. Is this not a missing feature?
> On Nov 12, 2018, at 8:03 PM, Greg Woolsey <greg.wool...@gmail.com> wrote: > > 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 <kiwiwi...@apache.org 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: user-unsubscr...@poi.apache.org >>> For additional commands, e-mail: user-h...@poi.apache.org >>> >>> >> >> >> --------------------------------------------------------------------- >> To unsubscribe, e-mail: user-unsubscr...@poi.apache.org >> For additional commands, e-mail: user-h...@poi.apache.org >> >> --------------------------------------------------------------------- To unsubscribe, e-mail: user-unsubscr...@poi.apache.org For additional commands, e-mail: user-h...@poi.apache.org
