poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Alexander Philippi <alex.philipp...@googlemail.com>
Subject Issues working with xlsx files
Date Mon, 09 Jan 2012 14:18:04 GMT
i created a workbook out of a given Excel 2007 file (the file was created
with Excel 2010; but this shouldnt matter).

The given file looks like this:
<a target='_blank'
src='http://img833.imageshack.us/img833/8971/bugim.th.png' border='0'/></a>

I have to add some informations to this excel file, but if I run this test
case, the "Spalte 1 - X" are removed ( I know the asserts are ugly but its
only to show my issue):
    public void testTemplateData2007() throws Exception {
        final InputStream fs = new FileInputStream("a xlsx file created
with excel 2010");
        final Workbook workbook = WorkbookFactory.create(fs);

is(equalTo("Spalte 1")));

is(equalTo("Spalte 2")));

is(equalTo("Spalte 3")));

is(equalTo("Spalte 4")));

I got no issues when I run the test with an Excel 2003 file. Does anybody
know why these columns were removed?

The written workbook looks like this:
<a target='_blank' href='
http://imageshack.us/photo/my-images/534/bug2jy.png/'><img src='
http://img534.imageshack.us/img534/6550/bug2jy.th.png' border='0'/></a>

I hope anyone could give me a hint why the written workbook doesnt look
like the original excel 2007 document.


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