StyledText for Excel files with LibXL 3.9 in Xojo
We recently moved to LibXL version 3.9, which adds support to styled text for use in Excel files. We added a new XLRichStringMBS class to have all the options available within the LibXL library. But we also added support for working with StyledText class directly. You can just pass the styled text from a TextArea control directly to be used to set a cell in your document. Same for reading, where we translate the styles back. Here is an example to write a cell:
The XLRichStringMBS class allows you to use a XLFontMBS class with the following styling properties to be used: color, italic, bold, single/double underline, strikeout, font name, sub/superscript and font size. Converting from StyledText we pass through bold, italic, underline, font name, size and color. When you call WriteStyledText, you can optionally include a format object, which defines e.g. alignment.
Please try the new functionality and don't hesitate to contact us with questions. This is already included in 20.2pr4 download.