topic [resolved] tFileOutputExcel in TOS V3.2.1 r31371 in Talend Studio

[resolved] tFileOutputExcel in TOS V3.2.1 r31371

Anonymous — Sat, 16 Nov 2024 13:42:10 GMT

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?

Re: [resolved] tFileOutputExcel in TOS V3.2.1 r31371

Anonymous — Tue, 03 Nov 2009 14:18:16 GMT

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.

Re: [resolved] tFileOutputExcel in TOS V3.2.1 r31371

Anonymous — Tue, 03 Nov 2009 14:54:06 GMT

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.

Re: [resolved] tFileOutputExcel in TOS V3.2.1 r31371

_AnonymousUser — Mon, 07 Dec 2009 18:01:20 GMT

Thanks

Re: [resolved] tFileOutputExcel in TOS V3.2.1 r31371

Anonymous — Tue, 04 Jan 2011 13:59:52 GMT

Hey can u please put the screenshot of ur solution please

Re: [resolved] tFileOutputExcel in TOS V3.2.1 r31371

Anonymous — Wed, 09 Nov 2011 09:40:12 GMT

hi..can you please keep the screen shots here..

Re: [resolved] tFileOutputExcel in TOS V3.2.1 r31371

Anonymous — Thu, 10 Nov 2011 04:34:09 GMT

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.