tfileinputexcel empty row

[Anonymous]

Hello.
I want to do something which seems quite simple to me.
I have a tfileinputexcel component and a tadvancedXMLoutput.
In my excel file, some rows can sometimes be empty if the data isn't available.
I want that in this case, the XML bounds doesn't appear in the final XML file.
For example:
With a Excel like this

    ID        B    C     D
classic      111   222   333
c_empty      111         333

I want to get this :

<A id="classic">
   <b>111</b>
   <c>222</c>
   <d>333</d>
</A>
<A id="c_empty">
  <b>111</b>
  <d>333</d>
</A>

The schema of the xlsx has the 'nullable' check, but i get a "IllegalStateException: Bad cell type" when it tries to convert the empty cell into 'string/numeric/...'
What is missing ?
Thanks.

[Anonymous]

ok thanks shong seems a nice tool.

[Anonymous]

We are facing an Issue while extracting data from Excel 2007 File.
connecting to socket on port 3420
connected
Exception in component tFileInputExcel_2
java.lang.IllegalStateException: Bad cell type (3)
Did you come across this error.
Talend Version: 3.2.3 Integration Suite
Source: Excel 2007 (.xlsx)
Target: Mysql
I have 9 columns with blank cells here and there. At Talend level: I designated all columns as Nullable and Strings.

[Anonymous]

Hello vamsi27
Can you try to check/uncheck the 'Don't validate the cells' box on advanced settings panel and test again?.
Best regards
Shong

[Anonymous]

Hello Shong,
We are using .xlsx file as source.
I see the option you suggested for xls file but not xlsx file.

[Anonymous]

Solution for the above Issue: (Anders Geving From Linked in pointed me to this link)
https://community.talend.com/t5/Design-and-Development/How-can-add-extra-jdbc-settings-to-a-MySQL-co...
Download the latest patch. This fixed my issue.
I added the latest Java Jet file to the components folder in talend and it worked for me.