Thinkphp 使用PhPexcel 缓存

最新推荐文章于 2021-04-01 02:28:59 发布

pipilang3220119

最新推荐文章于 2021-04-01 02:28:59 发布

阅读量826

点赞数

分类专栏： PHP

本文链接：https://blog.csdn.net/pipilang3220119/article/details/50897827

版权

PHP 专栏收录该内容

6 篇文章 0 订阅

订阅专栏

public function test() {

		import("Vendor.PHPExcel.Classes.PHPExcel");

		$cacheMethod = \PHPExcel_CachedObjectStorageFactory::cache_to_discISAM;
		$cacheSettings = array('dir' => 'c:/tmp',
		);

		$s = \PHPExcel_Settings::setCacheStorageMethod($cacheMethod, $cacheSettings);

		echo $s;

		$objPHPExcel = new \PHPExcel();
		$objPHPExcel->setActiveSheetIndex(0);
		for ($i = 2; $i <= 500000; $i++) {

			$objPHPExcel->getActiveSheet()->setCellValue('A' . $i, "Firstname");
			$objPHPExcel->getActiveSheet()->setCellValue('B' . $i, "Lastname");
			$objPHPExcel->getActiveSheet()->setCellValue('C' . $i, "Phone");
			$objPHPExcel->getActiveSheet()->setCellValue('D' . $i, "Fax");
			$objPHPExcel->getActiveSheet()->setCellValue('E' . $i, "Is Client ?");
		}

		$filename = './Uploads/' . 'gy1.xlsx';

		// $objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'CSV')->setDelimiter(',')
		// 	->setEnclosure('"')
		// 	->setSheetIndex(0)
		// 	->save($filename);

		$objWriter = \PHPExcel_IOFactory::createWriter($objPHPExcel, 'Excel2007');
		$objWriter->save($filename);

	}