amrutaa Posted May 25, 2015 Share Posted May 25, 2015 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? Link to comment Share on other sites More sharing options...
abc.hegde Posted May 26, 2015 Share Posted May 26, 2015 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(); Link to comment Share on other sites More sharing options...
amrutaa Posted May 26, 2015 Author Share Posted May 26, 2015 Hi,Where do we need to set this exporter property in Jaspersoft studio? Link to comment Share on other sites More sharing options...
amrutaa Posted May 26, 2015 Author Share Posted May 26, 2015 Link to comment Share on other sites More sharing options...
abc.hegde Posted May 26, 2015 Share Posted May 26, 2015 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 Link to comment Share on other sites More sharing options...
jo.jasmine Posted May 29, 2015 Share Posted May 29, 2015 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. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now