newtonarruda

Hi all, I corrected the problem reorganizing my code and passed not to use Byte[] anymore. I believe that this caused the problem . regards.

Thanks shertage, I try it but the message remains the same. Is there any other way to set the column width after the exporter.exportReport() ? Regards.

there is a checkbox in properties of the dynamic text at the textFild tab. Blank when null.

here is my code: Code: JExcelApiExporter exporter = new JExcelApiExporter(); ByteArrayOutputStream xlsReport = new ByteArrayOutputStream(); exporter.setParameter(JExcelApiExporterParameter.JASPER_PRINT,jasperPrint); exporter.setParameter(JExcelApiExporterParameter.OUTPUT_STREAM,xlsReport); exporter.setParameter(JExcelApiExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS,Boolean.TRUE); exporter.setParameter(JExcelApiExporterParameter.IS_WHITE_PAGE_BACKGROUND,Boolean.TRUE); exporter.setParameter(JExcelApiExporterParameter.IS_ONE_PAGE_PER_SHEET,Boolean.TRUE); exporter.setParameter(JExcelApiExporterParameter.IS_DETECT_CELL_TYPE,Boolean.TRUE); exporter.exportReport(); InputStream inputStream = new ByteArrayInputStream(xlsReport.toByteArray()); HSSFWorkbook wb = new HSSFWorkbook(inputStream); short[] columns = {0 ,1 ,2 ,3 ,4 ,5 ,6 ,7 ,8 ,9 ,10 ,11 ,12 ,13 ,14 ,15 ,16 ,17}; short[] widthArray = {580 ,2124,1055,2322,1939,2375,2005,2045,1860,1939,2124,3799,4459,3694,1201,1201,3654,580}; int sheets = wb.getNumberOfSheets(); // Auto Fit nos Sheets for (int i = 0; i < sheets; i++) { HSSFSheet sheet = wb.getSheetAt(i); for (int j = 0; j < columns.length; j++) { sheet.setColumnWidth(columns[j], widthArray[j]); } } Post edited by: newtonarruda, at: 2007/07/06 18:16 Post edited by: newtonarruda, at: 2007/07/06 18:39

Sorry about that, I forgoth to put one mor information: - when i export to XLS and before the reponse has been sent I convert the outputstream from the jasper to a Workbook (POI) and I set some columns width then I convert again to outputstream. The error messagem does not apairs when a don´t do the conversions. I´m going crazy because this messagem only apairs when my default program to open XLS is the MSExcel, this error does not apairs in OpenOffice. I hope this addiction will help to explain my problem. tnx

Hi, i have a message(erro) when i try to open a xls file, that was exported to Excel with JXL, in MSExcel. that is the message: anyone help me!?!? tnx. size=400]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/JXL_POI.JPG Post edited by: newtonarruda, at: 2007/07/04 21:46

Hi, I have a problem in my reports when I export to excel using JXL. the some texts appear partially occult. I need to expand all cell with occult texts. I put an image attach. anyone knows how to auto size the cells when exporting to excel? Tnx size=335]http://www.jasperforge.org/components/com_joomlaboard/uploaded/images/autosizecells.JPG Post edited by: newtonarruda, at: 2007/06/19 13:20 Post edited by: newtonarruda, at: 2007/06/19 19:12 Post edited by: newtonarruda, at: 2007/06/19 19:13

Hi, Teodor, is there a solution to the font problem? I have the same problem.

Hi all, I have a problem with BigDecimal values when i export my report to excel. when i see the xls, all values BigDecimals is transformed to String with a ' before the number like this: '1.250,00 I´m using #,##0.00 format. how can i fix this problem ? tks. Post edited by: newtonarruda, at: 2007/05/18 14:31

Tanks, but i need the full toolbar, not only the save as action.

ok, tks.

Does somebody knows anythink about that problem ?? any solutions or tips ? tks.

Ok, The first image (IE) is my report in the Broswer. It´s OK, but there is no toolbar then I can´t save the document. The second image (MS_EXCEL) is my report opened in the MsExcel and it have the toolbar that I need. how can I show tha toolbar ? [file name=images-7b65700c4e26ed622512afde0074450e.zip size=101081]http://www.jasperforge.org/components/com_joomlaboard/uploaded/files/images-7b65700c4e26ed622512afde0074450e.zip[/file] Post edited by: newtonarruda, at: 2007/05/15 15:09

Hi all, I have a problem. I can see my excel reports in the IE and FireFox but I can´t save them. The report isn´t showing the excel toolbar or menubar. How can I show them ? Is there a command to do this? Need Help! Plz.

Hi, I´m using excel-api to generate my reports but the excel toolbar or menubar does not appairs/show. how can I show the excel toolbar or excel menubar in a popup window ???