Welcome to Portal

?Unknown\pull-down

Welcome to Zoho Cares

Bienvenido a Soporte de Zoho

Search our knowledge base, ask the community or submit a request.

Supported Excel classes in Zoho Sheet

Classes
Properties
Methods
<Globals>
  • ActiveCell

  • ActiveChart

  • ActiveSheet

  • ActiveWindow

  • ActiveWorkbook

  • Application

  • Cells

  • Charts

  • Columns

  • Names

  • Parent

  • Range

  • Rows

  • Selection

  • Sheets

  • ThisWorkbook

  • Windows

  • Workbooks

  • WorksheetFunction

  • Worksheets


Application
  • ActiveCell

  • ActiveSheet

  • ActiveWindow

  • ActiveWorkbook

  • Application

  • Cells

  • Columns

  • DisplayAlerts

  • EnableEvents

  • Names

  • Parent

  • Range

  • Rows

  • ScreenUpdating

  • Selection

  • Sheets

  • ThisWorkbook

  • Windows

  • Workbooks

  • WorksheetFunction

  • Worksheets

  • Calculate

  • CalculateFull

  • CentimetersToPoints

  • InchesToPoints

  • Intersect

  • Union


Areas
  • Application

  • Count

  • Parent


  1. Item
Axis
  • Application

  • AxisTitle

  • HasTitle

  • Parent

No supported methods for this class
AxisTitle
  • Application

  • Caption

  • Parent

  • Text


  1. Delete
Border
  • Application

  • Color

  • LineStyle

  • Parent

  • Weight



No supported methods for this class
Borders
  • Application

  • Color

  • ColorIndex

  • Count

  • LineStyle

  • Parent

  • Value

  • Weight


  1. Item
Characters
  • Count

  • Font

  • Text

  • Insert

No supported methods for this class
Chart
  • Application

  • ChartTitle

  • ChartType

  • HasLegend

  • HasTitle

  • Parent

  • ApplyDataLabels

  • Axes

  • Delete

  • Refresh

  • SetSourceData

ChartObject
  • Application

  • Chart

  • Height

  • Left

  • Name

  • Parent

  • Top

  • Width

  • Delete

  • Duplicate

ChartObjects
  • Application

  • Count

  • Height

  • Left

  • Parent

  • Top

  • Width

  • Add

  • Delete

  • Duplicate

  • Item

ChartTitle
  • Application

  • Caption

  • Parent

  • Text


  1. Delete
ColorScale
  • ColorScaleObject

  • AppliesTo

  • ColorScaleCriteria

  • Index

  • Type

  • Value

  • FormatColor

  • Color

  • ColorIndex

No supported methods for this class
Comment
  • Application

  • Parent

  • Delete

  • Next

  • Previous

  • Text

Comments
  • Application

  • Count

  • Parent


  1. Item
FormatCondition
  • Font

  • Borders

  • Interior

  • Color

  • ColorIndex

  • Creator

  • FontStyle

  • Italic

  • Strikethrough

  • Underline

  • Bold

  • Item

  • Name

  • Size

  • LineStyle

  • Weight

No supported methods for this class
Font
  • Application

  • Bold

  • Color

  • ColorIndex

  • FontStyle

  • Italic

  • Name

  • Parent

  • Size

  • Strikethrough

  • Underline

No supported methods for this class
Hyperlink
  • Address

  • Application

  • Name

  • Parent

  • Range

  • TextToDisplay


  1. Delete
Hyperlinks
  • Application

  • Count

  • Parent

  • Add

  • Item

  • Delete

Interior
  • Application

  • Parent

  • Color

  • ColorIndex

No supported methods for this class
Name
  • Application

  • Name

  • Parent

  • RefersTo

  • RefersToR1C1

  • RefersToRange


  1. Delete
Names
  • Application

  • Count

  • Parent

  • Add

  • Item

Range
  • Address

  • Application

  • Areas

  • Borders

  • Cells

  • Column

  • Columns

  • Comment

  • ColumnWidth

  • CurrentRegion

  • Dependents

  • DirectDependents

  • DirectPrecedents

  • End

  • EntireColumn

  • EntireRow

  • Font

  • Formula

  • FormulaArray

  • FormulaR1C1

  • HasFormula

  • HorizontalAlignment

  • Hyperlinks

  • Interior

  • Item

  • Locked

  • MergeCells

  • MergeArea

  • Name

  • NumberFormat

  • Offset

  • Parent

  • Precedents

  • Range

  • Resize

  • Row

  • Rows

  • RowHeight

  • Text

  • Value

  • Value2

  • VerticalAlignment

  • WorkSheet

  • WrapText

  • Activate

  • AddComment

  • AutoFill

  • AutoFilter

  • AutoFit

  • BorderAround

  • Calculate

  • Clear

  • ClearComments

  • ClearContents

  • ClearFormats

  • ClearNotes

  • Copy

  • Cut

  • DataSeries

  • Delete

  • FillDown

  • FillLeft

  • FillRight

  • FillUp

  • Insert

  • Merge

  • Select

  • UnMerge

  • Sort

  • SpecialCells

RoutingSlip
  • Application

  • Delivery

  • Message

  • Parent

  • Recipients

  • Status

  • Subject


  1. Reset
Sheets
  • Application

  • Count

  • Parent

  • Add

  • Item

Window
  • ActiveCell

  • ActiveSheet

  • Application

  • Caption

  • Parent

  • RangeSelection

  • Selection

No supported methods for this class
Windows
  • Application

  • Count

  • Parent


  1. Item
Workbook
  • ActiveSheet

  • Application

  • HasRoutingSlip

  • Name

  • Names

  • Parent

  • Routed

  • RoutingSlip

  • Sheets

  • Windows

  • Worksheets

  • Route

  • Save

  • SaveAs

  • SaveCopyAs

  • SendMail

Worksheet
  • Application

  • Cells

  • Columns

  • Comments

  • Hyperlinks

  • Index

  • Name

  • Names

  • Parent

  • Range

  • Rows

  • UsedRange

  • Activate

  • Calculate

  • ChartObjects

  • Copy

  • Delete

  • Move

  • Select

  • Paste

WorksheetFunction
  • Application

  • Parent

  • Acos

  • Acosh

  • And

  • Asin

  • Asinh

  • Atan2

  • Atanh

  • Average

  • Bin2Dec

  • Bin2Hex

  • Bin2Oct

  • Ceiling

  • Choose

  • Clean

  • Combin

  • Convert

  • Count

  • CountA

  • CountBlank

  • CountIf

  • Days360

  • Dec2Bin

  • Dec2Hex

  • Dec2Oct

  • Degrees

  • Dollar

  • Even

  • EDate

  • EoMonth

  • Fact

  • Find

  • Fixed

  • Floor

  • Gcd

  • Hex2Dec

  • Hex2Oct

  • Hex2Bin

  • HLookup

  • Index

  • IsEven

  • IsErr

  • IsError

  • IsLogical

  • IsNA

  • IsNonText

  • IsNumber

  • IsOdd

  • IsText

  • Large

  • Lcm

  • Ln

  • Log

  • Log10

  • Lookup

  • Match

  • Max

  • Min

  • MRound

  • MultiNomial

  • NetworkDays

  • Oct2Hex

  • Oct2Bin

  • Oct2Hex

  • Odd

  • Or

  • Pi

  • Power

  • Product

  • Proper

  • Quotient

  • Radians

  • RandBetween

  • Replace

  • Rept

  • Roman

  • Round

  • RoundDown

  • RoundUp

  • Search

  • SeriesSum

  • Small

  • StDev

  • StDevP

  • Substitute

  • SubTotal

  • Sum

  • SumIf

  • SumSq

  • Tanh

  • Text

  • Trim

  • Var

  • VarP

  • VLookup

  • WeekDay

  • WeekNum

  • WorkDay

  • YearFrac

Worksheets
  • Application

  • Count

  • Parent

  • Add

  • FillAcrossSheets

  • Item



Helpful?02
Updated: 5 months ago
Share :