<?php
require 'Classes/';
set_time_limit(0);
ini_set("memory_limit", "512M"); // not required unless you are hitting a limit
$dir = "./split_approve";
$files = scandir($dir);
$fileType = 'Excel2007';
foreach ($files as $file) {
if ($file != "." && $file != "..") {
$fileName = $dir . "/" . $file;
// Load the workbook
$objPHPExcelReader = PHPExcel_IOFactory::createReader($fileType);
$objPHPExcel = $objPHPExcelReader->load($fileName);
$count = 0;
$j = 0;
try {
foreach ($objPHPExcel->getWorksheetIterator() as $worksheet) {
foreach ($worksheet->getRowIterator() as $row) {
$rowIndex = $row->getRowIndex();
//if($rowIndex<22)continue;
$cell = $worksheet->getCell('C' . $rowIndex);
$pic_path = $cell->getCalculatedValue();
$cell = $worksheet->getCell('D' . $rowIndex);
$pic_valid = $cell->getCalculatedValue();
if ($pic_valid == 2)
continue;
if (!file_exists($pic_path))
continue;
// Add an image to the worksheet
$objDrawing = new PHPExcel_Worksheet_Drawing();
$objDrawing->setPath($pic_path);
$objDrawing->setCoordinates('E' . $rowIndex);
$objDrawing->setWorksheet($objPHPExcel->getActiveSheet());
$count++;
if ($count > 1000) {
$j++;
$num = $j * 1000;
file_put_contents('', "count_" . $num . "_index_" . $rowIndex . PHP_EOL,
FILE_APPEND);
$count = 0;
}
}
}
}
catch (exception $e) {
echo $e->getMessage();
file_put_contents('', $e->getMessage(), FILE_APPEND);
exit;
}
// Save the workbook
$objPHPExcelWriter = PHPExcel_IOFactory::createWriter($objPHPExcel, $fileType);
$objPHPExcelWriter->save("./split_approve_pic/" . $file);
echo "finished!";
}
}