Skip to main content
Question

Excel output formatting

  • August 9, 2016
  • 5 replies
  • 117 views
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

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

5 replies

itay
Supporter
Forum|alt.badge.img+18
  • itaySupporter
  • 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
  • robertoContributor
  • Author
  • Contributor
  • August 10, 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

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+59
  • mark2atsafeSafer
  • Safer
  • August 10, 2016
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.

 

FME Evangelist to the Rich and Famous!!
roberto
Contributor
Forum|alt.badge.img+6
  • robertoContributor
  • Author
  • Contributor
  • August 10, 2016
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

 

 

K

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

 

 

Community Stats

32,207
Posts
122,303
Replies
39,891
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.