[ "a", "b" ]
[],
[ "A", "B" ]
+ [ "a", ["test", "left"] ] << sub array [text, formatname]
],
* cols : array(
array(
{
// print_r($cfg);
require_once 'Spreadsheet/Excel/Writer.php';
- $pman = new Pman();
// Creating a workbook
- $outfile2 = $pman->tempName('xls');
+ $outfile2 = $this->tempName('xls');
// var_dump($outfile2);
$workbook = new Spreadsheet_Excel_Writer($outfile2);
//$workbook = new Spreadsheet_Excel_Writer();
}
- function buildpage($data,$cfg)
+
+ static function date($str)
{
+ return (strtotime($str . ' UTC') + (86400 * 25569)) / 86400;
+
+ }
+
+
+ function buildpage($workbook, $formats , $data,$cfg)
+ {
+ //echo '<PRE>'; print_R($cfg);
// Creating a worksheet
$worksheet = $workbook->addWorksheet($cfg['workbook']);
+ if (is_a($worksheet, 'PEAR_Error')) {
+ die($worksheet->toString());
+ }
+ //print_R($worksheet);
$worksheet->setInputEncoding('UTF-8');
if (!empty($cfg['head'])) {
foreach($cfg['head'] as $row) {
foreach($row as $c => $col) {
+ if (is_array($col)) {
+ $format = isset($formats[$col[1]] ) ? $formats[$col[1]] : false;
+ $worksheet->write($start_row, $c, $col[0], $format);
+ continue;
+ }
+
$worksheet->write($start_row, $c, $col);
}
-
-
+ foreach($cfg['cols'] as $c=>$col_cfg) {
+ if (is_string($col_cfg)) {
+ $cfg['cols'][$c] = array(
+ 'header' => $col_cfg,
+ 'dataIndex' => $col_cfg,
+ 'width' => 50,
+
+ );
+ }
+ }
foreach($cfg['cols'] as $c=>$col_cfg) {
+
+
+
$worksheet->write($start_row, $c, $col_cfg['header']);
$worksheet->setColumn ( $c, $c, $col_cfg['width'] / 5);
foreach($cfg['foot'] as $row) {
foreach($row as $c => $col) {
// if it's an array? - formated ???
+ if (is_array($col)) {
+ $format = isset($formats[$col[1]] ) ? $formats[$col[1]] : false;
+ $worksheet->write($start_row, $c, $col[0], $format);
+ continue;
+ }
$worksheet->write($start_row, $c, $col);
}
}
-
-
function send($fn)
{
-
-
-
require_once 'File/Convert.php';
$fc= new File_Convert($this->outfile2, "application/vnd.ms-excel");
$fn = $fc->convert("application/vnd.ms-excel");