Report and Subreport using xlsx file

[alain.ranvier]

 

I have an issue when i try to pass excel file datasouce on subreport with jaspersoft studio. 

net.sf.jasperreports.engine.JRException: net.sf.jasperreports.engine.JRRuntimeException: net.sf.jasperreports.engine.JRException: Unable to get value for Excel field "Column_0" of class java.lang.String.
 

I'm using this expression  on datasource expression :new net.sf.jasperreports.engine.data.JRXlsxDataSource(net.sf.jasperreports.engine.util.JRLoader.getLocationInputStream("/../Data1.xlsx")

I have try also this expression with xls : new net.sf.jasperreports.engine.data.JRXlsDataSource(new File("Data1.xls")) 

I have always an issue. 

I test vith Column0 and Column_0  and i get the same things. 

Is somebody have an answer ? 

Thank's in advance

Al