These objects were briefly explained in part 2 of these series of tutorials. This will allow us to access these objects from other functions, like out main() function. In this ‘context()’ method, we first declare the 3 useful variables that will hold our objects as Global Variables. You can either define these variables at the global level of your program or like I like to do, in a separate function that I call context() to make it more customizable in later programs. This XSCRIPTCONTEXT is a UNO object that gather all you need to manipulate LibreOffice Documents with Python scripts. Please refer to my previous tutorials for creating a program and using the APSO console.įirst you need to define the variables provided by XSCRIPTCONTEXT. We’ll see how to manage them in a later post.Ī good way to illustrate the 4 different cell types is to play with them with a simple python code that will display in the console the type of cell selected in LibreOffice Calc. formula is the type of any LibreOffice Calc cell that contain a formula.ĭates, currencies, decimals, booleans within LibreOffice are not types but different formats of numbers.string is the type of any text content of a LibreOffice Calc cell. value is the type of any numerical content of a LibreOffice Calc cell.empty is simply the type of an empty LibreOffice Calc cell. These types names are quite self-explanatory: Its type comes from its content and can only be one of the 4 following types: In this episode of my LibreOffice Calc & Python Programming tutorial series I am going to talk about the different types of data stored in a LibreOffice cell, and what type to use in the Python code to keep the same data type than in LibreOffice.Ī cell within a LibreOffice Table has no predefined type.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |