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.
@samisyed80,you can install for open source.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Pick up some tips and tricks with Context Variables
Learn how media organizations have achieved success with Data Integration
Introduction to Talend Open Studio for Data Integration.