In this video you will learn:
To use the following methods:
The tutorial tries to be self-contained but it is necessary:
Today we are going to see some of the methods that we can use to manipulate "LibreOffice" Calc spreadsheets. The methods that we are going to use today are the following ones: CopybyName that will allow us to copy a sheet to a sheet new, PageEnumeration will allow us to create a numbering to manipulate the spreadsheets of the calculation book, GetByIndex, through this method we can call a spreadsheet from its index, GetByName to send leaves through its name of these sheets , GetCount will allow us to know the number of sheets in a book, HasByName, to verify the existence of a sheet, HasElements will inform us if a document contains spreadsheets. InsertNewByName is a method that will allow us to create a new spreadsheet by specifying its name, MoveByName will allow us to move a sheet through its name and RemoveByName will allow deleting a sheet specifying its name.
Although the current video is in English, some of the previous videos are in Spanish. You can find the other videos of the series in the following links: