> For the complete documentation index, see [llms.txt](https://xlswriter-docs.viest.me/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://xlswriter-docs.viest.me/english.md). # English - [Overview](https://xlswriter-docs.viest.me/english/en.md) - [Install](https://xlswriter-docs.viest.me/english/install.md) - [Env requirements](https://xlswriter-docs.viest.me/english/install/requirements.md) - [PECL (recommend)](https://xlswriter-docs.viest.me/english/install/pecl.md) - [Mac](https://xlswriter-docs.viest.me/english/install/mac.md) - [Alpine](https://xlswriter-docs.viest.me/english/install/alpine.md) - [Ubuntu](https://xlswriter-docs.viest.me/english/install/ubuntu.md) - [Windows](https://xlswriter-docs.viest.me/english/install/windows.md) - [Quick start](https://xlswriter-docs.viest.me/english/quick-start.md) - [Create file](https://xlswriter-docs.viest.me/english/quick-start/create.md) - [Read file](https://xlswriter-docs.viest.me/english/quick-start/reader.md) - [Cell](https://xlswriter-docs.viest.me/english/cell.md) - [Insert text](https://xlswriter-docs.viest.me/english/cell/insert-text.md) - [Insert link](https://xlswriter-docs.viest.me/english/cell/insert-link.md) - [Insert formula](https://xlswriter-docs.viest.me/english/cell/insert-formula.md) - [Insert date](https://xlswriter-docs.viest.me/english/cell/insert-date.md) - [Insert local image](https://xlswriter-docs.viest.me/english/cell/insert-image.md) - [Insert rich text](https://xlswriter-docs.viest.me/english/cell/rich-text.md) - [Insert comment](https://xlswriter-docs.viest.me/english/cell/insert-comment.md) - [Auto filter](https://xlswriter-docs.viest.me/english/cell/auto-filter.md) - [Freeze panes](https://xlswriter-docs.viest.me/english/cell/freeze-panes.md) - [Merge cells](https://xlswriter-docs.viest.me/english/cell/merge-cells.md) - [Row cell style](https://xlswriter-docs.viest.me/english/cell/row-style.md) - [Column cell style](https://xlswriter-docs.viest.me/english/cell/column-style.md) - [Worksheet](https://xlswriter-docs.viest.me/english/worksheet.md) - [Create worksheet](https://xlswriter-docs.viest.me/english/worksheet/create.md) - [Switch worksheet](https://xlswriter-docs.viest.me/english/worksheet/switch.md) - [Check worksheet exists](https://xlswriter-docs.viest.me/english/worksheet/sheet-exist.md) - [Gridlines](https://xlswriter-docs.viest.me/english/worksheet/gridlines.md) - [Zoom](https://xlswriter-docs.viest.me/english/worksheet/zoom.md) - [Hide current worksheet](https://xlswriter-docs.viest.me/english/worksheet/hide.md) - [Set as first worksheet](https://xlswriter-docs.viest.me/english/worksheet/first.md) - [Tab color](https://xlswriter-docs.viest.me/english/worksheet/tab-color.md) - [Background image](https://xlswriter-docs.viest.me/english/worksheet/background-image.md) - [Memory model](https://xlswriter-docs.viest.me/english/memory.md) - [Fixed memory mode](https://xlswriter-docs.viest.me/english/memory/fixed-memory.md) - [Style](https://xlswriter-docs.viest.me/english/style.md) - [Combination style](https://xlswriter-docs.viest.me/english/style/combination.md) - [Global default style](https://xlswriter-docs.viest.me/english/style/default-format.md) - [Style list](https://xlswriter-docs.viest.me/english/style-list.md) - [Italic](https://xlswriter-docs.viest.me/english/style-list/italic.md) - [Align](https://xlswriter-docs.viest.me/english/style-list/align.md) - [Strikethrough](https://xlswriter-docs.viest.me/english/style-list/strikethrough.md) - [Underline](https://xlswriter-docs.viest.me/english/style-list/underline.md) - [Text wrap](https://xlswriter-docs.viest.me/english/style-list/text-wrap.md) - [Font color](https://xlswriter-docs.viest.me/english/style-list/font-color.md) - [Font size](https://xlswriter-docs.viest.me/english/style-list/font-size.md) - [Bold](https://xlswriter-docs.viest.me/english/style-list/bold.md) - [Cell border](https://xlswriter-docs.viest.me/english/style-list/cell-border.md) - [Border of the four sides](https://xlswriter-docs.viest.me/english/style-list/border-four-sides.md) - [Border color](https://xlswriter-docs.viest.me/english/style-list/border-color.md) - [Border style constants](https://xlswriter-docs.viest.me/english/style-list/border-style-constants.md) - [Background color](https://xlswriter-docs.viest.me/english/style-list/background-color.md) - [Color constants](https://xlswriter-docs.viest.me/english/style-list/color-constants.md) - [Font](https://xlswriter-docs.viest.me/english/style-list/font.md) - [Number format](https://xlswriter-docs.viest.me/english/style-list/number.md) - [Rotation](https://xlswriter-docs.viest.me/english/style-list/rotation.md) - [Indent](https://xlswriter-docs.viest.me/english/style-list/indent.md) - [Cell protection](https://xlswriter-docs.viest.me/english/style-list/cell-protection.md) - [Chart](https://xlswriter-docs.viest.me/english/chart.md) - [Chart type constants](https://xlswriter-docs.viest.me/english/chart/chart-type-constants.md) - [Data input](https://xlswriter-docs.viest.me/english/chart/data-input.md) - [Doughnut chart](https://xlswriter-docs.viest.me/english/chart/doughnut.md) - [Area chart](https://xlswriter-docs.viest.me/english/chart/area.md) - [Histogram chart](https://xlswriter-docs.viest.me/english/chart/histogram.md) - [Bar chart](https://xlswriter-docs.viest.me/english/chart/bar.md) - [Conditional format](https://xlswriter-docs.viest.me/english/conditional-format.md) - [Single cell rule](https://xlswriter-docs.viest.me/english/conditional-format/cell.md) - [Range rule](https://xlswriter-docs.viest.me/english/conditional-format/range.md) - [Data bar](https://xlswriter-docs.viest.me/english/conditional-format/data-bar.md) - [Icon set](https://xlswriter-docs.viest.me/english/conditional-format/icons.md) - [Multi range](https://xlswriter-docs.viest.me/english/conditional-format/multi-range.md) - [Type constants](https://xlswriter-docs.viest.me/english/conditional-format/type-constants.md) - [Criteria constants](https://xlswriter-docs.viest.me/english/conditional-format/criteria-constants.md) - [Data validation](https://xlswriter-docs.viest.me/english/validation.md) - [Drop-down list](https://xlswriter-docs.viest.me/english/validation/type-list.md) - [Range constraint](https://xlswriter-docs.viest.me/english/validation/criteria-between.md) - [Greater than constraint](https://xlswriter-docs.viest.me/english/validation/criteria-greater-than.md) - [Validation API reference](https://xlswriter-docs.viest.me/english/validation/api-reference.md) - [Excel table](https://xlswriter-docs.viest.me/english/table.md) - [Columns](https://xlswriter-docs.viest.me/english/table/columns.md) - [Style](https://xlswriter-docs.viest.me/english/table/style.md) - [Options](https://xlswriter-docs.viest.me/english/table/options.md) - [Page setup](https://xlswriter-docs.viest.me/english/page-setup.md) - [Paper size](https://xlswriter-docs.viest.me/english/page-setup/paper.md) - [Margins](https://xlswriter-docs.viest.me/english/page-setup/margins.md) - [Orientation](https://xlswriter-docs.viest.me/english/page-setup/orientation.md) - [Print scale](https://xlswriter-docs.viest.me/english/page-setup/scale.md) - [Landscape](https://xlswriter-docs.viest.me/english/page-setup/landscape.md) - [Portrait](https://xlswriter-docs.viest.me/english/page-setup/portrait.md) - [Header and footer](https://xlswriter-docs.viest.me/english/page-setup/header-footer.md) - [Repeat rows](https://xlswriter-docs.viest.me/english/page-setup/repeat-rows.md) - [Repeat columns](https://xlswriter-docs.viest.me/english/page-setup/repeat-columns.md) - [Print area](https://xlswriter-docs.viest.me/english/page-setup/print-area.md) - [Page breaks](https://xlswriter-docs.viest.me/english/page-setup/page-breaks.md) - [Fit to pages](https://xlswriter-docs.viest.me/english/page-setup/fit-to-pages.md) - [Workbook properties](https://xlswriter-docs.viest.me/english/properties.md) - [Standard properties](https://xlswriter-docs.viest.me/english/properties/standard.md) - [Custom properties](https://xlswriter-docs.viest.me/english/properties/custom.md) - [Defined names](https://xlswriter-docs.viest.me/english/defined-names.md) - [Sheet protection](https://xlswriter-docs.viest.me/english/protection.md) - [Password protect](https://xlswriter-docs.viest.me/english/protection/password.md) - [Unlock cells](https://xlswriter-docs.viest.me/english/protection/unlock.md) - [Reader](https://xlswriter-docs.viest.me/english/reader.md) - [Worksheet list](https://xlswriter-docs.viest.me/english/reader/sheet_list.md) - [Worksheet list with metadata](https://xlswriter-docs.viest.me/english/reader/sheet-list-with-meta.md) - [Read file (full)](https://xlswriter-docs.viest.me/english/reader/read-file-full.md) - [Read file (cursor)](https://xlswriter-docs.viest.me/english/reader/read-file-cursor.md) - [Skip leading rows](https://xlswriter-docs.viest.me/english/reader/skip-rows.md) - [Skip empty cells](https://xlswriter-docs.viest.me/english/reader/skip-empty-cells.md) - [Skip empty rows](https://xlswriter-docs.viest.me/english/reader/skip-empty-row.md) - [Skip mode constants](https://xlswriter-docs.viest.me/english/reader/skip-const.md) - [Set global type](https://xlswriter-docs.viest.me/english/reader/set-type.md) - [Cell callback mode](https://xlswriter-docs.viest.me/english/reader/cell_callback.md) - [Read by data type](https://xlswriter-docs.viest.me/english/reader/data-type.md) - [Data type constants](https://xlswriter-docs.viest.me/english/reader/data-type-const.md) - [Next row with formula](https://xlswriter-docs.viest.me/english/reader/next-row-with-formula.md) - [Next row with rich text](https://xlswriter-docs.viest.me/english/reader/next-row-rich.md) - [Read style format](https://xlswriter-docs.viest.me/english/reader/get-style-format.md) - [Get merged cells](https://xlswriter-docs.viest.me/english/reader/get-merged-cells.md) - [Get hyperlinks](https://xlswriter-docs.viest.me/english/reader/get-hyperlinks.md) - [Get sheet protection](https://xlswriter-docs.viest.me/english/reader/get-sheet-protection.md) - [Get row / column options](https://xlswriter-docs.viest.me/english/reader/row-column-options.md) - [Get conditional formats](https://xlswriter-docs.viest.me/english/reader/get-conditional-formats.md) - [Get data validations](https://xlswriter-docs.viest.me/english/reader/get-data-validations.md) - [Get auto filter](https://xlswriter-docs.viest.me/english/reader/get-auto-filter.md) - [Get defined names](https://xlswriter-docs.viest.me/english/reader/get-defined-names.md) - [Get page setup](https://xlswriter-docs.viest.me/english/reader/get-page-setup.md) - [Get formula AST](https://xlswriter-docs.viest.me/english/reader/get-formula-ast.md) - [Iterate images](https://xlswriter-docs.viest.me/english/reader/iterate-images.md) - [Iterate comments](https://xlswriter-docs.viest.me/english/reader/iterate-comments.md) - [Iterate charts](https://xlswriter-docs.viest.me/english/reader/iterate-charts.md) - [CSV](https://xlswriter-docs.viest.me/english/csv.md) - [XLSX to CSV - normal mode](https://xlswriter-docs.viest.me/english/csv/put-csv.md) - [XLSX to CSV - callback mode](https://xlswriter-docs.viest.me/english/csv/put-csv-callback.md) - [Helper](https://xlswriter-docs.viest.me/english/helper.md) - [Column index transform](https://xlswriter-docs.viest.me/english/helper/column-index-number-string-transform.md) - [Excel serial date to timestamp](https://xlswriter-docs.viest.me/english/helper/timestamp-from-date.md) - [Get version](https://xlswriter-docs.viest.me/english/helper/get_version.md) - [Get author](https://xlswriter-docs.viest.me/english/helper/get_author.md) - [Download](https://xlswriter-docs.viest.me/english/download.md) - [Project recommendation](https://xlswriter-docs.viest.me/english/en-1.md)