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