-
- require_once 'Pman/Core/SimpleExcel.php';
- $x = new Pman_Core_SimpleExcel(
- array($bt,$et, $ut), array(
- 'formats' => array(
- 'vtop' => array('vAlign' => 'top'),
- 'vcenter' => array('vAlign' => 'vcenter'),
-
- 'percent' => array('vAlign' => 'vcenter', 'numFormat' => '0%'),
- 'money' => array('vAlign' => 'vcenter', 'numFormat' => '$#,###'),
- 'date' => array('vAlign' => 'vcenter', 'numFormat' => 'd/M/Y'),
- ),
- 'workbooks' => array(
- array(
- 'workbook' => 'Business',
- 'cols' => explode('|', 'keyIdentity_taxId|description|type|countryIso3|countryRegion|addr1|addr2|addr3|city|zip')
- ),
- array(
- 'workbook' => 'Employment',
- 'cols' => explode('|', 'emailAddress|identity_taxId')
- ),
- array(
- 'workbook' => 'Users',
- 'cols' => explode('|', 'generateLogin|firstName|middleName|lastName|emailAddress|locale|countryIso3|countryRegion|addr1|addr2|addr3|city|zip|userStatus')
- ),
- )
-
- ));
- $x->send('test_'. date('d_M_Y').'.xls');