Once you have completed the Web Quickstart, this tutorial will walk you through creating a more intermediate web app, a Task Manager. With the IDE, you can build your app's interface simply by dragging and dropping interface objects onto the app's web pages and dialogs. Xojo is a cross-platform integrated development environment (IDE) that is made up of a rich set of graphical user interface objects, the modern object-oriented Xojo programming language, an integrated debugger, and a multi-platform compiler. 2.9 Finding and Fixing Bugs: The Fine Art of Debugging.2.5 Customizing Controls with Properties.2.3 About the App You Are About to Create.Let us know if you have any questions or another function may be missing for you. Calling new functions may cause a crash as the plugin may expect them where they may not be. Similar you can of course load an older version, but please be cautious. The plugin will stop using the built-in library.
#Xojo pass a control as a property download#
If there is a newer release coming of the library and you like to use it, we have a way for you: Download the newer library and use LoadLibrary functions in XLBookMBS class to load it. The plugin is built with the current LibXL library at the time of building the plugin. When loading documents with shared Load methods, we figure out the format and initialize the right book object and load the value. With XML mode you edit a XLSX document and otherwise you edit the older XLS format. Instead of reading values as number, text, boolean or date, you can get it as variant.Īn XLBookMBS can either be in XML mode or not. We have a few convenience functions to read cells in a sheet as variant. For this reason we provide six MT functions, optimized for being used in a Xojo thread, so they yield time to other threads. Loading or saving an Excel document can take some time. Just use the ColorRGB property on the XLFontMBS class. But when using RGB mode, you can set and get colors with the color data type. In general LibXL handles colors in either index mode or RGB mode. To read you can use ReadDate and ReadDateTime functions which translate the numeric timestamp in Excel to a Xojo Date or DateTime object. 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.
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.