poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Andreas Reichel <andr...@manticore-projects.com>
Subject Re: emulate saveAs
Date Tue, 13 Nov 2018 04:00:54 GMT
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 <greg.woolsey@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 <kiwiwings@apache.org
> > 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: user-unsubscribe@poi.apache.org
> > > > For additional commands, e-mail: user-help@poi.apache.org
> > > > 
> > > > 
> > > 
> > > ---------------------------------------------------------------
> > > ------To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> > > For additional commands, e-mail: user-help@poi.apache.org
> > > 
> > > 
> 
> -------------------------------------------------------------------
> --To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
> 

Mime
  • Unnamed multipart/alternative (inline, None, 0 bytes)
View raw message