Iterate data output to ExcelOutput Template

[Anonymous]

Hello.  I am using Talend Open Studio for big data 7.0.  I needed to create multiple Excel output(s) using a list of values into an Excel spreadsheet.  I used tFileInputExcel-->tFlowToIterate-->tDBInput-->tFileOutputExcel which works great. 

However, I have another request to do the same thing, but placing the output values in specific rows/columns in Excel.  Is it possible to use tFileExcelWorkbookOpen, tFileExcelSheetOutput and tFileExcelWorkbookSave for this?  I've tried different variations and keep getting errors.  Is there an order that it needs to be done or can it be done at all?  I've used these 3 components before when outputting just 1 file, but I need to create multiple files via tFlowToIterate.  Should this be approached differently such as creating the different files first then using the 3 components listed above?

[fdenis]

where did you find tFileExcelSheetOutput and so on?

[Anonymous · Accepted solution]

Hi,

   I believe you are talking about custom components available in Talend exchange. The queries related to Talend exchange components can be answered by the corresponding Talend community members who have developed them. 

   Coming to the standard component, did you try the option marked below in tFileOutputExcel to start writing data from a specific position?

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved 🙂

[Anonymous]

Thank you! I didn't realize the standard component could be used using the above noted field(s)