jambagecom/excelbill-tt-products

Send an Excel generated bill for orders with tt_products

v0.2.0 2022-01-22 12:49 UTC

Requires

• jambagecom/div2007: ^1.11
• typo3/cms-core: ^9.5 || ^10.4 || ^11.5

Replaces

• typo3-ter/excelbill-tt-products: v0.2.0

GPL-2.0-or-later

• excel
• TYPO3 CMS
• tt_products

README

The TYPO3 extension excelbill_tt_products has the purpose to enable the generation of a bill in an Excel format.

Put this into the Setup:

Generate bill:

plugin.tt_products {
  bill {
     generation = auto
     type = excel
     handleLib = PhpSpreadsheet
     handleLib {
        template = fileadmin/templates/excel_template.xls
     }
     conf {
        path = fileadmin/data/bill
     }
  }
  orderEmail {
     10002.attachment = bill
  }
}

Use the setup bill.conf to overwrite the charset and the standard configuration attributes of TCPDF. This extension contains a HTML template file which you can move into the fileadmin folder if you want to adapt it to your needs.

plugin.tt_products {
  bill.conf {
     templateFile = fileadmin/templates/excel_template.xls
  }
}

PhpSpreadsheet Library:

Use the Extension Manager to set the relative library path to PhpSpreadsheet, where the TYPO3 home directory is the starting point.

libraryPath = src/PhpSpreadsheet

If you have installed the extension base_excel, then you must use this configuration:

libraryPath = typo3conf/ext/base_excel/Vendor/PhpSpreadsheet/src/PhpSpreadsheet/

Contributors:

Excel icons