本文整理匯總了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);
}