Error in tFileRowCount.

Error in tFileRowCount.

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.

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.ThanksVaibhav

Re: Error in tFileRowCount.

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+1After completing the job, display context.cnt... it will show you the row count.ThanksVaibhav