- 博客(4)
- 资源 (5)
- 问答 (2)
- 收藏
- 关注
RSS订阅原创 开机启动虚拟机和Apache
开机启动虚拟机方法新建一个不宜删除的目录，将以下内容保存正.bat文件，并新建快捷方式到桌面E:cd vagrant-boxvagrant up打开C:\Users\你的用户名\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Startup 然后将快捷方式放进去 下次启动windows后会出现，不要关闭，接下来会自动启动...
2019-02-22 15:03:25
283
转载 dreamweaver中用正则表达式查找替换批量删除 tppabs标签的方法
dreamweaver中用正则表达式查找替换批量删除 tppabs标签的方法 一步到位查找替换正则表达式 \btppabs="h[^"]*"后面不能有空格 你懂得的选中右下角的 √【使用正则表达式】替换全部唰 一下子
2015-06-11 14:49:30
465
PHPExecl.tar.gz
亲测没有问题,使用方法(*输出Excel之前,不可以有echo,var_dump()等,否则报错*)
1,首先引入
2,$objPHPExcel = new PHPExcel();$objPHPExcelWrite = new PHPExcel();
3,读:
$filename = "/www/htdocs/invlist.xlsx";
$objReader = PHPExcel_IOFactory::createReaderForFile($filename);
$objPHPExcel = $objReader->load($filename);
$objPHPExcel->setActiveSheetIndex(0);
4,写
header('Content-Type: application/vnd.ms-excel');
header('Content-Disposition: attachment;filename="resinvlist.xls"');
header('Cache-Control: max-age=0');
// If you're serving to IE 9, then the following may be needed
header('Cache-Control: max-age=1');
// If you're serving to IE over SSL, then the following may be needed
header('Expires: Mon, 26 Jul 1997 05:00:00 GMT'); // Date in the past
header('Last-Modified: ' . gmdate('D, d M Y H:i:s') . ' GMT'); // always modified
header('Cache-Control: cache, must-revalidate'); // HTTP/1.1
header('Pragma: public'); // HTTP/1.0
$objWriter = new PHPExcel_Writer_Excel5($objPHPExcelWrite);
$objPHPExcelWrite->getActiveSheet()->getStyle('C')->getNumberFormat()
->setFormatCode(PHPExcel_Style_NumberFormat::FORMAT_TEXT);
$objPHPExcelWrite->setActiveSheetIndex(0)
->setCellValue( "A1", 'ID' )
->setCellValue( "B1", 'CustomerExID' )
->setCellValue( "C1",'InvNo');
Last:
$objWriter->save('php://output');
2017-12-22
TA创建的收藏夹 TA关注的收藏夹
TA关注的人