tFileOutputExcel-the maximum number of Cell Styles was exceeded

Six Stars

tFileOutputExcel-the maximum number of Cell Styles was exceeded

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.

tFileOutputjExcel.JPG


Accepted Solutions
Six Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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


All Replies
Six Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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

Eight Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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.

Thirteen Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

@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...

Manohar B
Eight Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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

Thirteen Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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

 

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

Manohar B
Eight Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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

 

Thirteen Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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

Manohar B
Eight Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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

Highlighted
Thirteen Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

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

Manohar B
Eight Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

installation is not happening. Is this for paid customers only?

Thirteen Stars

Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded

@samisyed80,you can install for open source.

Manohar B