topic Re: Iterate data output to ExcelOutput Template in Talend Studio

Iterate data output to ExcelOutput Template

Anonymous — Sat, 16 Nov 2024 05:38:42 GMT

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?

Re: Iterate data output to ExcelOutput Template

fdenis — Wed, 12 Jun 2019 10:32:32 GMT

where did you find tFileExcelSheetOutput and so on?

Re: Iterate data output to ExcelOutput Template

Anonymous — Wed, 12 Jun 2019 14:40:58 GMT

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 🙂

Re: Iterate data output to ExcelOutput Template

Anonymous — Fri, 14 Jun 2019 17:31:51 GMT

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