<?php
<?php
$config = ['path' => './'];
$excel = new \Vtiful\Kernel\Excel($config);
$fileObject = $excel->fileName("tutorial01.xlsx");
$fileHandle = $fileObject->getHandle();
$fileObject->header(['姓名', '电话', '身份证'])
->setColumn('A:A', 20, $textFormat)
->setColumn('B:B', 20, $textFormat);
$content = [];
for ($i = 1; $i <= 1000; $i++) {
$temp_data = [
'张三' . mt_rand(100, 999),
strval('1' . mt_rand(100, 999) . mt_rand(100, 999) . mt_rand(1000, 9999)),
'1101011990030' . mt_rand(10000, 99999)
];
$content[] = $temp_data;
}
for($ii = 0; $ii < sizeof($content); $ii ++){
for($tt = 0; $tt < sizeof($content[$ii]); $tt ++){
$fileObject->insertText($ii, $tt, strval($content[$ii][$tt]), '@');
}
}
$fileObject->output();
?>
?>