formatting columns to be written in excel

[Alter_Shivi]

Hi All,

I am trying to write an output in sharepoint in an excel file. Now i want some basic formatting in the excel like enabling filter to the headers, may be also color code certain sections. is there a way to do this?

[aatalai]

@Alter_Shivi I would recommend starting with using the SharePoint output tool, going to configure file and selecting write headers

Please let me know how you get on

[Alter_Shivi]

@aatalai it does make the header bold, but not keeps them in filter enabled mode. also color coding a few columns cant be achieved with this mode.

[aatalai]

@Alter_Shivi my next solution would be you would need your SharePoint to be synced to your local machine; use the table tool and use the orange rendering tool to output it. Hope this helps