topic Re: tFileOutputExcel-the maximum number of Cell Styles was exceeded in Talend Studio

tFileOutputExcel-the maximum number of Cell Styles was exceeded

JaneYu — Mon, 12 Mar 2018 20:05:07 GMT

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.

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

JaneYu — Thu, 15 Mar 2018 14:03:16 GMT

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

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

Anonymous — Mon, 07 May 2018 07:31:45 GMT

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.

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

manodwhb — Mon, 07 May 2018 07:46:54 GMT

@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=true&s=tFileExcel&f=&tf=&bf=&cat=&title=Search%2520Results

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

Anonymous — Mon, 07 May 2018 08:34:36 GMT

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

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

manodwhb — Mon, 07 May 2018 09:03:51 GMT

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

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

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

Anonymous — Mon, 07 May 2018 10:04:33 GMT

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

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

manodwhb — Mon, 07 May 2018 10:07:08 GMT

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

tFileExcel-10.2.zip

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

Anonymous — Mon, 07 May 2018 10:32:21 GMT

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

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

manodwhb — Mon, 07 May 2018 10:33:48 GMT

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

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

Anonymous — Mon, 07 May 2018 10:46:58 GMT

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

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

manodwhb — Mon, 07 May 2018 10:48:30 GMT

@samisyed80,you can install for open source.