topic Re: Want to create multiple sheet in tFileOutputExcel in Talend Studio

Want to create multiple sheet in tFileOutputExcel

Anonymous — Sat, 16 Nov 2024 12:35:39 GMT

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Mon, 31 Oct 2011 12:38:44 GMT

Hi
Sorry, I don't understand you very well, what does the result look like?
Best regards
Shong

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Mon, 31 Oct 2011 19:22:43 GMT

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 02:31:41 GMT

Hi
Ok, I understand what you need now, you need to iterate each row and set a dynamic sheet name. For example:
tFileInputExcel---row1--tFlowToIterate--iterate-->tFileOutputExcel
on tFileOutputExcel, set the 'Sheet name' field as: (String)gloalMap.get("row1.category")
Best regards
Shong

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 04:11:48 GMT

Thanx for your reply , but I cannot connect
tFlowToIterate--iterate-->tFileOutputExcel
Apart from it I have tried to set sheet name using context variable .
In that case the sheet name takes only the initial value of the variable but not the updated values .

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 04:21:59 GMT

Hi
Sorry, it was a wrong job design, the correct job looks like:
tFileInputExcel---row1--tFlowToIterate--iterate-->tFixedFlowInput--main--tFileOutputExcel
on tFixedFlowInput, generate each row of row1, define three columns on schema,
column:value
id:row1.id
category:row1.category
description:row1.description
Best regards
Shong

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 05:12:30 GMT

Hi,
I got some another issue.
It is creating the sheet with dynamic name , but at the end Excel file contain only one sheet and only one record

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 05:14:52 GMT

Hi
How do you set the sheet name in your case? Some screenshots of job will be more helpful for us understanding the problem.
Best regards
Shong

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 05:17:27 GMT

Hi,
I have used
((String)globalMap.get("row1.category"))
With Regards

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 05:20:53 GMT

Hi
Check the option 'Append existing file' and 'Append existing sheet', it should be ok now.
Best regards
Shong

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 05:34:15 GMT

Hi,
When I , Check the option 'Append existing file' and 'Append existing sheet' it is creating a file with 0 records (0KB)

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 07:18:00 GMT

Hi
You must do something wrong, I tested it and it works on v4.2.2. Please upload some screenshot of job, specially the setting of tFixedFlowInput component.
Best regards
Shong

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 08:18:18 GMT

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Tue, 01 Nov 2011 09:01:47 GMT

Any one has any solution

Re: Want to create multiple sheet in tFileOutputExcel

Anonymous — Fri, 04 Nov 2011 05:46:15 GMT

Hi
Not sure it was a bug on v4.2.0, I am working on v4.2.2 and it works fine.
Do you install Excel 2003 or 2007/2010 on your machine? Because I install excel 2007 on my machine, so I change the output file name to out.xlsx and it works.
Best regards
Shong

Re: Want to create multiple sheet in tFileOutputExcel

bogdan_popescu — Tue, 07 Oct 2014 10:51:53 GMT

I checked that option and followed what the article said. Now at the output I have an excel with the desired sheets, but the problem is that the sheets are "empthy". I am using Talend Enterprise 5.4.2. No data is passed through the components tFlowtoIterate and tFixedFlowInput. I am not expecting them to catch values, but they don't let previous outputs from components such as tFileInputDelimited or tFileInputExcel or any other output mappings to be used within further mappings.
Real Solution:
You have to define a key (local global variable) in the tFlowToIterate for each column that you want at output. After tFixedFlowInput you add a tMap where you map each output desired column with one of the local defined global variable in the tFlowToIterate.
In the attachment you can find some pictures with detailed information on how this works.
Pictures to solution LINK from my dropbox account to a zip file containing 6 small screenshots.