phpExcel读取excel文件生成excel文件

最新推荐文章于 2022-11-11 11:28:20 发布

haiwei_sun

最新推荐文章于 2022-11-11 11:28:20 发布

阅读量1.2k

点赞数

分类专栏： php 文章标签： excel include path encoding file 手机

本文链接：https://blog.csdn.net/helen_shw/article/details/6827060

版权

php 专栏收录该内容

105 篇文章 0 订阅

订阅专栏

1、读取

                set_time_limit(0);
		ini_set('memory_limit','200M');                          //设置文件上传大小
		require_once 'Classes/PHPExcel/IOFactory.php';
		$reader = PHPExcel_IOFactory::createReader('Excel2007');
		$resource = getcwd().'/Lib/Action/test.xlsx';
		if (!file_exists($resource)) {
			exit("$resource is not exists.\n");
		}
		$PHPExcel = $reader->load(getcwd().'/Lib/Action/test.xlsx'); // 文件名称
		$sheet = $PHPExcel->getSheet(0); //
		$highestRow = $sheet->getHighestRow(); // 取得总行数
		$highestColumn = $sheet->getHighestColumn(); // 取得总列数

	        $str="帐号,手机";
		// 每次读取一行，再在行中循环每列的数值
		for ($row = 1; $row <= $highestRow; $row++) {
			 $username .= $sheet->getCellByColumnAndRow(0, $row)->getValue().",";
		}
		echo $username;
		exit;
		$uname=explode(",",$username);

2、生成：

                $str="";
		set_time_limit(0);
		$uname=explode(",",$str);
		$str="帐号,手机\n";
		$file=date("Y-m-d")."-"."phonenums.csv";
		header('Content-Disposition: attachment; filename="'.$file.'"');
		for ($i=0;$i<count($uname);$i++){
			$name = $uname[$i];
			$phonenum=D("TableModel")->where("username='".$name."'")->getField("phonenum");
			if ($phonenum=="") {
				$phonenum=D("TableModel")->where("username='".$name."'")->getField("mobile");
			}
			$str.=$name.",".$phonenum."\n";
		}
		$str = mb_convert_encoding($str,"CP936","UTF-8");
		echo $str;

读取某excel文件，得到其每行每列的内容的一个示例：

set_include_path(get_include_path() . PATH_SEPARATOR . './Classes/');
include 'PHPExcel/IOFactory.php';

$reader = PHPExcel_IOFactory::createReader('Excel2007'); // 讀取 excel 檔案
$PHPExcel = $reader->load($excelfilename); // 檔案名稱
$sheet = $PHPExcel->getSheet(0); // 讀取第一個工作表(編號從 0 開始)
$highestRow = $sheet->getHighestRow(); // 取得总行数
$highestColumn = $sheet->getHighestColumn(); // 取得总列数
$arr = array(1=>'A',2=>'B',3=>'C',4=>'D',5=>'E',6=>'F',7=>'G',8=>'H',9=>'I',10=>'J',11=>'K',12=>'L',13=>'M', 14=>'N',15=>'O',16=>'P',17=>'Q',18=>'R',19=>'S',20=>'T',21=>'U',22=>'V',23=>'W',24=>'X',25=>'Y',26=>'Z');
//echo $highestRow.$highestColumn;
// 一次讀取一列

for ($row = 5; $row <= $highestRow; $row++) {
   for ($column = 0; $arr[$column] != 'T'; $column++) {
       $val = $sheet->getCellByColumnAndRow($column, $row)->getValue();
        echo $val;
    }
}