Skip to main content
  • EN

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.

 

 

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

I still have this issue in FME 2019.0.0.1

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?

Reply


Community Stats

30,189
Posts
114,582
Replies
37,853
Members
Terms & ConditionsCookie settings
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.