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.
Accepted Solution
IBM
IN
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
Pegasystems Inc.
US
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
IBM
IN
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