excel
apollo__
这个作者很懒,什么都没留下…
展开
-
php csv导出
public function export_csv($filename,$data) { $data = mb_convert_encoding($data, "GBK","utf-8"); $filename=iconv("utf-8", "GBK", $filename); header("Content-type:text/csv"); header("Content-Disposition:attachment;filename=..原创 2021-09-18 16:55:21 · 150 阅读 · 0 评论 -
php使用file_put_contents读取csv
<?php function read_csv($filePath) { $str = file_get_contents($filePath); $data = explode("\n",$str); $csv_array = []; foreach ($data as $k=>$v){ $csv_array[] = preg_split('/(?:"[^"]*"|)\K\s*(,\s*|$)/', $v); } return .原创 2021-09-17 15:08:24 · 249 阅读 · 0 评论 -
php获取excel
//获取对应的excel横坐标 public function getExcelCoordinates($coordinate) { $alpha = array('A', 'B', 'C', 'D', 'E', 'F', 'G', 'H', 'I', 'J', 'K', 'L', 'M', 'N', 'O', 'P', 'Q', 'R', 'S', 'T', 'U', 'V', 'W', 'X', 'Y', 'Z'); $coordinate = $coordinate/1-1; .原创 2021-09-16 17:10:15 · 77 阅读 · 0 评论 -
读取excel文件
try { $inputFileType = PHPExcel_IOFactory::identify($filePath); $objReader = PHPExcel_IOFactory::createReader($inputFileType); $objPHPExcel = $objReader->load($filePath); } catch(Exception $e) { } // 确定要读取的sheet $sheet = $objPHPExcel->.原创 2021-09-16 16:35:45 · 76 阅读 · 0 评论