I need to output an excel file with strictly data format. So I created a template and set tFileOutputExcel as shown in the following picture. However,
it failed after 2909 rows with the error:
the maximum number of Cell Styles was exceeded. You can define up to 64000 style in a .xlsx workbook. Please help. Thank you.
Solved! Go to Solution.
i could not find "tFileExcel" component but i can see only "tfileoutputexcel".
I am also getting the same "the maximum number of Cell Styles was exceeded" error. Please guide me to resolve this.
@samisyed80,tFileExcel is extrenal componnet. you need to download from Talend Exchange.
use below link to download.
@samisyed80,please find below link to know how to install the custom component.
I am not able to install the "tFIleExcel" add-on feature. Is it only for enterprise edition purchaser? or Anyone can do it? Please help
@samisyed80,i am attaching thetFIleExcel zip file which i have downloaded from Talend Exchange.
Thanks Mano, i have this but installation is not happening. After installation process only, this component will appear in pallette
@samisyed80,after installation you need to restart Talend then it will appear in Pallette.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.