Macros/Python Guide/Calc/Calc sheets

Return to Index

Sheets
In this Python Guide, we use the following convention:
 * sheet is a single spreadsheet within a document
 * workbook is a Calc document

CAUTION:

Copy or import function  from Useful functions

Names

 * Get all sheet names

Get sheets

 * Get active sheet from current document.


 * Get active sheet by index from current document


 * Get active sheet by name from current document

Activate
Send focus to any sheet

Change name

 * Change name visible to user


 * Change name visible only to code

Set sheet visibility

 * Set property  to   to hide a sheet; and set it to   to show it.

Password management

 * Set password


 * Remove password

Replace with a blank sheet
CAUTION: Use wisely. This function replaces a sheet  with a clean sheet.

Copy sheet

 * Rename a sheet

CAUTION: If new name exists, it will copy the sheet with name, and it will not get any error.


 * Copy into the same document


 * Copy (or import) from another document

Colorize a tab sheet
CAUTION

Copy or import the function  from Useful functions

Return to Index