How to auto size column width in excel export of Jasperserver.

[amrutaa]

HI,

My report's data is not auto resized in excel export of jasper server. I don't want to wrap the data. Is there any property to auto increase the length of field in excel export?

 

[abc.hegde]

Hi,

You can control the exporter as shown below,

JRXlsxExporter exporter = new JRXlsxExporter();

exporter.setExporterInput(new SimpleExporterInput(print));

ByteArrayOutputStream os = new ByteArrayOutputStream();

exporter.setExporterOutput(new SimpleOutputStreamExporterOutput(

os));

SimpleXlsxReportConfiguration config = new SimpleXlsxReportConfiguration();

config.setOnePagePerSheet(false);

config.setDetectCellType(true);

config.setIgnoreCellBackground(false);

config.setWrapText(true);

config.setRemoveEmptySpaceBetweenRows(true);

config.setCollapseRowSpan(true);

exporter.setConfiguration(config);

exporter.exportReport();

 

[amrutaa]

Hi,

Where do we need to set this exporter property in Jaspersoft studio?

[amrutaa]

 

 

[abc.hegde]

Actually code posted above is for Exporting Excel using Jasper from Java. I am not sure about the Jasper studio. I use ireport designer and there i can set tthese options in - Tools - Options - Export Options- Excel

[jo.jasmine]

Click on the main report and go the advanced option and hit the propteries. This is the place where we can set properties while excel exporting in Jasper Server.