What Will I Learn?
In this video you will learn:
- How to create a LibreOffice Cal book using Basic
To use the following methods:
- CopybyName
- PageEnumeration
- GetByIndex
- GetByName
- GetCount.
- HasByName.
- HasElements.
- InsertNewByName
- MoveByName
- RemoveByName
Requirements
The tutorial tries to be self-contained but it is necessary:
- Intermediate knowledge of LibreOffice Calc
- Basic knowledge of programming
- This video is part of a series therefore the knowledge of the previous videos of the series is used.
Difficulty
- Intermediate
Description
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.
Video Tutorial
Curriculum
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:
- Introducción a las macros en LibreOffice
- LibreOffice Macros. Variables
- LibreOffice Macros. Variables Variant, constantes, variables de usuario y bloque With.
- LibreOffice Macros. Arreglos parte 1
- LibreOffice Macros. Arreglos 2: Redimensionamientos.
- LibreOffice Macros. Arreglos 3: Errores comunes
- LibreOffice Macros: Introducing LibreOffice Calc objects and how to use the Dispatcher. Automatic creation of tables with validation ranges.
Posted on Utopian.io - Rewarding Open Source Contributors