topic Re: Creating a dynamic schema for Excel with a variable number of columns in Talend Studio

Creating a dynamic schema for Excel with a variable number of columns

Anonymous — Tue, 15 Nov 2016 08:22:50 GMT

Hello,
i am currently trying to apply a dynamic schema to Excel as its possible with tFileInputDelimited. Is there any way to do this?
Best regards
Yannick Rüttgers

Re: Creating a dynamic schema for Excel with a variable number of columns

Anonymous — Wed, 16 Nov 2016 08:52:15 GMT

Hello,
neither tFileInputExcel nor tFileOutputExcel support dynamic Types, imho you would need to rewrite the component to do so
(i work on TIS 5.4.1)

Regards
dj

Re: Creating a dynamic schema for Excel with a variable number of columns

Anonymous — Thu, 17 Nov 2016 10:11:59 GMT

Hi,
Please take a look at custom component tFileExcelSheetInput which is written by community user and shared on talend exchange portal to see if it works for your case.
https://exchange.talend.com/#marketplaceproductoverview:gallery=marketplace%252F1&pi=marketplace%252F1%252Fproducts%252F539%252Fitems%252F1534

Best regards
Sabrina