API index

Every documented function and type, in alphabetical order. The pages of the API reference group them by area:

PageCoversGuides
Files and worksheetsopening, creating and saving files; adding, copying, renaming, moving and deleting sheets; sheet visibility, tab colour, protection and printingCreating and editing workbooks, Managing worksheets, Protecting a sheet, Page setup and printing
Images, comments and hyperlinksimages, cell comments and threaded comments, hyperlinksImages, Comments, Hyperlinks
Cells and datacell references, reading cells and ranges, formulas, defined names, data validation, error valuesXLSX Tutorial, Using Formulas, Named ranges, Data validation
Tablesreading and writing tabular data; Excel TablesExcel Tables
Cell formatsfonts, fills, borders, alignment, number formats, cell protection, rich textCell formats guide
Conditional formatsconditional formatting rulesConditional formats guide
Sheet layoutwidths and heights, hiding and grouping, merged cells, panes, AutoFilter, inserting and deleting rows and columnssee each section
Charts, Chart axes and elements, chartEx charts, Chart typesnative Excel chartsCharts overview