Question3Replies2077Views×Close popoverNaga Polisetti (NagaP504) Tata Consultancy Services Tata Consultancy Services US View ProfileSend Message NagaP504 Member since 2016 20 posts Tata Consultancy Services Posted: November 29, 2017Last activity: November 6, 2018Posted: 29 Nov 2017 17:35 ESTLast activity: 6 Nov 2018 20:02 EST Closed Solved Format text while writing into excel cell. -- OpenSpan / Pega RoboticsHi 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 etcUpdate : 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 ×Close popoverFacebookTwitterLinkedinEmail Copy Link Copied! Moderation Team has archived post 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 agoPosted: 30 Nov 2017 23:54 EST×Close popoverAndrew Grondin (grona) PEGA GCS Solutions Engineer I Pegasystems Inc. US View ProfileSend Messagegrona PEGA replied to NagaP504You 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 agoPosted: 12 Dec 2017 22:30 EST×Close popoverAkash Kumar (AkashK38) IBM Software Developer IBM IN View ProfileSend MessageAkashK38 IBM replied to gronaHi, 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 agoPosted: 13 Dec 2017 11:26 EST×Close popoverNaga Polisetti (NagaP504) Tata Consultancy Services Tata Consultancy Services US View ProfileSend MessageNagaP504 Tata Consultancy Services replied to AkashK38Thanks for the response... I was looking for this and got.