74 lines
2.1 KiB
PHP
74 lines
2.1 KiB
PHP
<?php
|
|
/**
|
|
* ZenTaoPMS - Open-source project management system.
|
|
*
|
|
* @copyright Copyright 2009-2025 禅道软件（青岛）有限公司(ZenTao Software (Qingdao) Co., Ltd. www.chandao.com)
|
|
* @license ZPL(http://zpl.pub/page/zplv12.html) or AGPL(https://www.gnu.org/licenses/agpl-3.0.en.html)
|
|
*
|
|
* A third-party license is embedded for some of the code in this file:
|
|
* The use of the source code of this file is also subject to the terms
|
|
* and consitions of the license of "PhpSpreadsheet" (LGPL, see
|
|
* </lib/vendor/phpoffice/phpspreadsheet/LICENSE>).
|
|
*/
|
|
|
|
use PhpOffice\PhpSpreadsheet\IOFactory;
|
|
use PhpOffice\PhpSpreadsheet\Reader\Xls;
|
|
use PhpOffice\PhpSpreadsheet\Reader\Xlsx;
|
|
use PhpOffice\PhpSpreadsheet\Reader\Exception as ReaderException;
|
|
use PhpOffice\PhpSpreadsheet\Writer\Exception as WriterException;
|
|
|
|
require_once dirname(__FILE__, 2) . '/base/delegate/delegate.class.php';
|
|
|
|
class phpExcel extends baseDelegate
|
|
{
|
|
protected static $className = 'PhpOffice\PhpSpreadsheet\Spreadsheet';
|
|
|
|
public function __construct()
|
|
{
|
|
$this->instance = new static::$className();
|
|
}
|
|
|
|
public static function load($file)
|
|
{
|
|
return IOFactory::load($file);
|
|
}
|
|
|
|
public function createReader($type = 'Xlsx')
|
|
{
|
|
try
|
|
{
|
|
return IOFactory::createReader($type);
|
|
}
|
|
catch (ReaderException $e)
|
|
{
|
|
throw new Exception('Create reader error, the error message is ' . $e->getMessage());
|
|
}
|
|
}
|
|
|
|
public function createWriter($type = 'Xlsx')
|
|
{
|
|
try
|
|
{
|
|
return IOFactory::createWriter($this->instance, ucfirst($type));
|
|
}
|
|
catch (WriterException $e)
|
|
{
|
|
throw new Exception('Create writer error, the error message is ' . $e->getMessage());
|
|
}
|
|
}
|
|
|
|
public static function canRead($file)
|
|
{
|
|
try
|
|
{
|
|
$fileType = IOFactory::identify($file);
|
|
$reader = IOFactory::createReader($fileType);
|
|
return $reader instanceof Xls || $reader instanceof Xlsx;
|
|
}
|
|
catch (ReaderException $e)
|
|
{
|
|
return false;
|
|
}
|
|
}
|
|
}
|