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