Download the PHP package davidannebicque/html-to-spreadsheet-bundle without Composer

On this page you can find all versions of the php package davidannebicque/html-to-spreadsheet-bundle. 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?

Example code of davidannebicque/html-to-spreadsheet-bundle

Informations about the package html-to-spreadsheet-bundle

HtmlToSpreadsheetBundle

Latest Version Symfony PhpSpreadsheet

Warning

First draft of a Symfony bundle to convert HTML tables into Excel (.xlsx), OpenDocument (.ods) or CSV. WIP.

Convert annotated HTML tables into Excel (.xlsx), OpenDocument (.ods) or CSV using a simple, declarative syntax.

This bundle is ideal for developers who want to use Twig + HTML as a DSL to build spreadsheets, without directly using the PhpSpreadsheet API.

Requirements

Features

Cell Styling Attributes

Background & Font

Borders

Cell Protection

Example

Cell Merging

Merge cells horizontally (colspan) or vertically (rowspan), or both simultaneously.

Attributes

Examples

Horizontal Merging (Colspan):

Vertical Merging (Rowspan):

Combined Merging:

Complex Table Example:

Combining with Styling

Merged cells can be styled like any other cell:

Font Styling

Control font appearance with these attributes:

Font Color & Weight

Font Decoration & Family

Example

Conditional Formatting

Apply dynamic formatting based on cell values using a simple syntax:

Syntax: data-xls-conditional="condition|style1|style2..."

Available Conditions

Available Styles

Examples

Auto-size Columns

Automatically adjust column widths to fit content. This feature uses PhpSpreadsheet's auto-sizing capability to calculate optimal column widths based on cell content.

Attributes

Table-level:

Column-level (in <colgroup>):

Examples

Auto-size all columns:

Auto-size specific columns:

Auto-size columns by range:

Column-level auto-size with colgroup: html

Important data

html <td data-xls-comment="Please verify this value" data-xls-comment-author="John Doe"> 1,234.56 html <td data-xls-comment="This is a longer comment that requires more space to display properly" data-xls-comment-width="300" data-xls-comment-height="100"> Complex data html <td data-xls-comment="IMPORTANT: Read this first" data-xls-comment-visible="true"> Critical value html

html

<td data-xls-image="/path/to/image.png" data-xls-img-width="100" data-xls-img-height="50">

html

Visit our website GitHub Repository

html

Go to Sheet2, cell A1 Jump to B10 Link to "My Data" sheet

html

Send email Contact Support

html <td data-xls-link="https://symfony.com/doc" data-xls-link-tooltip="Click to view Symfony documentation"> Symfony Docs html <td data-xls-link="https://example.com" data-xls-bg-color="#FFFFCC" data-xls-font-bold="true" data-xls-link-tooltip="Important link"> Highlighted Link bash composer require davidannebicque/html-to-spreadsheet-bundle yaml html_to_spreadsheet: strict: true include_builtins: true yaml html_to_spreadsheet: default_styles: mon_style: font: bold: true color: 'FF0000' alignment: horizontal: 'center' twig {# templates/test/export.html.twig #}

{# --- Feuille 1 --- #} {% for l in lignes %} {# Date formatée #} {# Montant format monétaire #} {% endfor %} {# Total via formule #}
Nom Prénom Date Montant (€)
{{ l.nom }} {{ l.prenom }} {{ l.date|date('Y-m-d') }} {{ l.montant }}
Total :
{# --- Feuille 2 --- #} {% for l in lignes %} {% endfor %}
# Nom Prénom Date brute Montant brut
{{ loop.index }} {{ l.nom }} {{ l.prenom }} {{ l.date|date('Y-m-d H:i') }} {{ l.montant }}

All versions of html-to-spreadsheet-bundle with dependencies

PHP Build Version
Package Version
Requires phpoffice/phpspreadsheet Version ^4.0 || ^5.0
symfony/dependency-injection Version ^6.4 || ^7.0 || ^8.0
symfony/framework-bundle Version ^6.4 || ^7.0 || ^8.0
symfony/config Version ^6.4 || ^7.0 || ^8.0
symfony/http-foundation Version ^6.4 || ^7.0 || ^8.0
symfony/console Version ^6.4 || ^7.0 || ^8.0
symfony/twig-bundle Version ^6.4 || ^7.0 || ^8.0
ext-dom Version *
ext-libxml Version *
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 davidannebicque/html-to-spreadsheet-bundle contains the following files

Loading the files please wait ...