Apps Script | Google for Developers

此页面由 Cloud Translation API 翻译。

兼容的 VBA API

以下 VBA API 在 Apps Script 中都有等效的 API，并且在大多数情况下都可以成功转换。

abs
application.activecell
application.activeprinter
application.activesheet
application.activeworkbook
application.alertbeforeoverwriting
application.application
application.asktoupdatelinks
application.autorecover
application.build
application.calculate
application.calculatefull
application.calculation
application.calculationstate
application.caption
application.celldraganddrop
application.centimeterstopoints
application.charts
application.columns
application.commandbars
application.copyobjectswithcells
application.cutcopymode
application.defaultfilepath
application.defaultsaveformat
application.defaultweboptions
application.displayalerts
application.displayclipboardwindow
application.displaycommentindicator
application.displayformulabar
application.displaynoteindicator
application.displayscrollbars
application.displaystatusbar
application.editdirectlyincell
application.enableanimations
application.enableautocomplete
application.enableevents
application.enablesound
application.getsaveasfilename
application.goto
application.help
application.hinstance
application.hlookup
application.hwnd
application.inchestopoints
application.interactive
application.intersect
application.iteration
application.left
application.mailsession
application.maxchange
application.maxiterations
application.moveafterreturn
application.moveafterreturndirection
application.name
application.names
application.networktemplatespath
application.operatingsystem
application.organizationname
application.path
application.pathseparator
application.printcommunication
application.quit
application.range
application.referencestyle
application.rollzoom
application.rows
application.screenupdating
application.selection
application.sheets
application.sheetsinnewworkbook
application.showstartupdialog
application.showtooltips
application.standardfont
application.standardfontsize
application.startuppath
application.statusbar
application.templatespath
application.thisworkbook
application.thousandsseparator
application.top
application.transitionmenukey
application.transitionmenukeyaction
application.transitionnavigkeys
application.union
application.usableheight
application.usablewidth
application.userlibrarypath
application.username
application.usesystemseparators
application.version
application.vlookup
application.volatile
application.wait
application.width
application.worksheetfunction
application.worksheets
areas.count
areas.item
asc
ascb
ascw
atn
autofilter.range
autofilter.showalldata
autofilter.sort
autorecover.enabled
autorecover.path
autorecover.time
border.color
border.colorindex
border.linestyle
border.themecolor
border.tintandshade
border.weight
borders.color
borders.colorindex
borders.item
borders.linestyle
borders.tintandshade
borders.value
borders.weight
cbool
ccur
cdate
cdbl
cdec
chart.application
chart.autoscaling
chart.chartarea
chart.charttitle
chart.charttype
chart.copy
chart.delete
chart.displayblanksas
chart.export
chart.hasdatatable
chart.haslegend
chart.haspivotfields
chart.hastitle
chart.index
chart.legend
chart.location
chart.move
chart.name
chart.parent
chart.paste
chart.perspective
chart.plotvisibleonly
chart.printout
chart.printpreview
chart.protectcontents
chart.rightangleaxes
chart.select
chart.seriescollection
chart.setsourcedata
chart.showallfieldbuttons
chart.tab
chart.visible
chartarea.autoscalefont
chartarea.height
chartarea.left
chartarea.shadow
chartarea.top
chartarea.width
chartfillformat.solid
chartobject.chart
chartobject.copy
chartobject.cut
chartobject.delete
chartobject.height
chartobject.left
chartobject.locked
chartobject.name
chartobject.parent
chartobject.placement
chartobject.top
chartobject.width
chartobjects.add
chartobjects.count
chartobjects.delete
chartobjects.item
chartsheet.activate
chartsheet.chartobjects
chartsheet.delete
chartsheet.move
chartsheet.name
chartsheet.select
chartsheet.visible
charttitle.autoscalefont
charttitle.caption
charttitle.text
choose
chr
chrw
cint
clng
clngptr
collection.add
collection.count
collection.item
collection.remove
commandbar.adaptivemenu
commandbar.height
commandbar.left
commandbar.top
commandbar.width
commandbarbutton.begingroup
commandbarbutton.builtin
commandbarbutton.builtinface
comment.delete
comment.parent
comment.visible
cos
createobject
cstr
customlayouts.paste
cverr
date
dateadd
datediff
datepart
dateserial
datevalue
day
debug.print
defaultweboptions.alwayssaveindefaultencoding
defaultweboptions.checkifofficeishtmleditor
defaultweboptions.loadpictures
defaultweboptions.savehiddendata
defaultweboptions.savenewwebpagesaswebarchives
defaultweboptions.updatelinksonsave
dictionary.add
dictionary.comparemode
dictionary.keys
documentproperty.linktocontent
documentproperty.name
documentproperty.type
documentproperty.value
environ
err.clear
err.description
err.number
err.raise
err.source
error
errorcheckingoptions.backgroundchecking
errorcheckingoptions.numberastext
exp
filelen
filter
fix
font.bold
font.color
font.colorindex
font.fontstyle
font.italic
font.name
font.outlinefont
font.shadow
font.size
font.strikethrough
font.subscript
font.superscript
font.themecolor
font.themefont
font.tintandshade
font.underline
format
formatconditions.add
formatconditions.item
formatdatetime
formatnumber
formatpercent
global.activecell
global.activesheet
global.activewindow
global.activeworkbook
global.application
global.calculate
global.cells
global.charts
global.columns
global.creator
global.err
global.intersect
global.load
global.names
global.parent
global.range
global.rows
global.selection
global.sheets
global.thisworkbook
global.union
global.unload
global.userforms
global.workbooks
global.worksheetfunction
global.worksheets
hex
hour
hyperlink.address
hyperlink.delete
hyperlink.follow
hyperlink.name
hyperlink.parent
hyperlink.range
hyperlink.screentip
hyperlink.subaddress
hyperlink.texttodisplay
hyperlinks.add
hyperlinks.count
hyperlinks.delete
iif
inputbox
instr
instrrev
int
interior.color
interior.colorindex
interior.pattern
interior.patterncolorindex
interior.patterntintandshade
interior.themecolor
interior.tintandshade
isarray
isdate
isempty
iserror
ismissing
isnull
isnumeric
isobject
join
lbound
lcase
left
legend.autoscalefont
legend.clear
legend.delete
legend.position
legend.shadow
len
lenb
log
ltrim
math.abs
math.round
mid
minute
month
monthname
msgbox
name.delete
name.name
name.refersto
name.referstorange
name.value
names.add
names.count
names.item
now
oct
oleobject.enabled
oleobject.visible
pagesetup.draft
pagesetup.printnotes
pictures.paste
pivotcache.createpivottable
pivotcaches.create
pivotfield.orientation
pivottable.adddatafield
pivottable.clearallfilters
pivottable.columngrand
pivottable.displayemptycolumn
pivottable.displayfieldcaptions
pivottable.enabledrilldown
pivottable.manualupdate
pivottable.parent
pivottable.pivotfields
pivottable.refreshtable
pivottable.rowgrand
pivottable.savedata
pivottable.showdrillindicators
pivottables.count
plotarea.name
pmt
qbcolor
querytable.backgroundquery
querytable.rownumbers
querytable.textfilepromptonrefresh
querytable.webdisableredirections
range.activate
range.addcomment
range.addindent
range.address
range.addresslocal
range.areas
range.autofill
range.autofilter
range.autofit
range.borderaround
range.borders
range.calculate
range.cells
range.characters
range.clear
range.clearcomments
range.clearcontents
range.clearformats
range.clearnotes
range.column
range.columndifferences
range.columns
range.columnwidth
range.comment
range.copy
range.count
range.countlarge
range.currentregion
range.cut
range.delete
range.dependents
range.end
range.entirecolumn
range.entirerow
range.exportasfixedformat
range.filldown
range.fillleft
range.fillright
range.fillup
range.find
range.findnext
range.font
range.formatconditions
range.formula
range.formular1c1
range.hasformula
range.height
range.horizontalalignment
range.hyperlinks
range.indentlevel
range.insert
range.interior
range.left
range.listnames
range.merge
range.mergearea
range.mergecells
range.name
range.next
range.numberformat
range.offset
range.orientation
range.parent
range.paste
range.pastespecial
range.pivottable
range.prefixcharacter
range.previous
range.printout
range.range
range.readingorder
range.removeduplicates
range.replace
range.resize
range.row
range.rowheight
range.rows
range.select
range.show
range.shrinktofit
range.sort
range.specialcells
range.style
range.text
range.texttocolumns
range.top
range.unmerge
range.usestandardheight
range.usestandardwidth
range.validation
range.value
range.verticalalignment
range.width
range.worksheet
range.wraptext
recentfiles.maximum
regexp.global
regexp.ignorecase
regexp.pattern
regexp.test
replace
rgb
right
rnd
round
rtrim
second
selection.paste
selection.pastespecial
series.markersize
series.markerstyle
series.shadow
series.trendlines
sgn
shape.placement
shaperange.visible
shapes.addpicture
shapes.paste
shapes.pastespecial
sheets.add
sheets.application
sheets.copy
sheets.count
sheets.delete
sheets.parent
sheets.printout
sheets.printpreview
sheets.select
sheets.visible
sin
slides.paste
sort.apply
sort.header
sort.matchcase
sort.orientation
sort.setrange
sort.sortfields
sort.sortmethod
sortfields.add
sortfields.clear
space
split
sqr
str
strcomp
strconv
string
strreverse
styles.count
tab.color
tab.colorindex
tab.themecolor
tan
textrange.paste
time
timer
timeserial
timevalue
trim
typename
ubound
ucase
userform.caption
val
validation.add
validation.delete
validation.ignoreblank
validation.incelldropdown
validation.inputmessage
validation.inputtitle
validation.showerror
validation.showinput
validation.type
vartype
weboptions.allowpng
weboptions.downloadcomponents
weboptions.relyoncss
weboptions.relyonvml
weboptions.uselongfilenames
weekday
weekdayname
window.activecell
window.activesheet
window.caption
window.close
window.displaygridlines
window.displayheadings
window.displayhorizontalscrollbar
window.displayoutline
window.displayverticalscrollbar
window.displayworkbooktabs
window.displayzeros
window.freezepanes
window.height
window.largescroll
window.left
window.rangeselection
window.scrollcolumn
window.scrollrow
window.scrollworkbooktabs
window.selectedsheets
window.selection
window.smallscroll
window.split
window.top
window.type
window.usableheight
window.usablewidth
window.view
window.visible
window.width
window.zoom
workbook.activate
workbook.activesheet
workbook.application
workbook.author
workbook.charts
workbook.close
workbook.colors
workbook.container
workbook.customdocumentproperties
workbook.enableautorecover
workbook.envelopevisible
workbook.exclusiveaccess
workbook.exportasfixedformat
workbook.fileformat
workbook.followhyperlink
workbook.fullname
workbook.fullnameurlencoded
workbook.hasroutingslip
workbook.multiuserediting
workbook.name
workbook.names
workbook.parent
workbook.password
workbook.path
workbook.pivotcaches
workbook.precisionasdisplayed
workbook.printout
workbook.printpreview
workbook.protect
workbook.protectwindows
workbook.readonly
workbook.readonlyrecommended
workbook.refreshall
workbook.resetcolors
workbook.save
workbook.saveas
workbook.savecopyas
workbook.saved
workbook.sendmail
workbook.sheets
workbook.unprotect
workbook.worksheets
workbooks.add
workbooks.count
workbooks.item
worksheet.activate
worksheet.application
worksheet.autofilter
worksheet.autofiltermode
worksheet.calculate
worksheet.cells
worksheet.chartobjects
worksheet.columns
worksheet.copy
worksheet.customproperties
worksheet.delete
worksheet.displayrighttoleft
worksheet.enableautofilter
worksheet.enableoutlining
worksheet.enableselection
worksheet.exportasfixedformat
worksheet.filtermode
worksheet.hyperlinks
worksheet.index
worksheet.move
worksheet.name
worksheet.names
worksheet.next
worksheet.parent
worksheet.paste
worksheet.pivottables
worksheet.previous
worksheet.printout
worksheet.printpreview
worksheet.protect
worksheet.protectcontents
worksheet.protectdrawingobjects
worksheet.protectionmode
worksheet.range
worksheet.rows
worksheet.select
worksheet.showalldata
worksheet.sort
worksheet.tab
worksheet.transitionexpeval
worksheet.type
worksheet.unprotect
worksheet.usedrange
worksheet.visible
worksheetfunction.acos
worksheetfunction.asin
worksheetfunction.average
worksheetfunction.averageif
worksheetfunction.binomdist
worksheetfunction.ceiling
worksheetfunction.chiinv
worksheetfunction.choose
worksheetfunction.clean
worksheetfunction.convert
worksheetfunction.correl
worksheetfunction.count
worksheetfunction.counta
worksheetfunction.countblank
worksheetfunction.countif
worksheetfunction.countifs
worksheetfunction.degrees
worksheetfunction.edate
worksheetfunction.even
worksheetfunction.find
worksheetfunction.floor
worksheetfunction.forecast
worksheetfunction.frequency
worksheetfunction.gammaln
worksheetfunction.gcd
worksheetfunction.hlookup
worksheetfunction.iferror
worksheetfunction.index
worksheetfunction.intercept
worksheetfunction.irr
worksheetfunction.iserr
worksheetfunction.iserror
worksheetfunction.isformula
worksheetfunction.islogical
worksheetfunction.isna
worksheetfunction.isnumber
worksheetfunction.istext
worksheetfunction.kurt
worksheetfunction.large
worksheetfunction.ln
worksheetfunction.log
worksheetfunction.lookup
worksheetfunction.match
worksheetfunction.max
worksheetfunction.median
worksheetfunction.min
worksheetfunction.mmult
worksheetfunction.mode
worksheetfunction.networkdays
worksheetfunction.normdist
worksheetfunction.norminv
worksheetfunction.normsdist
worksheetfunction.normsinv
worksheetfunction.npv
worksheetfunction.percentile
worksheetfunction.pi
worksheetfunction.poisson
worksheetfunction.power
worksheetfunction.product
worksheetfunction.proper
worksheetfunction.radians
worksheetfunction.randbetween
worksheetfunction.rank
worksheetfunction.replace
worksheetfunction.rept
worksheetfunction.roman
worksheetfunction.round
worksheetfunction.rounddown
worksheetfunction.roundup
worksheetfunction.rsq
worksheetfunction.search
worksheetfunction.skew
worksheetfunction.slope
worksheetfunction.small
worksheetfunction.stdev
worksheetfunction.substitute
worksheetfunction.subtotal
worksheetfunction.sum
worksheetfunction.sumif
worksheetfunction.sumifs
worksheetfunction.sumproduct
worksheetfunction.text
worksheetfunction.tinv
worksheetfunction.transpose
worksheetfunction.trim
worksheetfunction.vlookup
worksheetfunction.weekday
worksheetfunction.weeknum
worksheetfunction.workday
worksheets.add
worksheets.copy
worksheets.count
year

兼容的 VBA API

相关文章