Is it possible to set a style for an excel cell if setting attributes dynamically?
Excel formatting/styling with Dynamic Schema Definition
Userlevel 1
+10
- Participant
- 3078 replies
-
23 January 2019
It seems like it should be possible but I'm not having much luck
+2
@egomm you can set the style for a specific cell using the ExcelStyler or using the attribute xlsx_row_formatting. See the Excel documentation on Formatting. If you could include a small example of what you're trying to accomplish then someone might be able to give you more ideas, or we could make improvements to FME if needed.
Userlevel 1
+10
- Participant
- 3078 replies
-
23 January 2019
My writer currently looks like this.
The schema source is "Schema From Schema Feature" which is being generated within the workspace as the attributes to write out are generated from the data within the workflow. Adding the attributes into the schema, e.g. colA.formatting doesn't appear to work. I can't set them as attributes in the writer as they need to be dynamic, i.e. if colC exists i want to format it but sometimes col C doesn't exist.
I have a workaround, which uses multiple template files and named ranges, but it's not very elegant.
+7
- Contributor
- 23 replies
-
3 November 2023
Seems like this behavior/issue is there still with FME 2022.x.
Reply
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.