Sheet

This class represents a sheet.

Properties

Application through getApplication

ChartObjects through getChartObjects

DataPilotTables through getDataPilotTables

Index through getIndex

Name through getName and setName

Next through next

Previous through previous

Protected through isProtected

UsedRange through getUsedRange

Visible through isVisible

Methods

activate

calculate

copyTo

moveTo

print

protect

unProtect

remove

cells

columns

rows

dataPilotTableWizard

range

importCSVFile

importFile

Creation and access

Usage

Sheet provides access to ranges, columns, rows, cells, chart objects and DataPilot tables, and provide ways to import data from text csv file and spreadsheet.

To calculate all the formulas in the sheet, use the Calculate method, to protect the sheet from modification, use the Protect method.

See examples

Example: Sheet