tFileOutputExcel-the maximum number of Cell Styles was exceeded

[JaneYu]

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.

[JaneYu · Accepted solution]

I downloaded Jan Lolling's most recent tFileExcel components (version 10.0). This great product solves my problem.

[Anonymous]

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.

[manodwhb]

@samisyed80,tFileExcel is extrenal componnet. you need to download from Talend Exchange.

use below link to download.

https://exchange.talend.com/#marketplacesearch:gallery=marketplace%252F1&ob=releaseDate&o=0&c=20&d=t...

[Anonymous]

Even after downloaing "tFIleExcel" from the given link, i am not able to see it. Please help. 

[manodwhb]

@samisyed80,please find below link to know how to install the custom component.

https://help.talend.com/reader/Jkvp187bw8jcmAsfn~skJQ/Cp2O1jasCRNKAlFAmCHSdw

[Anonymous]

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

[manodwhb]

@samisyed80,i am attaching thetFIleExcel zip file which i have downloaded from Talend Exchange.

tFileExcel-10.2.zip

[Anonymous]

Thanks Mano, i have this but installation is not happening. After installation process only, this component will appear in pallette

[manodwhb]

@samisyed80,after installation you need to restart Talend then it will appear in Pallette.