Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Fontstyle Header Run Log

    Posted 12-04-2019 10:55

    Hi All,

    today I've got a question from a customer if it is possible to change the font style of the header from the Run Log Column.
    We can change font, fontsize, etc. in the belonging Excel file but when running the script is completed the styles of the cell are changed back again to default settings.

    Is there a way to keep the style as is set in the Excel-file?

    Thanks in advance.

    Kind Regards,
    Jan



    ------------------------------
    Jan van Asseldonk | Consultant
    CTAC | +31629078169
    ------------------------------


  • 2.  RE: Fontstyle Header Run Log

    Employee
    Posted 12-10-2019 10:56
    Hi Jan,

    Yes, you can preserve header formatting by going to Options > Data Settings, and check "Preserve header formatting" under the Excel headers section. I ran a few tests and it works as expected (I'm using 12.1). Please note this is a global setting so it will apply to all of the scripts/data files for that user. 


    Another option is to set the log column somewhere to the far right where it won't be seen and then use a different cell with your own formatting. In the example below. I'm referencing the log header in cell AD and applied my own formatting in cell AD. 

    I hope this helps!


    ------------------------------
    Maria Simpson | Solutions Engineer
    Winshuttle North America | 4255276647
    ------------------------------



  • 3.  RE: Fontstyle Header Run Log

    Posted 12-11-2019 03:45
    Hi Maria,

    Thanks for your answer.
    But what we wanted to achieve goes a bit further.
    Formating in Excel can look like this:

    But after running the script this formatting is set back to the default.
    I guess this is not possible without using a formatting macro in Excel after running the script.

    Kind regards,
    Jan

    ------------------------------
    Jan van Asseldonk | Consultant
    CTAC | +31629078169
    ------------------------------

    Original Message