Skip to main content
Question

ExcelStyler not working when too much features


philippeb
Enthusiast
Forum|alt.badge.img+20

Hello there!

I was creating a report from a database and I had the idea to pimp my report with the ExcelStyler, to impress some colleagues. I realized very fast that when I put a conditional value on Background Color or Font, I can't write without an error into an Excel file when I have too much features. I can click yes, but I don't get any color/font, the ExcelStyler hasn't worked.

To explain the problem I created a workspace I attached . I put a conditional value on an attribute and I write it into Excel. I added a Sampler because as you'll see, when I write exactly 21809 features it's working, but higher than that, it's not, I get the error.

 

Am I doing something wrong?

I'm using FME 2018.1.

 

Thanks.

 

 

3 replies

Forum|alt.badge.img+2
  • February 5, 2019

@philippeb This looks like something we need to fix in the ExcelStyler. I think FME might be exceeding the number of unique cell styles allowed in a workbook - see this document for Excel file specifications.


philippeb
Enthusiast
Forum|alt.badge.img+20
  • Author
  • Enthusiast
  • May 6, 2019

I still have this issue in FME 2019.0.0.1


connecter
Contributor
Forum|alt.badge.img+10
  • Contributor
  • August 10, 2020

I have the same problem. What can I do? Will there be an update or is the "Unique cell formats/cell styles = 64,000" the limit?


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings