topic Re: Error in tFileRowCount. in Talend Studio

Error in tFileRowCount.

_AnonymousUser — Fri, 28 Mar 2014 07:36:39 GMT

Hi,
i am using tFileList_1------(iterate)------>tFileRowCount.
in tFileList1,i want to read .xlsx file and by iterating it i want to count no of records present in perticulat .xlsx file which i want to do with tFileRowCount and i am providing filename in tFileRowCount as, ((String)globalMap.get("tFileList_1_CURRENT_FILEPATH")), but it showing error as "java.lang.RuntimeException: not support excel 2007".
so how to remove that error.
so will u please suggest me how to remove that error.
Thanks

Re: Error in tFileRowCount.

_AnonymousUser — Fri, 28 Mar 2014 11:25:29 GMT

Hi,
Wainting for your replay.
Thanks.

Re: Error in tFileRowCount.

Anonymous — Thu, 03 Apr 2014 07:18:52 GMT

Hi vinu,
Your file is of .xlsx, excel input file component has a check box to read .xlsx file... enable that check box...
rowcount is not supported in .xlsx file... may be you can convert that file to xls and then read again same file and display its count using tjava.
Thanks
Vaibhav

Re: Error in tFileRowCount.

Anonymous — Thu, 03 Apr 2014 07:28:27 GMT

Hi Vinu,
If you still want to get the count, insert tjavarow component, define a cnt as a context variable. Write following code in tJavarow component.
context.cnt=context.cnt+1
After completing the job, display context.cnt... it will show you the row count.
Thanks
Vaibhav