Question 3 Replies 2106 Views × Close popover Naga Polisetti (NagaP504) Tata Consultancy Services Tata Consultancy Services US View Profile Send Message NagaP504 Member since 2016 20 posts Tata Consultancy Services Posted: November 29, 2017 Last activity: November 6, 2018 Posted: 29 Nov 2017 17:35 EST Last activity: 6 Nov 2018 20:02 EST Closed Solved Format text while writing into excel cell. -- OpenSpan / Pega Robotics Hi Community, Is there any way that i can format the text that i need to write into excel cell in OpenSpan ? [I may be missing something to check, i believe there must be a way] Eg : Setting up the font size, color, Bold etc Update : Also, please let me know how to format the data of a excel column while you read. eg : Take the XL column as Date values instead of numbers. I found that we have the methods to do it from "Used Range" object. But unable to choose which one i need to use. Any example will help me here. Thanks. Robotic Process Automation Share × Close popover Facebook Twitter Linkedin Email Copy Link Copied! Moderation Team has archived post, learn more × Close popover This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question. Posted: 3 years ago Posted: 30 Nov 2017 23:54 EST × Close popover Andrew Grondin (grona) PEGA GCS Solutions Engineer I Pegasystems Inc. US View Profile Send Message grona PEGA replied to NagaP504 You can use the stringutils component but at base I don't think it has anything to change text ascetic. http://help.openspan.com/80/Components/string_utilities_component2.htm Accepted Solution Posted: 3 years ago Posted: 12 Dec 2017 22:30 EST × Close popover Akash Kumar (AkashK38) IBM Software Developer IBM IN View Profile Send Message AkashK38 IBM replied to grona Hi, You can use the below technique to set font color,width and BG color. In a similar way u can use font property to set color using color index. Please find the attachment. Thanks and Regards, Akash Posted: 3 years ago Posted: 13 Dec 2017 11:26 EST × Close popover Naga Polisetti (NagaP504) Tata Consultancy Services Tata Consultancy Services US View Profile Send Message NagaP504 Tata Consultancy Services replied to AkashK38 Thanks for the response... I was looking for this and got.