poi-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dominik Stadler <dominik.stad...@gmx.at>
Subject Re: Odd behavior with SXSSF sheets
Date Sat, 31 Mar 2018 05:58:13 GMT

Sounds like a messed up classpath in Eclipse or some other problem with the
IDE, I would start in the project settings where the libraries are
configured to check if poi-ooxml-* is still listed correctly there as well.


On Fri, Mar 30, 2018 at 9:44 PM, Joltes, Richard <rej963@g.harvard.edu>

> Hello all,
> New subscriber, and I can't see anything in the archives so I hope this
> hasn't been discussed before. I have an application that uses the SXSSF
> style sheets, and which was working just fine until I reopened the project
> today. Now it's showing lots of type-mismatch errors, and I've no idea why.
> Rough outline:
> 1) instantiate an SXSSF workbook (protected SXSSFWorkbook wb;)
> 2) create a matching sheet (protected SXSSFSheet sheet1;)
> But then, when I try to instantiate the sheet the fun starts
> sheet1 = wb.createSheet("sheet1");
> Here, Eclipse is telling me to add a cast to SXSSFSheet, which makes no
> sense since that's how the sheet was created in the first place.
> From then on it's all the same --
> SXSSFRow r = sheet1.createRow(0); same type/cast error
> Creating an SXSSF cell obviously does the same thing.
> Even odder, all the previously working ColorScaleFormatting and other color
> oriented code is showing up as undefined. Again, all this code was working
> last time I had the project open. I've no explanation for this behavior.
> I was using 3.16, but just migrated to 3.17 and got the same behavior.
> Any ideas?
> Thx,
> Dick Joltes
> Harvard University

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