Spreadsheets

This class represents a collection of all the opened spreadsheets.

Properties

Application through getApplication

Count through getCount

Methods

addSpreadsheet

closeSpreadsheets

item

openSpreadsheet

saveSpreadsheets

Access

Usage

Spreadsheets provides access to spreadsheets, and methods to create new spreadsheets, open existing spreadsheets, and save and close all opened spreadsheets.

A spreadsheet document can be created and opened in two ways: visible mode and not visible mode, see addSpreadsheet method and openSpreadsheet method.

See examples

Example: Spreadsheets