通过phpexcel导入和导出excel表格

首先是导入excel表格：

<?php  
mysql_connect('localhost', 'root', 'root');
mysql_select_db('excel');
mysql_query('set names utf8');
require_once './Classes/PHPExcel.php';
require_once './Classes/PHPExcel/IOFactory.php';
require_once './Classes/PHPExcel/Reader/Excel5.php';


$objReader = PHPExcel_IOFactory::createReader('Excel5'); //use Excel5 for 2003 format    
//这里是导入excel2003 的xls格式，如果是2007格式可以把“Excel5”换成“excel2007"
$excelpath='test.xls';
$objPHPExcel = $objReader->load($excelpath); 
$sheet = $objPHPExcel->getSheet(0); 
$objWorksheet = $objPHPExcel->getActiveSheet();
$highestRow = $sheet->getHighestRow();    //取得总行数 
$highestColumn = $sheet->getHighestColumn(); //取得总列数

$highestColumn =  ord($highestColumn)-65;
$excelData = array(); 

for($row = 1; $row <= $highestRow; $row++)
{ 
  for ($col = 0; $col <= $highestColumn; $col++)
  {
    $excelData[$row-1][] =(string)$objWorksheet->getCellByColumnAndRow($col, $row)->getValue();
  }
}


foreach ($excelData as $key => $value) 
{
  $sql = "INSERT INTO message (title) VALUES('$value[0]')";
  mysql_query($sql);
}

?><?php  
mysql_connect('localhos