LibreOffice Macros: Manipulation of spreadsheets

zenkly(63)

Published in

#utopian-io

Words

332

Reading

2 min

Listen

Play

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

Thumbnail of the video.

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: