//读取
setreaddataonly(true);
$xlsreader->setloadsheetsonly(true);
$sheets = $xlsreader->load($file);
$content = $sheets->getsheet(0)->toarray(); //读取第一个工作表(注意编号从0开始) 如果读取多个可以做一个循环0,1,2,3....
//得到二维数组,每个小数组是excel表格内容的一行 里面包含此行的每列的数据
return $content;
}
//$type = 'excel2007'; //设置要解析的excel类型 excel5(2003或以下版本)或excel2007
$type = 'excel5';
$content = readxls('data.xls', $type);
echo '
';
var_dump($content);
echo '
';  
//输出写入
setactivesheetindex(0);
$cols = 'abcdefghijklmnopqrstuvwxyz';
//设置标题
for($i=0,$length=count($title); $i $objphpexcel->getactivesheet()->setcellvalue($cols{$i}.'1', $title[$i]);
}
//设置标题样式(可按需求决定是否需要)
// $titlecount = count($title);
// $r = $cols{0}.'1';
// $c = $cols{$titlecount}.'1';
// $objphpexcel->getactivesheet()->getstyle($r:$c)->applyfromarray(
// array(
// 'font' => array(
// 'bold' => true
// ),
// 'alignment' => array(
// 'horizontal' => phpexcel_style_alignment::horizontal_right,
// ),
// 'borders' => array(
// 'top' => array(
// 'style' => phpexcel_style_border::border_thin
// )
// ),
// 'fill' => array(
// 'type' => phpexcel_style_fill::fill_gradient_linear,
// 'rotation' => 90,
// 'startcolor' => array(
// 'argb' => 'ffa0a0a0'
// ),
// 'endcolor' => array(
// 'argb' => 'ffffffff'
// )
// )
// )
// );
$i = 0;
foreach($data as $d) { //这里用foreach,支持关联数组和数字索引数组
$j = 0;
foreach($d as $v) { //这里用foreach,支持关联数组和数字索引数组
$objphpexcel->getactivesheet()->setcellvalue($cols{$j}.($i+2), $v);
$j++;
}
$i++;
}
// 生成2003excel格式的xls文件直接下载
/* header('content-type: application/vnd.ms-excel');
header('content-disposition: attachment;filename='.$filename.'.xls');
header('cache-control: max-age=0');
$objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel5');
$objwriter->save('php://output');*/
// 生成2007excel格式的xls文件保存到指定路径
$objwriter = phpexcel_iofactory::createwriter($objphpexcel, 'excel2007');
$objwriter->save('a.xlsx');
}
$arr=array();
mysql_connect('localhost','root','');
mysql_query('set names utf8');
mysql_query('use test');
$sql='select id,name,pid from shop where id $res=mysql_query($sql);
while($ret=mysql_fetch_assoc($res))
{
$arr[]=$ret;
}
$arr_type=array('商品id','名称','品牌id');
write_xls($arr,$arr_type,'report');