Widgets

Excel-Like Experience

Bring Excel or Google Sheet-like experiences to your web apps without a single line of code. Organize data with built-in functionalities such as formulas, filtering, sorting, scrolling and frozen panes. Load/save data from JSON via API methods, or enable export to Excel on the client.
Formulas
Take advantage of a wide range of formulas, from standard numeric such as sum, count, min, max, average to advanced math, statistical, date or text formulas for custom calculations. They are supported out-of-the-box, so you only need to use the function row from the UI to define the formula.
Sorting and Filtering

Organize and search data easily using the built-in sorting feature of the PHP Spreadsheet. Sort values in the Spreadsheet globally or sort a selected range of column values and get a better understanding of data spanning across multiple rows and columns.

The intuitive filtering functionality of the PHP Spreadsheet enables you to add flexibility to your data. Display and focus on the data that you need at any given moment, without breaking its initial structure and content.
Theming
The widget comes with a set of dozen built-in themes, designed with the latest modern UX standards in mind. In addition, you can customize any of the provided themes using our Theme Builder online tool.
Performance

There is virtually no limitations on the number of cells in a sheet, providing your app unmatched performance--even with thousands of cells.
Cross-Browser Support
When using PHP Spreadsheet in your apps, you can rest assured that it behaves as expected and has a consistent look and feel in all browsers your users may be using.