php使用excel_class.php操作Excel文件
<?php//header("Content-type: application/vnd.ms-excel");//header("Content-Disposition: attachment;Filename=document_name.xls");header('Content-type:text/html;charset=utf-8');require_once 'excel_class.php';//定义一个excel文件$workbook = dirname(__FILE__)."\stock_2.xls";Read_Excel_File($workbook,$return);// $result[行][列] 的值为相应Excel Cell的值$data =array();$trans = array("/" => "");//echo "仓库库存报表\t\n";//echo "pnumber\tcounts\t\n";$data="仓库库存报表";$data="";$data="pnumber";$data="counts";$s=2;for ($i=0;$i<count($return['Sheet1']);$i++){for ($j=0;$j<count($return['Sheet1'][$i]);$j++){if($j==2 && $i>3){$str= trim($return['Sheet1'][$i][$j])."-";}if($j==5 && $i>3){$str.= strtr(trim($return['Sheet1'][$i][$j]),$trans)."-";}if(strpos($str,"M") || strpos($str,"男")){$n=38;}else{$n=34;}for($m=0;$m<10;$m++){if(($j==20+$m) && $i>3){if(trim($return[$i][$j]!="")){//echo $str.($n+$m)."\t".trim($return[$i][$j])."\t\n";$data[$s]=$str.($n+$m);$data[$s]=trim($return['Sheet1'][$i][$j]);$s++;}}}}}Create_Excel_File(dirname(__FILE__)."\ddd.xls",$data);?>
页:
[1]