Hi,
this problem has frustrated me for a few days so I am asking for your help.
I have a Excel spreadsheet that I am importing using a tFileInputExcel. I am importing the cells of the spreadsheet as string and floats. The columns import fine until column 61, which is imported as a string (I am actually not interested in this column - I ignore the contents). On the reject output of the tFileInputExcel component I get the error:
For input string: ""$"0" - Line: 1 column: BBTotalCredit_ (No. 61)
I get this error for all subsequent rows for column 61.
I should note that I get this spreadsheet each month and every one has the same problem and I don't want to ask them to change the format.
Below is a screenshot of the troublesome Excel column and the Excel metadata for column 61. Any ideas? Is there a way I could ignore this column?
Thanks,
David
I cant' reproduce this. Can you post a screenshot of your tFileINputExcel component configuration + advanced options too + a sample of the Excel file ?
Thanks and a good suggestion.
I have tried float and int types in desperation. All of these come up with errors.
I don't need this column and ideally I would not import this troublesome column (and there may be a way to do this but i don't know how).
Thanks for the idea and i will try any ideas.
David
Hi David
What version of Talend are you using?
is this a ".xls" or ".xlsx" spreadsheet?
Have you changed any advanced settings in this tFileInputExcel component?
Regards,
Brandon
Wow, I am overwhelmed by everyone's enthusiasm to help a friend in need!
It is an .xls version Excel sheet and I am using Talend 5.1.1
Below are screenshots of the tFIleInputExcel component. I can send someone a sample spreadsheet, but i don't know how to send via the forum.
Thanks again.
Hi David
I can't seem to reproduce the error,
could you upload that file with fake data onto a file hosting site and give us the download url
Regards,
Brandon
According to your image column 61 is PBBCredit$. The error relates to BBTotalCredit_ . can you show the data that is in BBTotalCredit_ and which column is it?
Hi Janhess,
Sorry I gave you a screenshot of column 50 of the sheet that I incorrectly labeled 61 (there are 121 columns in total).
Below is a screenshot of the correct (troublesome) column 61.
Hi david
I can reproduce the problem if I read that column as type float:
||For input string: "$0" - Line: 0 column: test (No. 61)
||For input string: "$0" - Line: 1 column: test (No. 61)
||For input string: "$0" - Line: 2 column: test (No. 61)
make sure this column is set as String in the metadata
Regards,
Brandon
