topic Re: create an excel document with multiple sheets in Talend Studio

create an excel document with multiple sheets

Anonymous — Sat, 16 Nov 2024 13:23:46 GMT

Hello, i am new to talend and need a help do the following:
I have an input that list all the data from a table, a tmap that generates 2 output. I want to map these 2 outputs in one single excel document but in two different sheets.
could anyone please give some explanations on how to achieve this...
thx

Re: create an excel document with multiple sheets

Anonymous — Sun, 13 Jun 2010 03:38:06 GMT

Hello
You can caches the two output to memory first, and then output them into the same excel file one by one, for example:
tFileInputDelimited--tMap---tHashOutput_1
---tHashOutput_2
|
onsubjobok
|
tHashInput_1(read records from tHashOutput_1)---tFileOutputExcel(file1, sheet1)
|
onsubjobok
|
tHashInput_2(read records from tHashOutput_2)---tFileOutputExcel(the same file, sheet2)
Best regards
Shong

Re: create an excel document with multiple sheets

Anonymous — Mon, 14 Jun 2010 13:48:22 GMT

Thank you Shong, i will try it and let you know.
Rgds,
Anoushka

Re: create an excel document with multiple sheets

Anonymous — Tue, 26 Oct 2010 19:06:13 GMT

Since anoushka did not get back to you...
Hong - very helpful.
Here are my observations:

tFileInputDelimited--tMap---tFileOutputExcel_1(file1, sheet1)        >>> Establish file1 with data schema (tMap out will do that).
                                                                         Make sure "Append existing file" is unchecked.
                         ---tHashOutput_2                            >>> store tMap out
  .
  .
  .
                         ---tHashOutput_X                            >>> store tMap out
     |
onsubjobok
     |
tHashInput_2(read tHashOutput_2)---tFileOutputExcel_2(file1, sheet2) >>> Create by copying tFileOutputExcel_1,
                                                                         change sheet name and check "Append existing file".
                                                                         When connecting tHashInput allow target schema
                                                                         to update tHashInput.
   .
   .
   .
     |
onsubjobok
     |
tHashInput_X(read tHashOutput_X)---tFileOutputExcel_X(file1, sheetX) >>> Same as at tFileOutputExcel_2

Honestly, this should be part of the documentation.
How can I help with that?
HTH,
Gábor

Re: create an excel document with multiple sheets

Anonymous — Fri, 19 Nov 2010 13:17:29 GMT

I am trying to follow this example , but I cannot find HashInput or HashOutput in my version of Open Studio. Can someone help me understand what the problem I am having is? Thanks in advance
My version is:
"Talend Open Studio"
Version: 4.1.0
Build id: r49467-20101005-0735

Re: create an excel document with multiple sheets

Anonymous — Wed, 09 Mar 2011 23:28:18 GMT

Since I had the same question, I thought I would post the answer I found:
Use menu File>Edit project properties then in the Project Settings window that opens, expand Designer>Palette Settings, shuttle the "Technical" node from the "Hide" side to the "Show" side and click Ok.
From there it should be self-explanatory, given the example provided above.
Version: 4.1.2
Build id: r53616-20110106-0635

Re: create an excel document with multiple sheets

Anonymous — Thu, 10 Mar 2011 03:40:14 GMT

Hi SunDog
Yes, you are right, thanks for giving the answer replace me.
Best regards
Shong

Re: create an excel document with multiple sheets

jdope — Fri, 27 May 2016 14:53:33 GMT

Gábor - awesome. Thank you!