本文整理汇总了PHP中PSU::xlsx方法的典型用法代码示例。如果您正苦于以下问题:PHP PSU::xlsx方法的具体用法?PHP PSU::xlsx怎么用?PHP PSU::xlsx使用的例子?那么, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类PSU
的用法示例。
在下文中一共展示了PSU::xlsx方法的1个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的PHP代码示例。
示例1: xlsx
/**
* renders an xlsx version of the report
*/
public function xlsx()
{
$meta = array();
$meta['creator'] = $_SESSION['username'] . ' using PSU Analytics';
$meta['last_modified_by'] = $_SESSION['username'] . ' using PSU Analytics';
$meta['title'] = $this->name;
$meta['subject'] = $this->name;
$meta['description'] = $this->name . ', generated using PSU Analytics.';
$meta['keywords'] = $this->id . ' office 2007 openxml php psuanalytics ' . $_SESSION['username'];
$meta['category'] = 'PSU Analytics';
$meta['file_name'] = $this->id;
$meta['types'] = array();
if (!isset($this->sql)) {
$meta['headings'] = array_keys($this->data[0]);
$data = $this->data;
} else {
$meta['headings'] = array_keys($this->sql->cols);
foreach ($this->sql->cols as $key => $field) {
// in theory we can/should check more types, but even this simple check is WAYYYYY better than csv
$meta['types'][$key] = $field->type == 'VARCHAR2' || $field->type == 'VARCHAR' ? 'string' : '';
}
// end foreach
$data = $this->sql->data;
}
// end else
PSU::xlsx($data, $meta);
}