Trying cell value based colors in Excel. ExcelStyler is simple and straight forward. Still I am missing some fundamental principle is missing. Attached workbench has very easy example to demonstrate how I mange to create non-formatted excel file
Best answer by ebygomm
You need to have the .formatting attributes exposed on the writer
+23- Contributor
If you use ExcelStyler you have to set Attribute Definition in the writer to Automatic.
You also should set an Else value for the backgroud colour.
If you use ExcelStyler you have to set Attribute Definition in the writer to Automatic.
You also should set an Else value for the backgroud colour.
Attibute definitio/type doesn't matter.
Else value is not needed. Actually it is better to leave empty because there is 'No Fill' option.
THX!
This solved the issue.
Actually this is forst topic in Formatting section in Excel writer documentation. Somehow I hadn’t internalized the matter.
Interesting is that this example is working without those .formatting attributes in writer side:
https://community.safe.com/s/question/0D54Q000080heIxSAI/style-excel-cell-values (fme2018-beta-excelstyler-example-2.fmwt).
+38- Influencer
THX!
This solved the issue.
Actually this is forst topic in Formatting section in Excel writer documentation. Somehow I hadn’t internalized the matter.
Interesting is that this example is working without those .formatting attributes in writer side:
https://community.safe.com/s/question/0D54Q000080heIxSAI/style-excel-cell-values (fme2018-beta-excelstyler-example-2.fmwt).
In earlier versions of the excel writer it didn't used to be necessary so I expect that is why that example works without
In earlier versions of the excel writer it didn't used to be necessary so I expect that is why that example works without
Correct.
I made 'Update Writer...' to that writer in the example workspace -> value based cell fill no longer works.
Reply
Helpful Members This Week
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.