Hi, I have this automation that outputs the sums and headers from another report sheet which I provided down below. I want to add a blue color to the headers. How and where in my code can I add color to the headers once it outputs the table (screenshot below of output).
Main - Copy.xaml (37.8 KB)
CurrentYearConcurYTD - Copy.xlsx (67.0 KB)
We have Set Range Color in Excel Application Scope Activity.
- Use Excel Application Scope activity and provide file path.
- Drag Set Range Color activity and provide below parameters.
Color = System.Drawing.Color.Blue
Range = “A1:F1”
SheetName = “March 2021_temp”
Please find below attached image for more information.
In addition to solution provided by @Vijay_Kumar_C , i would like to add one more point here
if the column numbers are varying, u can use the below method to give the dynamic range in set range color as specified by @Vijay_Kumar_C
Hi, thank you so much for this I really appreciate that. So in addition to this, how can I make it where all 3 months (January, February, and March) have that color instead of just march having the color
Nevermind I just added the rowU(“Billing Period”).ToString+“_temp” to my SheetName Input, thank you for your help!
This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.