# phpxlsx

> phpxlsx is a PHP library for generating, modifying, and transforming Excel spreadsheets programmatically.

## Summary
phpxlsx is a PHP library that allows developers to dynamically generate, modify, and transform Excel spreadsheets. Key capabilities include creating new spredsheets template-based generation, HTML/CSS to XLSX conversion, advanced formula handling, charts, tables, document transformation utilities, watermarking, password encryption, cryptographic digital signing, and many other features.

## Key Concepts
- Generate Excel XLSX spreadsheets from PHP
- Create spreadsheets using templates
- Replace variables inside XLSX templates
- HTML and CSS to XLSX conversion
- Insert images, charts, tables, and media objects
- Automated report generation
- Get information
- Merge and unmerge cells
- Convert spreadsheets to other formats
- Math equations (OMML and MathML)
- Formula support
- JavaScript API
- Watermarks (text and image overlays)
- Encrypt and sign (password protection and digital signatures)

## Core Features
- [Features](https://www.phpxlsx.com/features): Overview of library capabilities

## Documentation
- [Documentation](https://www.phpxlsx.com/documentation): Main documentation hub
- [Introduction](https://www.phpxlsx.com/documentation/introduction): Introduction and overview
- [Practical guide](https://www.phpxlsx.com/documentation/practical): Practical guides and tutorials
- [Installation](https://www.phpxlsx.com/documentation/practical/installation): Installation instructions
- [API reference](https://www.phpxlsx.com/documentation/api-documentation): API reference
- [Cookbook](https://www.phpxlsx.com/documentation/cookbook): Task-oriented examples and integration
- [Snippets](https://www.phpxlsx.com/documentation/snippets): Code snippets

## Product Information
- [FAQ](https://www.phpxlsx.com/faqs): Frequently asked questions
- [Pricing](https://www.phpxlsx.com/pricing): Licensing tiers and product editions
- [News](https://www.phpxlsx.com/news): Product updates and announcements

### Example: Create a Spreadsheet
$xlsx = new CreateXlsx();

$content = [
    'text' => 'Cell content',
];
$xlsx->addCell($content, 'A1');

$xlsx->saveXlsx('example.xlsx');

### Example: Create a Spreadsheet from a template
$xlsx = new CreateXlsxFromTemplate('template.xlsx');

// replace variables
$xlsx->replaceVariableText(['VAR' => 'phpxlsx']);

$xlsx->saveXlsx('example.xlsx');