# PhpSpreadsheet

## Docs

- [AutoFilters](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/advanced/autofilters.md): Apply and configure autofilters to filter data in Excel worksheets with PhpSpreadsheet
- [Calculation Engine](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/advanced/calculation-engine.md): Learn how PhpSpreadsheet evaluates formulas, handles calculation caching, and works with date/time values
- [Charts](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/advanced/charts.md): Create and embed charts in Excel worksheets using PhpSpreadsheet
- [Cell Comments and Notes](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/advanced/comments.md): Add comments and notes to cells in Excel worksheets with PhpSpreadsheet
- [Images and Drawings](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/advanced/images.md): Add images, drawings, and graphics to Excel worksheets with PhpSpreadsheet
- [Excel Tables](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/advanced/tables.md): Create and manage Excel tables with structured data, filters, and formatting
- [Alignment Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/alignment.md): Complete API reference for the PhpSpreadsheet Alignment styling class
- [Borders and Border Classes](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/borders.md): Complete API reference for PhpSpreadsheet Borders and Border styling classes
- [Calculation Engine](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/calculation/engine.md): API reference for the PhpSpreadsheet Calculation Engine
- [Function Reference](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/calculation/function-reference.md): Complete list of supported Excel functions in PhpSpreadsheet
- [Function Categories](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/calculation/functions.md): Overview of PhpSpreadsheet calculation functions and categories
- [Cell Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/cell.md): Class for managing individual cells and their values
- [Chart](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/chart.md): API reference for creating and managing charts in PhpSpreadsheet
- [Comment](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/comment.md): API reference for adding cell comments in PhpSpreadsheet
- [Drawing](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/drawing.md): API reference for adding images and drawings to worksheets
- [Fill Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/fill.md): Complete API reference for the PhpSpreadsheet Fill styling class
- [Font Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/font.md): Complete API reference for the PhpSpreadsheet Font styling class
- [IOFactory Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/iofactory.md): Factory class for reading and writing spreadsheet files
- [NumberFormat Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/number-format.md): Complete API reference for the PhpSpreadsheet NumberFormat styling class
- [Csv Reader](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/readers/csv.md): API reference for the PhpSpreadsheet Csv reader class for reading comma-separated values (.csv) files
- [Html Reader](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/readers/html.md): API reference for the PhpSpreadsheet Html reader class for reading HTML table files
- [Ods Reader](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/readers/ods.md): API reference for the PhpSpreadsheet Ods reader class for reading OpenDocument Spreadsheet (.ods) files
- [Readers Overview](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/readers/overview.md): Overview of PhpSpreadsheet readers, IReader interface, and common patterns for loading spreadsheet files
- [Xls Reader](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/readers/xls.md): API reference for the PhpSpreadsheet Xls reader class for reading Excel 97-2003 (.xls) files
- [Xlsx Reader](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/readers/xlsx.md): API reference for the PhpSpreadsheet Xlsx reader class for reading Excel 2007+ (.xlsx) files
- [Spreadsheet Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/spreadsheet.md): Main class for creating and managing spreadsheet workbooks
- [Style Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/style.md): Complete API reference for the PhpSpreadsheet Style class
- [Worksheet Class](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/worksheet.md): Class for managing individual worksheets within a spreadsheet
- [Csv Writer](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/writers/csv.md): Comma-Separated Values writer class reference
- [Html Writer](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/writers/html.md): HTML table format writer class reference
- [Ods Writer](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/writers/ods.md): OpenDocument Spreadsheet writer class reference
- [Writers Overview](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/writers/overview.md): Overview of PhpSpreadsheet writer classes and the IWriter interface
- [Pdf Writers](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/writers/pdf.md): PDF writer classes reference (Dompdf, Mpdf, Tcpdf)
- [Xls Writer](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/writers/xls.md): Excel 97-2003 (BIFF) writer class reference
- [Xlsx Writer](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/api/writers/xlsx.md): Excel 2007+ (Office Open XML) writer class reference
- [Architecture](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/concepts/architecture.md): Understanding how PhpSpreadsheet works internally - the in-memory model, readers/writers architecture, and design principles
- [Cells and Ranges](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/concepts/cells-and-ranges.md): Understanding cell references, coordinate systems, ranges, and iterating through cells in PhpSpreadsheet
- [File Formats](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/concepts/file-formats.md): Supported spreadsheet file formats, their capabilities, and format-specific considerations in PhpSpreadsheet
- [Spreadsheets and Worksheets](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/concepts/spreadsheets-and-worksheets.md): Working with the Spreadsheet and Worksheet classes - creating workbooks, managing multiple sheets, and performing sheet operations
- [Accessing Cells](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/data/accessing-cells.md): Getting and setting cell values, coordinate systems, and cell iterators in PhpSpreadsheet
- [Cell Values and Data Types](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/data/cell-values.md): Understanding data types, value binders, and type conversion in PhpSpreadsheet
- [Data Validation](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/data/data-validation.md): Setting up data validation rules, dropdown lists, and input restrictions in PhpSpreadsheet
- [Defined Names](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/data/defined-names.md): Named ranges and named formulas for readable, maintainable spreadsheets
- [Working with Formulas](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/data/formulas.md): Formula syntax, calculation engine, and formula evaluation in PhpSpreadsheet
- [AutoFilter Examples](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/autofilter.md): Learn how to set up and use AutoFilters for data filtering in Excel
- [Chart Examples](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/charts.md): Learn how to create various chart types including line, column, pie, and more
- [Creating Spreadsheets](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/creating-spreadsheet.md): Learn how to create new spreadsheets with multiple sheets and data
- [Data Validation Examples](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/data-validation.md): Learn how to create data validation rules to control user input in Excel cells
- [Formula Examples](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/formulas.md): Learn how to use formulas and the calculation engine in PhpSpreadsheet
- [Hello World](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/hello-world.md): Create your first spreadsheet with PhpSpreadsheet
- [Modifying Cells](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/modifying-cells.md): Learn how to set cell values, formulas, and properties
- [Reading Spreadsheets](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/reading-spreadsheet.md): Learn how to read and load existing spreadsheet files
- [Styling Examples](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/examples/styling.md): Learn how to apply styles, colors, borders, and fonts to cells in PhpSpreadsheet
- [Conditional Formatting](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/formatting/conditional-formatting.md): Apply dynamic formatting based on cell values and conditions
- [Number Formats](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/formatting/number-formats.md): Apply number format masks, date formats, and custom formats to cells
- [Cell Styles](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/formatting/styles.md): Apply fonts, colors, fills, borders, and alignment to cells
- [Document Themes](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/formatting/themes.md): Work with Excel document themes for consistent styling
- [Installation](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/installation.md): Install PhpSpreadsheet via Composer and configure system requirements
- [Introduction](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/introduction.md): Overview of PhpSpreadsheet, a PHP library for reading and writing spreadsheet files
- [Migrating from PHPExcel](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/migration/from-phpexcel.md): Complete guide to migrating your codebase from PHPExcel to PhpSpreadsheet
- [Version Upgrade Guide](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/migration/version-upgrades.md): Breaking changes and upgrade instructions for PhpSpreadsheet major versions
- [Cell Caching Strategies](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/performance/caching.md): Advanced cell caching configuration and strategies for optimal performance with PhpSpreadsheet
- [Memory Optimization](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/performance/memory-optimization.md): Learn how to reduce memory usage when working with large spreadsheets using cell caching and PSR-16 implementations
- [Read Filters](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/performance/read-filters.md): Use read filters to load only specific cells, rows, or columns from spreadsheets to dramatically reduce memory usage and improve performance
- [Quick start](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/quickstart.md): Create your first spreadsheet with PhpSpreadsheet in minutes
- [Exporting to PDF](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/reading-writing/pdf-export.md): Learn how to export spreadsheets to PDF format using Dompdf, Mpdf, or TCPDF
- [Spreadsheet Readers](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/reading-writing/readers.md): Complete reference of available readers and their specific features and options
- [Reading Spreadsheet Files](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/reading-writing/reading-files.md): Learn how to read and load spreadsheet files using PhpSpreadsheet's IOFactory and reader classes
- [Spreadsheet Writers](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/reading-writing/writers.md): Complete reference of available writers and their format-specific options
- [Writing Spreadsheet Files](https://mintlify.wiki/PHPOffice/PhpSpreadsheet/reading-writing/writing-files.md): Learn how to save and export spreadsheets in various formats using PhpSpreadsheet writers