[resolved] tfileinputexcel number format exception on excel2007

[Anonymous]

Hi All
I just upgraded TOS from version 4.2.3 to version 5.0.1 and after the upgrade I got an error in tfileinputexcel component. The component reads some numeric columns which contain a currency value: all these columns are set in the schema to be read as string, without any particular format.
In previous version everything was working properly, while in the last version at run time I get the following exception:

Exception in component tFileInputExcel_1
java.text.ParseException: Unparseable number: "? 7.500,00"
	at java.text.NumberFormat.parse(Unknown Source)

at the follow piece of code (extracts from the component):

case org.apache.poi.ss.usermodel.Cell.CELL_TYPE_NUMERIC:
 if (org.apache.poi.ss.usermodel.DateUtil.isCellDateFormatted(cell_tFileInputExcel_1)) {
	temp_row_tFileInputExcel_1 = cell_tFileInputExcel_1.getDateCellValue().toString();
 } else {
	temp_row_tFileInputExcel_1 = new BigDecimal(numberFormat_tFileInputExcel_1
                                                              .parse(dataFormat_tFileInputExcel_1
                                                              .formatCellValue(cell_tFileInputExcel_1))
                                                              .toString()).toPlainString;
 }

That is, the cell format (and not the real numeric value) causes the exception (in particular the ? symbol).
I have to check the Excel2007 option because this is the input format of the excel file, consequently some other advanced options are hidden and cannot be used.
Is there any way to get real value of a cell of an xlsx with tfileinputexcel? Or am I doing simply some mistake?
Thank you in advance for any advice.
Regards,
Fabio

[Anonymous]

Bug Fixed in release 5.0.2.

Ok. Thank you Pedro!
I reported the bug with the following issue: http://jira.talendforge.org/browse/TDI-19546.
BRs,
Fabio
Hi Fabio
Thank for your feedback.
I have talked with my coworkers about this issue. We need a little time to fix it.
Please report this bug at BugTracker.
Regards,
Pedro

[Anonymous]

Hi Fabio
Thank you for your feedback.
Regards,
Pedro

[Anonymous]

Hi fnds,
I wanna use talend to execute some query like db.emp.find({}).count(); and to return the result of count.
I tried to use tMongoRow and have given the query in execute command text box.
the job runs fine but i m unable to fetch the result in the connected component (tjava)
please help to retrieve the value.
or guide me in some other approach which can let me to perform the desired operation.
Thanks in advance,
karthi.