PHPackages                             nimmneun/onesheet - PHPackages - PHPackages  [Skip to content](#main-content)[PHPackages](/)[Directory](/)[Categories](/categories)[Trending](/trending)[Leaderboard](/leaderboard)[Changelog](/changelog)[Analyze](/analyze)[Collections](/collections)[Log in](/login)[Sign up](/register)

1. [Directory](/)
2. /
3. [PDF & Document Generation](/categories/documents)
4. /
5. nimmneun/onesheet

ActiveLibrary[PDF & Document Generation](/categories/documents)

nimmneun/onesheet
=================

OneSheet is a fast and lightweight single/multi sheet excel/xlsx file writer for PHP 5.4+ (until v1.2.6), PHP 7 & PHP 8 with styling and cell auto-sizing support.

1.3.1(3mo ago)46403.8k—6.8%82MITPHPPHP >=7.1.0CI passing

Since Jul 8Pushed 3mo ago8 watchersCompare

[ Source](https://github.com/nimmneun/onesheet)[ Packagist](https://packagist.org/packages/nimmneun/onesheet)[ Docs](https://github.com/nimmneun/onesheet)[ RSS](/packages/nimmneun-onesheet/feed)WikiDiscussions master Synced 1mo ago

READMEChangelog (10)Dependencies (1)Versions (52)Used By (2)

OneSheet
========

[](#onesheet)

[![Build Status](https://camo.githubusercontent.com/f6bfe88085b2ce2411e15c7c28813da0d3c84fce97421d2c029d3df2a5f861e0/68747470733a2f2f7472617669732d63692e6f72672f6e696d6d6e65756e2f6f6e6573686565742e7376673f6272616e63683d6d6173746572)](https://travis-ci.org/nimmneun/onesheet)[![Scrutinizer Code Quality](https://camo.githubusercontent.com/84255aaebf0a5f5bf36aead160917a7887e12da3b720be222be8a5366fd71d55/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f6e696d6d6e65756e2f6f6e6573686565742f6261646765732f7175616c6974792d73636f72652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/nimmneun/onesheet/?branch=master)[![Code Coverage](https://camo.githubusercontent.com/fe28a032a7b51126a5ce15151e46ae908342e9f5a1f8467af0bd0a4645673984/68747470733a2f2f7363727574696e697a65722d63692e636f6d2f672f6e696d6d6e65756e2f6f6e6573686565742f6261646765732f636f7665726167652e706e673f623d6d6173746572)](https://scrutinizer-ci.com/g/nimmneun/onesheet/?branch=master)[![Downloads](https://camo.githubusercontent.com/30b21d12ed633c0d513923980c11ca395e50cfaa673fa25353de04a7881986f8/68747470733a2f2f696d672e736869656c64732e696f2f7061636b61676973742f646d2f6e696d6d6e65756e2f6f6e657368656574)](https://img.shields.io/packagist/dm/nimmneun/onesheet)

OneSheet is a simple **single/multi sheet** excel/xlsx file writer for PHP 5 (until v1.2.6), PHP 7 & PHP 8 with cell auto-sizing and styling support.

[![alt text](autosizing_excel_screencap.png "OneSheet excel output example")](autosizing_excel_screencap.png)

### What it does

[](#what-it-does)

- Write a single/multiple spreadsheet(s) fast and with a small memory footprint.
- Freeze the first \[n\] rows to have a fixed table header/headline per sheet.
- Use different fonts, styles, borders and background colors on a row level.
- Set your own custom column width per column.
- Autosize column widths to fit cell contents. If no fonts are found, rough estimates are used.
- Define minimum and maximum column widths to keep exceptionally large or small cell contents in check.

### What it doesn't

[](#what-it-doesnt)

- No cell individualisation, everything is applied at a row level.
- No calculated / formula cells.
- No conditional formatting.
- No number formats.
- No charts.

### Install via composer

[](#install-via-composer)

```
$ composer require nimmneun/onesheet

```

### Manual installation

[](#manual-installation)

If you can't or don't want to use composer for some reason, [download](https://github.com/nimmneun/onesheet/releases/latest) & extract onsheet and require the file autoload.php from the releases root folder.

```