Hi, everyone..
Using TOS v3.2.1, I've encountered an error while using tFileOutputExcel component. Here's the scenario:
1. Read data from databases.
2. Transform it using tMap. The tMap output is more than 1.
3. Load the data into 1 Excel file. The Excel file will have many worksheets depending on the tMap outputs.
When I run the job, TOS give me an error:
Exception in component tFileOutputExcel_2
jxl.read.biff.BiffException: The input file was not found
at jxl.read.biff.File.<init>(File.java:124)
at jxl.Workbook.getWorkbook(Workbook.java:221)
at jxl.Workbook.getWorkbook(Workbook.java:198)
at test_ground.write2excelfile_0_1.write2ExcelFile.tRowGenerator_1Process(write2ExcelFile.java:753)
at test_ground.write2excelfile_0_1.write2ExcelFile.runJobInTOS(write2ExcelFile.java:1417)
at test_ground.write2excelfile_0_1.write2ExcelFile.main(write2ExcelFile.java:1310)
After that, I simulate the same scenario using tRowGenerator as an input and the job still prompt the same error. Attached the related screencaps with this post.
I'm wondering has anybody here ever got the same error? Should I report this issue to the Bug Tracker?
Thanks.. Solved this issue using tSortRow as an input for the tFileOutputExcel. (tMap >> tSortRow >> tFileOutputExcel) Now it can load data into the same Excel with different worksheets.
U can't do that, because iternally it requires to open the same file twice. A workaround is to write a buffer and to write to each sheet on subjob at a time.
Thanks.. Solved this issue using tSortRow as an input for the tFileOutputExcel. (tMap >> tSortRow >> tFileOutputExcel) Now it can load data into the same Excel with different worksheets.
hi.. here is the solution.. tRowGenerator---->tMap---->tFileOutputExcel_1 | | | tSortRow------>tFileOutputExcel_2 tRowGenerator ------------columns are id,city columns. And " No.of Rows for Row Generator : 100 " conditions in tMap componet-----------id <=50 for tFileOutputExcel_1 id>50 for tFileOutputExcel_2 Give the same file name for both excel components and sheet names must be different like "SHEET1" for tFileOutputExcel_1, "SHEET2" for tFileOutputExcel_2. And Set "Append existing file" setting in tFileOutputExcel_2 component. tSortRow------------ add a column id and select asc or desc. Thats it.
