Re: How do I write a file out in XSSFWorkbook

Did you try :

SS_save(book: xl_file);

Now you can't create an HSSF spreadsheet and write it as XSSF, and POI has
no conversion functionality, so you need to create the spreadsheet as

book = new_XSSFWorkbook();

or read an xlsx workbook as:

book = ss_open('mybook.xlsx');

But once you have an XSSFWorkbook, then you can write one. BTW, SS_open()
creates either an HSSF workbook, or an XSSF workbook based on the file
type, and SS_save() saves an HSSF workbook or an XSSF workbook based on the
workbook type that it is operating on.

On Wed, Nov 15, 2017 at 12:16 PM, Marvin Radding <
marvin.radding@xxxxxxxxxxxxxxxxxxxxx> wrote:

I am trying to use the XSSF feature in the Apache POI but cannot find how
to write the file to disk. I have looked at the javadocs and the
XSSFWorkbook class has no write method. Does anyone know how to save the
file?

I am a newbie when it comes to Java but I have been using Scott Klement's
HSSFR4 for the xls type files. But I am frustrated with trying to guess how
to write the file for XSSF.

Thanks,

Marvin
No trees were killed in the sending of this message, but a large number of
electrons were terribly inconvenienced, traumatized, triggered, and crying
for their safe spaces.

Notice: This e-mail transmission may contain information that is
proprietary, privileged and/or confidential and is intended exclusively for
the person(s) to whom it is addressed. This message may also contain
Protected Health Information (PHI) and must be treated confidentially and
handled in accordance with HIPAA and other federal and state privacy laws.
Any use, copying, retention or disclosure by any person other than the
intended recipient or the intended recipient's designees is strictly
prohibited. If you are not the intended recipient or their designee, please
notify the sender immediately and delete this e-mail (and any accompanying
attachments).
--
This is the Java Programming on and around the IBM i (JAVA400-L) mailing
list
To post a message email: JAVA400-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/java400-l
or email: JAVA400-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/java400-l.