What's that strange message?? It finds the titles, but it doesn't find the value in the sheet, what is that?
This happens when the value in the Excel sheet that you're trying to use as the datasource does not match with the data type you've specified.
In Jaspersoft Studio, all columns are defined as java.lang.String -> that should not matter which values are in excel sheet! Values in excel sheet my be "0" or "my text" - that should not matter.* (But it's NOT a number, it's a string in that problematic row)
* But not vice versa - int datatype in Jaspersoft Studio does not match with string in excel sheet, or genereally, the datasource. (whatever it is..)
Jaspersoft Studio seems to have serious problems with a simple hello world app - that's a lil bit strange in my opinion...
Maybe the problem is that the file was exported from LibreOffice Calc to .xlsx format...?
...can't believe that there is no solution for such a simple problem!
Problem still exists...
Now i will test it with the new version 6.9.0, i will not wonder if the problem still persists...;-)
Best regards, Jan
...yes, i was right. Problem still persists.
How to set the data type for a column? Can't see any options related it it. I can only see "Stretch Type" and "Position Type", which are layout things.
Where is the "datatype" setting for a field/column???
Same Problem here.
I just tried to see if Jasper might be useful to me, but on my first report i got the same error. I tried to change the data type of the field, but it doesnt work. It also seems that this problem exists with every field from the Excel, as it doesnt work if i just remove the field that had the error.
However, i just tried to build a report that based on a .CSV and it did work. Is it possible that Jasper has a Problem with Excel?
I'm getting the same error when attempting use a .csv file as a data source - "net.sf.jasperreports.engine.JRException: Unable to get value for CSV "weight" of class java.lang.Integer". The weight column contains nothing more than integers. The .csv file was exported from DBeaver. Does anyone have ideas on what causes the error?
I'm getting type number as format of excel cell and i modified type of colum as java.math.BigDecimal in jasper, after read fileds.
removing the empty row below of the titles does also not help. (?)
trying it without a group files does also not solve that issue!!
"trying it without a group files does also not solve that issue!!"
"trying it without a group field does also not solve that issue!!"
After removing the empty row below of titles, now i got same error for field "Strasse Nr.", before it was "Namen Firmenkunde". Your app seems to have problems with a simple "hello world" application, can't really believe that...
forum-related question: why i got confirmations mails on my OWN mailbox for my OWN conmments? does also not make sense in my opinnion...