Create Multiple Tabs with single excel file based on the column

[Chaitanyas]

Hi Team,

I have requirement that I need to populate multiple sheets in single excel file based on Column.

Let me illustrate with an example I have members belongs to separate states and I need create a excel with the State name as tab and its associated members in each tab as a output.

Could you please help me in providing the solution, that how do we achieve in Talend. Right now we are using SAP Crystal Report to populate such type of files.

Thanks In-advance.

Regards,

Chaitanya

[Anonymous]

i have a similar situation here. I am trying to pull the data from Database and load it in Excel file which has many sheets. I tried to do it by pulling DB tables right into the graph and connected with tMap and then to tFIleOutputExcel. It failed. After doing random changes in properties, the execution runs successfully but i lost the other sheets. Also, the sheet which got the data lost top-4 rows which has some grammatical information about the business. Please me to achieve the output (with diagram if possible). Thanks in advance. Let me know if you want to see the excel file. I will attach it in my next message

[Anonymous]

I have mine working like this

In tFlowToIterate I set

and in tFileOutputExcel_1 I set Sheet name to (String)globalMap.get("TabName")

I have been careful using capitalisation and procedure/function names.

Good luck

Mick

[Anonymous]

I am not creating a new excel sheets. The excel is already present, i just need to load the data into multiple sheets which is not happening. Please suggest

[Anonymous]

I've found that if I set a new worksheet name a new sheet is created, if I set name to an existing worksheet then that existing worksheet is selected. I did have to set "Append existing file" and "Append existing sheet" to true otherwise process would keep overwriting the same line.

Mick

[Anonymous]

Thanks Mick, i will try this.

[Anonymous]

How to keep existing information in the sheet as it is. My sheets are having some business information in the top 3 rows. Also, i don't want to lose other sheets in that excel. Data can be flown from Database to multiple sheets in excel all the time. Please suggest

[Anonymous]

Append will keep existing data and add new data underneath

[Anonymous]

When i use a new xlsx file then the graph is working and data is loading. If i use the excel file given by my client which has some formulas in different sheets then the normal DM-->Main-->tOutputFileExcel flow is getting hanged. Is there any other component which can handle output excel file which has formulas?

[Anonymous]

Can you try using tExcelSheetOutput with Open and Save components too?

[Anonymous]

tExcelSheetOutput is not available. Exchange is also not working. Yesterday i tried to download tFileExcel thru exchange but its not happening. After 40% of download the download screen disappeared.