Skip to content

Appearance

Sidebar Navigation

Why use xlswriter

Overview

Install

Env requirements

PECL (recommend)

Mac

Alpine

Ubuntu

Windows

Docker multi-stage build

Quick start

Create file

Read file

Close manually

Cell

Insert text

Insert link

Insert formula

Insert date

Insert local image

Insert rich text

Insert comment

Auto filter

Freeze panes

Merge cells

Row cell style

Column cell style

Worksheet

Create worksheet

Switch worksheet

Check worksheet existence

Gridlines

Zoom

Hide current worksheet

Set as first worksheet

Tab color

Background image

Memory model

Fixed memory mode

Style

Combination style

Global default style

Style list

Italic

Align

Strikethrough

Underline

Text wrap

Font color

Font size

Rich text

Bold

Cell border

Border of the four sides

Border color

Border style constants

Background color

Color constants

Font

Number format

Rotation

Indent

Cell protection

Chart

Chart type constants

Data input

Doughnut chart

Area chart

Histogram chart

Bar chart

Conditional format

Single cell rule

Range rule

Data bar

Icon set

Multi range

Type constants

Criteria constants

Data validation

Drop-down list

Range constraint

Greater than constraint

Validation API reference

Excel table

Columns

Style

Options

Page setup

Paper size

Margins

Orientation

Print scale

Landscape

Portrait

Header and footer

Repeat rows

Repeat columns

Print area

Page breaks

Fit to pages

Workbook properties

Standard properties

Custom properties

Defined names

Sheet protection

Password protect

Unlock cells

Reader

Worksheet list

Worksheet list with metadata

Read file (full)

Read file (cursor)

Skip rows

Skip empty cells

Skip empty rows

Skip constants

Set global type

Cell callback mode

Read by data type

Data type constants

Next row with formula

Next row with rich text

Read style format

Get merged cells

Get hyperlinks

Get sheet protection

Get row / column options

Get conditional formats

Get data validations

Get auto filter

Get defined names

Get page setup

Get formula AST

Iterate images

Iterate comments

Iterate charts

CSV

XLSX to CSV - normal mode

XLSX to CSV - callback mode

Helper

Column index transform

Set current line

Get current line

Get version

Get author

Exceptions

Exception codes

FAQ

Download

Project recommendation

On this page

PECL（recommended）

bash

pecl install xlswriter

# Add extension = xlswriter.so to ini configuration

Edit this page on GitHub

Last updated:

Pager

Previous pageEnv requirements