API index
Every documented function and type, in alphabetical order. The pages of the API reference group them by area:
| Page | Covers | Guides |
|---|---|---|
| Files and worksheets | opening, creating and saving files; adding, copying, renaming, moving and deleting sheets; sheet visibility, tab colour, protection and printing | Creating and editing workbooks, Managing worksheets, Protecting a sheet, Page setup and printing |
| Images, comments and hyperlinks | images, cell comments and threaded comments, hyperlinks | Images, Comments, Hyperlinks |
| Cells and data | cell references, reading cells and ranges, formulas, defined names, data validation, error values | XLSX Tutorial, Using Formulas, Named ranges, Data validation |
| Tables | reading and writing tabular data; Excel Tables | Excel Tables |
| Cell formats | fonts, fills, borders, alignment, number formats, cell protection, rich text | Cell formats guide |
| Conditional formats | conditional formatting rules | Conditional formats guide |
| Sheet layout | widths and heights, hiding and grouping, merged cells, panes, AutoFilter, inserting and deleting rows and columns | see each section |
| Charts, Chart axes and elements, chartEx charts, Chart types | native Excel charts | Charts overview |
XLSX.ChartsXLSX.XL_DIV0XLSX.XL_NAXLSX.XL_NAMEXLSX.XL_NULLXLSX.XL_NUMXLSX.XL_REFXLSX.XL_SPILLXLSX.XL_VALUEXLSX.CellConcreteTypeXLSX.CellErrorTypeXLSX.CellImageXLSX.CellRefXLSX.Charts.AbstractChartXLSX.Charts.ChartXLSX.Charts.ChartAxisXLSX.Charts.ChartDataLabelXLSX.Charts.ChartDataPointXLSX.Charts.ChartErrorBarsXLSX.Charts.ChartExXLSX.Charts.ChartExBinningXLSX.Charts.ChartExDataXLSX.Charts.ChartExDimensionXLSX.Charts.ChartGroupXLSX.Charts.ChartMarkerXLSX.Charts.ChartRangeXLSX.Charts.ChartRangesXLSX.Charts.ChartRefXLSX.Charts.ChartSeriesXLSX.Charts.ChartTrendlineXLSX.Charts.ChartUpDownBarsXLSX.Charts.ColorSpecXLSX.Charts.DrawingBodyPropsXLSX.Charts.DrawingColorXLSX.Charts.DrawingFillXLSX.Charts.DrawingLineXLSX.Charts.DrawingParaPropsXLSX.Charts.DrawingParagraphXLSX.Charts.DrawingRunXLSX.Charts.DrawingRunPropsXLSX.Charts.DrawingShapePropsXLSX.Charts.DrawingTextXLSX.Charts.EffectiveXLSX.Charts.FormatSiteXLSX.DataTableXLSX.DefinedNameXLSX.RichTextRunXLSX.RichTextStringXLSX.SchemeColorXLSX.SheetCellRefXLSX.StreamSheetXLSX.StreamWriterXLSX.TableXLSX.TableStyleInfoXLSX.WorkbookXLSX.WorksheetXLSX.XLSXErrorXLSX.XLSXFileXLSX.XLSXFileXLSX.Charts.addChartXLSX.Charts.addChartExXLSX.Charts.addSeriesXLSX.Charts.deleteChartXLSX.Charts.getAutoTitleDeletedXLSX.Charts.getAxisCrossBetweenXLSX.Charts.getAxisCrossesXLSX.Charts.getAxisCrossesAtXLSX.Charts.getAxisGridlinesXLSX.Charts.getAxisLabelAlignXLSX.Charts.getAxisLabelOffsetXLSX.Charts.getAxisLogBaseXLSX.Charts.getAxisMajorTickMarkXLSX.Charts.getAxisMajorUnitXLSX.Charts.getAxisMaxXLSX.Charts.getAxisMinXLSX.Charts.getAxisMinorTickMarkXLSX.Charts.getAxisMinorUnitXLSX.Charts.getAxisMultiLevelLabelsXLSX.Charts.getAxisNumberFormatCodeXLSX.Charts.getAxisNumberFormatLinkedXLSX.Charts.getAxisOrientationXLSX.Charts.getAxisPartnerXLSX.Charts.getAxisShapePropsXLSX.Charts.getAxisTextPropsXLSX.Charts.getAxisTickLabelPosXLSX.Charts.getAxisTitleXLSX.Charts.getAxisTitleRangeXLSX.Charts.getAxisTitleRefXLSX.Charts.getAxisTitleTextXLSX.Charts.getAxisTitleTextPropsXLSX.Charts.getChartXLSX.Charts.getChartAxesXLSX.Charts.getChartAxisXLSX.Charts.getChartAxisIdsXLSX.Charts.getChartDataXLSX.Charts.getChartDataBlocksXLSX.Charts.getChartGroupsXLSX.Charts.getChartLegendXLSX.Charts.getChartRangesXLSX.Charts.getChartSchemaXLSX.Charts.getChartSeriesXLSX.Charts.getChartSeriesCountXLSX.Charts.getChartSpaceShapePropsXLSX.Charts.getChartSpaceTextPropsXLSX.Charts.getChartTitleXLSX.Charts.getChartTitleRangeXLSX.Charts.getChartTitleRefXLSX.Charts.getChartTitleShapePropsXLSX.Charts.getChartTitleTextXLSX.Charts.getChartTitleTextPropsXLSX.Charts.getChartTypeXLSX.Charts.getChartTypesXLSX.Charts.getChartsXLSX.Charts.getDataLabelOffsetXLSX.Charts.getDataLabelPositionXLSX.Charts.getDataLabelShapePropsXLSX.Charts.getDataLabelTextXLSX.Charts.getDataLabelTextPropsXLSX.Charts.getDataPointMarkerXLSX.Charts.getDataPointShapePropsXLSX.Charts.getDownBarShapePropsXLSX.Charts.getErrorBarsCustomRefsXLSX.Charts.getErrorBarsShapePropsXLSX.Charts.getGroupAxesXLSX.Charts.getGroupDropLinesXLSX.Charts.getGroupGapWidthXLSX.Charts.getGroupHiLowLinesXLSX.Charts.getGroupLabelTextPropsXLSX.Charts.getGroupOverlapXLSX.Charts.getGroupSeriesLinesXLSX.Charts.getGroupUpDownBarsXLSX.Charts.getLabelFlagXLSX.Charts.getLabelFlagXLSX.Charts.getLabelPositionXLSX.Charts.getLabelTextPropXLSX.Charts.getLegendEntryDeletedXLSX.Charts.getLegendOverlayXLSX.Charts.getLegendPosXLSX.Charts.getLegendShapePropsXLSX.Charts.getLegendTextPropsXLSX.Charts.getMarkerFillXLSX.Charts.getPlotAreaShapePropsXLSX.Charts.getSeriesAggregationXLSX.Charts.getSeriesAxesXLSX.Charts.getSeriesAxisIdsXLSX.Charts.getSeriesBinningXLSX.Charts.getSeriesDataXLSX.Charts.getSeriesDataLabelXLSX.Charts.getSeriesDataLabelsXLSX.Charts.getSeriesDataPointXLSX.Charts.getSeriesDataPointsXLSX.Charts.getSeriesErrorBarsXLSX.Charts.getSeriesFillXLSX.Charts.getSeriesGroupXLSX.Charts.getSeriesHiddenXLSX.Charts.getSeriesLabelTextPropsXLSX.Charts.getSeriesLayoutXLSX.Charts.getSeriesLayoutFlagXLSX.Charts.getSeriesLineXLSX.Charts.getSeriesMarkerXLSX.Charts.getSeriesNameXLSX.Charts.getSeriesNameRangeXLSX.Charts.getSeriesParentLabelLayoutXLSX.Charts.getSeriesQuartileMethodXLSX.Charts.getSeriesShapePropsXLSX.Charts.getSeriesSubtotalsXLSX.Charts.getSeriesTrendlinesXLSX.Charts.getTrendlineLabelShapePropsXLSX.Charts.getTrendlineLabelTextXLSX.Charts.getTrendlineLabelTextPropsXLSX.Charts.getTrendlineShapePropsXLSX.Charts.getUpBarShapePropsXLSX.Charts.hasFillXLSX.Charts.hasLineXLSX.Charts.makeComboXLSX.Charts.setAxisCrossesXLSX.Charts.setAxisCrossesAtXLSX.Charts.setAxisGridlinesXLSX.Charts.setAxisLineXLSX.Charts.setAxisMajorTickMarkXLSX.Charts.setAxisMajorUnitXLSX.Charts.setAxisMaxXLSX.Charts.setAxisMinXLSX.Charts.setAxisMinorTickMarkXLSX.Charts.setAxisMinorUnitXLSX.Charts.setAxisNumberFormatCodeXLSX.Charts.setAxisNumberFormatLinkedXLSX.Charts.setAxisOrientationXLSX.Charts.setAxisScalingXLSX.Charts.setAxisTextPropXLSX.Charts.setAxisTickLabelPosXLSX.Charts.setAxisTitleTextXLSX.Charts.setAxisTitleTextPropXLSX.Charts.setChartSpaceTextPropXLSX.Charts.setChartTitleTextXLSX.Charts.setChartTitleTextPropXLSX.Charts.setGroupGapWidthXLSX.Charts.setGroupLabelTextPropXLSX.Charts.setGroupOverlapXLSX.Charts.setLabelDeletedXLSX.Charts.setLabelFlagXLSX.Charts.setLabelFlagXLSX.Charts.setLabelTextXLSX.Charts.setLabelTextPropXLSX.Charts.setLegendEntryDeletedXLSX.Charts.setLegendOverlayXLSX.Charts.setLegendPosXLSX.Charts.setLegendTextPropXLSX.Charts.setMarkerXLSX.Charts.setMarkerFillXLSX.Charts.setMarkerLineColorXLSX.Charts.setMarkerLineWidthXLSX.Charts.setMarkerSizeXLSX.Charts.setMarkerSymbolXLSX.Charts.setPlotAreaLineXLSX.Charts.setSeriesAggregationXLSX.Charts.setSeriesBinningXLSX.Charts.setSeriesFillXLSX.Charts.setSeriesLayoutFlagXLSX.Charts.setSeriesLineXLSX.Charts.setSeriesLineCapXLSX.Charts.setSeriesLineColorXLSX.Charts.setSeriesLineCompoundXLSX.Charts.setSeriesLineDashXLSX.Charts.setSeriesLineJoinXLSX.Charts.setSeriesLineMiterLimitXLSX.Charts.setSeriesLineWidthXLSX.Charts.setSeriesNameXLSX.Charts.setSeriesParentLabelLayoutXLSX.Charts.setSeriesQuartileMethodXLSX.Charts.setSeriesSubtotalsXLSX.addCommentXLSX.addDataValidationXLSX.addDefinedNameXLSX.addHyperlinkXLSX.addImageXLSX.addShapeXLSX.addSparklinesXLSX.addTextBoxXLSX.addThreadedCommentXLSX.addThreadedReplyXLSX.addsheet!XLSX.addtable!XLSX.appendtable!XLSX.autofitColumnsXLSX.clearConditionalFormatsXLSX.column_numberXLSX.copysheet!XLSX.deleteAllDefinedNamesXLSX.deleteColumnsXLSX.deleteCommentXLSX.deleteCustomPropertyXLSX.deleteDataValidationXLSX.deleteDefinedNameXLSX.deleteHyperlinkXLSX.deleteImageXLSX.deleteRowsXLSX.deleteShapeXLSX.deleteSparklinesXLSX.deleteThreadedCommentXLSX.deletesheet!XLSX.deletetable!XLSX.eachrowXLSX.eachtablerowXLSX.freezePanesXLSX.getAlignmentXLSX.getAllDefinedNamesXLSX.getAutoFilterXLSX.getBorderXLSX.getCellImageXLSX.getCellImagesXLSX.getCellProtectionXLSX.getCheckboxesXLSX.getColumnOutlineLevelXLSX.getColumnWidthXLSX.getCommentXLSX.getCommentsXLSX.getConditionalFormatsXLSX.getCustomPropertiesXLSX.getCustomPropertyXLSX.getDataValidationXLSX.getDataValidationsXLSX.getDefinedNamesXLSX.getDocumentPropertiesXLSX.getFillXLSX.getFontXLSX.getFormatXLSX.getFormulaXLSX.getHeaderFooterXLSX.getHyperlinkXLSX.getHyperlinksXLSX.getIgnoredErrorsXLSX.getImagesXLSX.getMergedBaseCellXLSX.getMergedCellsXLSX.getPageMarginsXLSX.getPageSetupXLSX.getPrintAreaXLSX.getPrintOptionsXLSX.getPrintTitlesXLSX.getRichTextStringXLSX.getRowHeightXLSX.getRowOutlineLevelXLSX.getShapesXLSX.getSheetProtectionXLSX.getSheetViewXLSX.getSheetVisibilityXLSX.getSparklinesXLSX.getTabColorXLSX.getTextXLSX.getThreadedCommentXLSX.getThreadedCommentsXLSX.getWorkbookProtectionXLSX.getcellXLSX.getcellrangeXLSX.getdataXLSX.geterrorXLSX.gettableXLSX.gettablerangeXLSX.gettotalsXLSX.gettransposedtableXLSX.groupColumnsXLSX.groupRowsXLSX.hasCheckboxXLSX.hassheetXLSX.headerFooterFieldXLSX.headerFooterFontXLSX.insertColumnsXLSX.insertRowsXLSX.isColumnHiddenXLSX.isMergedCellXLSX.isRowHiddenXLSX.isSheetProtectedXLSX.isWorkbookProtectedXLSX.iserrorXLSX.loadXLSX.mergeCellsXLSX.movesheet!XLSX.newxlsxXLSX.opentemplateXLSX.openxlsxXLSX.protectSheetXLSX.protectWorkbookXLSX.readdataXLSX.readtableXLSX.readtoXLSX.readtransposedtableXLSX.readxlsxXLSX.removeAutoFilterXLSX.removeCheckboxXLSX.removeHeaderFooterXLSX.removeIgnoredErrorsXLSX.removeMergedCellsXLSX.removePanesXLSX.removePrintAreaXLSX.removePrintTitlesXLSX.removeTabColorXLSX.removetotals!XLSX.renamesheet!XLSX.row_numberXLSX.saveXLSX.savexlsxXLSX.setAlignmentXLSX.setAutoFilterXLSX.setBorderXLSX.setCellProtectionXLSX.setCheckboxXLSX.setColoredDataBarsXLSX.setColumnHiddenXLSX.setColumnWidthXLSX.setConditionalFormatXLSX.setCustomPropertyXLSX.setDocumentPropertiesXLSX.setFillXLSX.setFontXLSX.setFormatXLSX.setFormulaXLSX.setHeaderFooterXLSX.setIgnoredErrorsXLSX.setPageMarginsXLSX.setPageSetupXLSX.setPrintAreaXLSX.setPrintOptionsXLSX.setPrintTitlesXLSX.setRowHeightXLSX.setRowHiddenXLSX.setSheetViewXLSX.setSheetVisibilityXLSX.setTabColorXLSX.setThreadedCommentResolvedXLSX.setUniformAlignmentXLSX.setUniformBorderXLSX.setUniformFillXLSX.setUniformFontXLSX.setUniformFormatXLSX.setUniformStyleXLSX.settotals!XLSX.sheetcountXLSX.sheetnamesXLSX.splitFreezeXLSX.splitPanesXLSX.streamxlsxXLSX.tableXLSX.tablesXLSX.ungroupColumnsXLSX.ungroupRowsXLSX.unprotectSheetXLSX.unprotectWorkbookXLSX.writerow!XLSX.writetableXLSX.writetable!XLSX.writexlsx