Jump to content
Changes to the Jaspersoft community edition download ×

Excel: Sheet name cannot be blank...


Recommended Posts

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.

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...