Reading and Writing values to Ranges

Macros in LibreOffice Calc often need to read and write values from/to sheets. This help page describes the various approaches to accessing sheets and ranges to read or write their values.

Sajoo Yaaddannoo

All examples presented in this page can be implemented both in Basic and Python.


Accessing a Single Cell

The example below enters the numeric value 123 into cell "A1" of the current sheet.