Does not SXSSF Workbook have a constructor based on an existing XSSF
(template) Workbook? This will allow to create a new SXSSF workbook,
add a sheet with content and then to write out the new file w/o
tampering with the existing template?
Best regardsAndreas
On Mon, 2018-11-12 at 20:54 -0700, Rob Sargent wrote:
> 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 <[email protected]>
> > 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 <[email protected]
> > wrote:
> > > Hi Rob,
> > > although this is more memory consuming, how about opening your
> > > templatefile via (File-)InputStream and using
> > > Workbook.write(newFileOutputStream(..))?
> > > 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 getssaved in the original file (and in my new file
> > > too). If the original isnot writable by me I get a nasty little
> > > stack trace about cleaning up openfile(s). My new file has all
> > > the sheets (original and additional) asdesired.
> > > > 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]
> > >
> > >
>
> -------------------------------------------------------------------
> --To unsubscribe, e-mail: [email protected]
> For additional commands, e-mail: [email protected]
>
