Download the PHP package fastbolt/excel-writer without Composer

On this page you can find all versions of the php package fastbolt/excel-writer. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:
If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.
Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

  • Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
  • To use Composer is sometimes complicated. Especially for beginners.
  • Composer needs much resources. Sometimes they are not available on a simple webspace.
  • If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
  • Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.
Please rate this library. Is it a good library?

Informations about the package excel-writer

Excel-Writer

This component is used for simple Excel-file generation in Symfony. You can pass either arrays of arrays, or arrays of entities to the generator class. If an entity references another entity as it's attribute, you will need to pass a callable to retrieve a specific value from that entity.

Installation

This package is available through Composer/Packagist:


Table size

The width of the table is set by the number of headers. The number of rows is set by the amount of data.

Columns

The order of columns is determined by the order of ColumnSetting instances given to ExcelGenerator::setColumns(). You need to define at least one column. The order of the content will not be changed if an array is passed to setContent().

If you are passing objects to setContent(), you will need to provide the name of the method that returns the values you want to display (like "getName").

You can also pass closures instead of the getter.

Style

Create an instance of the TableStyle class and set styles for the header row and the content. Pass the TableStyle to the generator.

To apply styles to individual columns, you can either pass the style arrays as the 5th (header style) and 6th (data style) argument to the constructor, or use the setter of the ColumnSettings class.

Autofilter

Autofilters can be set by calling the generator's setter method and passing a range:

Style presets

The following styles are presets, but can be overwritten in the TableStyle class

header

Merging Cells

You can merge cells by passing an array of coordinate ranges to the generator 'mergeCells'-method. The content of the resulting cell will be centered. Calling the method multiple times will not overwrite previous merges.

Hints

Example usage

Using arrays

Using objects

Multiple worksheets

Full example using objects and adding style

e x c e l - w r i t e r


All versions of excel-writer with dependencies

PHP Build Version
Package Version
Requires php Version ^8.2
phpoffice/phpspreadsheet Version ^2.1
Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package fastbolt/excel-writer contains the following files

Loading the files please wait ....