Empty Table from XLS

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 !

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 ...

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.