Features
Browse every supported MNB PHPExcel capability in a clean, searchable list.
Updated
What you will learn
- Find the tutorial that owns a specific capability.
- Understand the common application use case for each feature.
- Filter capabilities by reading, imports, security, writing, or workflows.
Read spreadsheet data
Generate downloadable Excel files
Access all worksheets
Load only one worksheet
Get individual cell data
Iterate through records
Get Excel formulas
Return formula results
Font, color, borders
Extract embedded images
Import URLs
Extract cell comments
Detect merged ranges
Include or exclude hidden data
Convert Excel dates
Preserve formatting
Required fields and formats
Ignore blank rows
Compare before insert
Insert thousands of rows
Match by ID
Employee or customer upload
SKU and pricing
Sales records
Stock management
School management
Employee or student attendance
Exam results
CRM import
GPS or city data
CMS migration
Media library values
Product hierarchy
Open secured XLSX files
Stream reading
Show upload progress
Row-level errors
Import history
Show first few rows
Map Excel columns to database fields
Identify column names
Read and write CSV files
Read tab-separated files
Create import templates
Improve export readability
Colors, fonts and borders
Generate charts
Add a company logo
Improve worksheet usability
Add worksheet filters
Highlight values
Analyze data
Encrypt and protect reports
Import many Excel files
Background imports
Upload without page reload
Receive Excel through an API
Send report attachments
Run cron-based imports
Generate daily reports
Convert and normalize values
Detect and convert encodings
Support all languages