LibreOffice Macros: Manipulation of spreadsheets

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