IllegalArgumentException Sheet name cannot...

[2006 IR Open Dicussion]

By: amodg - amodg

IllegalArgumentException Sheet name cannot...

2006-02-14 05:47

Hi,

 

I am trying to export my report in MSExcelSheet using net.sf.jasperreports.engine.export.JRXlsExporter class.While doing that, I am getting an Exception as...

 

java.lang.IllegalArgumentException: Sheet name cannot be blank, greater than 31

chars, or contain any of /*?[]

at org.apache.poi.hssf.record.BoundSheetRecord.setSheetname(BoundSheetRe

cord.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.j

ava:369)

at net.sf.jasperreports.engine.export.JRXlsExporter.createSheet(JRXlsExp

orter.java:126)

at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport

ToStream(JRXlsAbstractExporter.java:279)

at net.sf.jasperreports.engine.export.JRXlsAbstractExporter.exportReport

(JRXlsAbstractExporter.java:154)

 

Could you plzzzzz.... help me out...?

I am eagerly waitng for any reply....

 

Thanks in advance

-Amod