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.
Part 2 of a series on Context Variables
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema