Solved

Excel Column Formatting


Userlevel 5
Badge +13

When using Manual Attribute Definition in the XLSX Writer or FeatureWriter, is there a way to copy the Column Formatting between attributes? I have noticed that if I manually add a new attribute beneath one already formatted it copies the Formatting of the one above. But I was hoping there would be an easy way to set one, and then have it applied to all attributes.

icon

Best answer by rahulsharma 9 May 2024, 06:36

View original

2 replies

Badge +10

Hi @liamfez 
In FeatureType properties dialog, Under User Attribute → Switch to “ Manual”
Create a customize row, specify Font, Color, Border etc
Right click → Copy Row 
Add a new row if required , Right-Click and Paste

This operation should copy the formatting and you can copy and paste as many times as you want.  

You can also use the ExcelStyler transformer to format rows or cells

Userlevel 5
Badge +30

Hi @liamfez 
In FeatureType properties dialog, Under User Attribute → Switch to “ Manual”
Create a customize row, specify Font, Color, Border etc
Right click → Copy Row 
Add a new row if required , Right-Click and Paste

This operation should copy the formatting and you can copy and paste as many times as you want.  

You can also use the ExcelStyler transformer to format rows or cells

Very nice

Reply