/**
* get Problems
* @return array
*/
function readExcel()
{
require_once "powerdream/Common/PHPExcel.php";
require_once "powerdream/Common/PHPExcel/Reader/Excel2003XML.php";
require_once "powerdream/Common/PHPExcel/Reader/Excel5.php";
require_once "powerdream/Common/PHPExcel/Reader/Excel2007.php";
$excel = new PHPExcel();
$reader = new PHPExcel_Reader_Excel2007();
# Judge excel type.
if (!$reader->canRead($filename)) {
$reader = new PHPExcel_Reader_Excel5();
if (!$reader->canRead($filename)) {
$reader = new PHPExcel_Reader_Excel2003XML();
if (!$reader->canRead($filename)) {
throwex($Error['import']);
}
}
}
$excel = $reader->load($filename);
$cursheet = $excel->getSheet(0);
$cols = $cursheet->getHighestColumn();
$rows = $cursheet->getHighestRow();
#var_dump($cols);
#var_dump($rows);
#var_dump($cursheet);
if (strlen($cols) == 2) {
$cols = 'Z';
}
$stdlist = array();
$map = array("sid", "sname", "gender", "grade", "major", "class", "email", "mobile", "short", "domitory");
for ($currow = 2; $currow <= $rows; $currow++) {
$m = 1;
$student = array();
$i = 0;
for ($curcol = 'A'; $curcol <= $cols; $curcol++) {
$now = $curcol . $currow;
$value = $cursheet->getCell($now)->getValue();
$student[$map[$i]] = $value;
$i++;
}
$student["password"] = encrypt($student["sid"]);
$student["time"] = date("Y-m-d H:i:s");
array_push($stdlist, $student);
}
return $stdlist;
}
/**
* Rewrite the wrong format excel
*/
public function rewriteExcel()
{
require_once "powerdream/Common/PHPExcel.php";
require_once "powerdream/Common/PHPExcel/Reader/Excel2003XML.php";
require_once "powerdream/Common/PHPExcel/Reader/Excel5.php";
require_once "powerdream/Common/PHPExcel/Reader/Excel2007.php";
require_once "powerdream/Common/PHPExcel.php";
// require_once("powerdream/Common/PHPExcel/Writer/Excel2003XML.php");
require_once "powerdream/Common/PHPExcel/Writer/Excel5.php";
require_once "powerdream/Common/PHPExcel/Writer/Excel2007.php";
$excel = new PHPExcel();
$writer = new PHPExcel_Writer_Excel5($excel);
$excel->setActiveSheetIndex(0);
$objActSheet = $excel->getActiveSheet();
$reader = new PHPExcel_Reader_Excel2007();
# Judge excel type.
$filename = str_replace('\\', '/', getcwd()) . $this->filename;
if (!$reader->canRead($filename)) {
$reader = new PHPExcel_Reader_Excel5();
if (!$reader->canRead($filename)) {
$reader = new PHPExcel_Reader_Excel2003XML();
if (!$reader->canRead($filename)) {
throwex(Error('import'));
}
}
}
#debug(1);
$excel = $reader->load($filename);
$cursheet = $excel->getSheet(0);
$cols = $cursheet->getHighestColumn();
$rows = $cursheet->getHighestRow();
if (strlen($cols) == 2) {
$cols = 'Z';
}
$count = 1;
$map = array('quiz', 'answer', 'A', 'B', 'C', 'D', 'E', 'F', 'G', 'H');
# Traverse the excel table and insert them into DB
for ($currow = 2; $currow <= $rows; $currow++) {
# Traverse the columns for each row
for ($curcol = 'A'; $curcol <= $cols; $curcol++) {
$now = $curcol . $currow;
$value = $cursheet->getCell($now)->getValue();
if ($value == null || $value == '') {
break;
}
if ($value instanceof PHPExcel_RichText) {
//富文本转换字符串
$value = $value->__toString();
}
$objActSheet->setCellValue($now, $value);
}
}
$writer->save("Downloads/excel/rewrite.xls");
}
