Skip to main content

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.

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


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