svi

I found the solution, so here it is, for those who face the same issue. Here is how I was loading my Datasource : JRXlsDataSource ds = new JRXlsDataSource(TestXls.class.getResourceAsStream("fake_d3.xls")); But apparently, JXL assumes that your input file is encoded in UTF-8. So I changed my code for this : WorkbookSettings ws = new WorkbookSettings(); ws.setEncoding("CP1250"); Workbook wb = Workbook.getWorkbook(TestXls.class.getResourceAsStream("fake_d3.xls"), ws); JRXlsDataSource ds = new JRXlsDataSource(wb); This works fine. I hope it will help someone else !

Hi, I work on a report that uses a XLS file for data-source, from which I export the content to a PDF. Some cells of my XLS contains some 'é' or some 'ç', and those char are not correctly retrieved. For instance, "Message écrit reçu" becomes "Message crit mis". I tried to change de encoding of my text fields in my reports, but the problem seems to be the encoding of my source XLS. However, I tried to save the XLS with other encoding options, but the result was pretty much the same. I made a variable in order to get the charAt() value of these char, and 'é' gives me 65533. Any ideas ? Thanks :)

Hi, Apparently, according to this other post : http://jasperforge.org/plugins/espforum/view.php?group_id=83&forumid=101&topicid=81647 ... it is impossible to put some XLS data into a table. However, I managed to make something similar to a table with the fields. I will stick with this solution for the moment, but if someone have a solution for the use of tables, it would be nice. Thanks. Post Edited by svi at 05/03/2012 08:02

Hi, I'm working on a report based on a XLS source. I want to display the content of the XLS file in a table (same number of columns/rows, the complete content of the file). The generated PDF contains a invisible table, with the right amount of lines. When the table uses no style, the table is fully invisible. When I use the generic style, only the lines that separate each rows of the table are visible. It allows me to say that the right amount of rows are generated (one per row in the XLS file). But in both scenarios, the cells are empty. I made my template with iReport 4.5.1, and I'm using JasperReports 4.5.1 When I try to add some fields from the same XLS file in a blank report, the data is correctly retrieved, but as soon as I put them in a table, it doesn't work. Is this a bug ? Or am I doing something wrong ? Thanks ! Code: Edit: When I save my XLS as a CSV, and adapt my code, the generated PDF is correcly filled. But I need to take a XLS file as a source ... Post Edited by svi at 05/03/2012 08:47