30 31 php phpexcel学习

http://www.cnblogs.com/firesnow/archive/2013/04/10/3013402.htm

http://blog.sina.com.cn/s/blog_44b3f96d0101cczo.htmll

phpexcel

1样式

$objWorksheet->getStyle('D3:D23')->getFill()->setFillType(PHPExcel_Style_Fill::FILL_SOLID);

2.锁定

$objWorksheet->getProtection()->setPassword('dejax_2014');

3.配置

  $dataBlockConf[$sheetNames[$i]] = $this->getDataBlockConf($objWorksheet,$allRow);

4写入

foreach($dataBlockConf[$sheetNames[$i]] as $v)

if($v['type']=="竖表"){

foreach($v['col'] as $row => $colname){
  foreach($data[0] as $key => $val){

else

$count = count($data);
  for($j=1; $j<=$count; $j++){
  $row = $v['startRow']+$j;

foreach($data[$j-1] as $key => $val){