# 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) --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://xlswriter-docs.viest.me/english.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.