poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Rob Sargent <robjsarg...@gmail.com>
Subject Re: emulate saveAs
Date Tue, 13 Nov 2018 03:54:02 GMT
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 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-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
View raw message