Excel: Sheet name cannot be blank...

[2006 IR Open Dicussion]

By: Paul Stanton - wanto

Excel: Sheet name cannot be blank...

2006-06-21 19:19

I'm getting this exception when i export one of my reports to excel.

 

java.lang.IllegalArgumentException: Sheet name cannot be blank, greater than 31 chars, or contain any of /*?[]

at org.apache.poi.hssf.record.BoundSheetRecord.setSheetname(BoundSheetRecord.java:175)

at org.apache.poi.hssf.model.Workbook.setSheetName(Workbook.java:458)

at org.apache.poi.hssf.model.Workbook.setSheetName(Workbook.java:452)

at org.apache.poi.hssf.usermodel.HSSFWorkbook.createSheet(HSSFWorkbook.java:369)

at net.sf.jasperreports.engine.export.JRXlsExporter.createSheet(JRXlsExporter.java:126)

 

i'm guessing the sheet name is too long or contains invalid chars (pretty obvious) but where is the sheet name gleaned from and how do i configure it?

 

i'll post if i find a solution.

 

thanks.