Skip to main content
Question

Excel output formatting


roberto
Contributor
Forum|alt.badge.img+6

Hello.

I need to apply some formatting to an excel file (borders, fontstyle and so on). So far I use a template but the solution is not perfect because I don't know in advance some details like, for example, how many rows will be written. Can I run a macro written into the template to accomplish these tasks? A shutdown python script?

Suggestions?

TIA

Roberto

5 replies

itay
Supporter
Forum|alt.badge.img+16
  • Supporter
  • August 9, 2016

You can try the formatting options available on the writer feature type.

http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_ReadersWriters/xlsx/user_attributes_w.htm


roberto
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • August 10, 2016
itay wrote:

You can try the formatting options available on the writer feature type.

http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_ReadersWriters/xlsx/user_attributes_w.htm

Thanks. Useful for some of my needs. Unfortunately I can see there the possibility also to specify border styles (v. 2015.1).

 

 

 


mark2atsafe
Safer
Forum|alt.badge.img+43
  • Safer
  • August 10, 2016
roberto wrote:
Thanks. Useful for some of my needs. Unfortunately I can see there the possibility also to specify border styles (v. 2015.1).

 

 

 

Hi @roberto - I don't see the ability to set a border either, but I do see that ability in the underlying library that we use. So I'm hopeful that if you file an enhancement request (safe.com/support) we might (no guarantees) be able to implement that fairly easily. Also let us know of any other options you need that aren't currently supported.

 

Regards

 

Mark

 

Product Evangelist

 

Safe Software Inc.

 


roberto
Contributor
Forum|alt.badge.img+6
  • Author
  • Contributor
  • August 10, 2016
mark2atsafe wrote:
Hi @roberto - I don't see the ability to set a border either, but I do see that ability in the underlying library that we use. So I'm hopeful that if you file an enhancement request (safe.com/support) we might (no guarantees) be able to implement that fairly easily. Also let us know of any other options you need that aren't currently supported.

 

Regards

 

Mark

 

Product Evangelist

 

Safe Software Inc.

 

Hi Mark.

 

Thanks for suggestion. I will do it.

 

Rregards

 

Roberto

 

 


itay wrote:

You can try the formatting options available on the writer feature type.

http://docs.safe.com/fme/2016.1/html/FME_Desktop_Documentation/FME_ReadersWriters/xlsx/user_attributes_w.htm

Thank you for your help. It was useful

 

 


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings