poi-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Paolo Mottadelli" <p.mottade...@sourcesense.com>
Subject Re: Today's work on the ooxml branch
Date Sun, 06 Apr 2008 13:21:35 GMT
Hi all,
I hope I did'n miss anything about this before;

>  We're now able to open an existing ooxml excel file in poi, tweak it, save
>  it, and have it open in excel! Admitedly, excel does feel the need to
>  repair the file, and it declares any new files we create to be
>  un-repairable, but it's a start... :)

for the first time today I could create a new .xlsx file through the
POI library and open it in Excel 2007 without making the application
declaring that the file is 'un-repairable'.
Checked in TestXSSFWorkbook.testSaveNew()

We were missing some styles.xml stuff, that is required in order to
make the file properly readable by Excel 2007;  in particular, we have
to provide:
_ at least one font
_ at least one fill
_ at least one border
_ at least one cellStyle Xf
_ at least one cell Xf

Attached the default styles.xml part created for a new POI .xlsx file


Paolo Mottadelli
Sourcesense - making sense of Open Source: http://www.sourcesense.com

View raw message