![xojo pass a control as a property xojo pass a control as a property](https://www.mbs-plugins.de/image/Web2Progress.jpg)
If needed, just pass format with the call. Please make sure your cell has a format showing the value as date with the desired formatting. You can write a date to a cell with WriteDate function and pass a DateTime with WriteDateTime function. To use Xojo Date and DateTime objects, we have functions in XLSheetMBS class. Since copy functions can copy from one book to another, you can convert from XLS to XLSX and back if needed. If you like you can also copy the whole sheet content from one sheet to another or to copy a sheet to another book. Similar you can copy a column in one sheet to another sheet, which can be in the same or other book. We have functions to copy rows from one sheet to other (or same) sheet. Our ReadStyledText function will read a cell containing rich text and translate to StyledText object for Xojo. With the AddStyledText method you can add text from a TextArea control into a new XLRichStringMBS object.įor your convenience the XLSheetMBS class has a method WriteStyledText, where you can directly pass StyledText from TextArea control to assign styled text to a cell. StyledText function on the class will convert the content to StyledText and return it, so you can directly assign it to a TextArea control. We got further and allow you to convert the rich text in Excel into the styled text as Xojo uses it. We don't just provide you functions to use rich text with XLRichStringMBS class. XLRichStringMBS allows access in detail on styled text.XLCopyOptionsMBS are used for our copy functions to define what to copy.XLAutoFilterMBS provides the properties for auto filter options.XLFilterColumnMBS defines filter options for a column.That may be as simple as bold or a color. XLFontMBS defines a font specification.XLFormatMBS defines the formatting of a cell, which may include a font definition.XLSheetMBS describes the individual sheets in an Excel document.XLBookMBS is the base class for a document.But we add a few of our own developments related to Xojo around that. That includes older XLS or newer XLSX format as well as templates. We support all the built-in features from LibXL like read/write Excel documents. You may have seen that we wrap LibXL into a plugin for Xojo: The MBS Xojo XL Plugin.