php excel 导入 显示不出来,phpexcel,thinkphp_PHPExcel导入数据出现问题，phpexcel,thinkphp - phpStudy...
PHPExcel导入数据出现问题
报错信息：
exception 'PHPExcel_Exception' with message 'Invalid cell coordinate ABCA2' in /home/wwwroot/localhost/Base/Extend/Library/ORG/PHPExcel/PHPExcel/Cell.php:539 Stack trace: #0 /home/wwwroot/localhost/Base/Extend/Library/ORG/PHPExcel/PHPExcel/Worksheet.php(1121): PHPExcel_Cell::coordinateFromString('ABCA2') #1 /home/wwwroot/localhost/Base/Extend/Library/ORG/PHPExcel/PHPExcel/Worksheet.php(1029): PHPExcel_Worksheet->getCell('ABCA2') #2 /home/wwwroot/localhost/App/Lib/Action/CustomerAction.class.php(1273): PHPExcel_Worksheet->setCellValue('ABCA2', 'xE5x85xB3xE9x94xAExE8xAFx8D') #3 /home/wwwroot/localhost/App/Lib/Action/CustomerAction.class.php(1032): CustomerAction->excelExport(Array) #4 [internal function]: CustomerAction->index() #5 /home/wwwroot/localhost/Base/Lib/Core/App.class.php(171): ReflectionMethod->invoke(Object(CustomerAction)) #6 /home/wwwroot/crm.gsi.com.cn/Base/Lib/Core/App.class.php(207): App::exec() #7 /home/wwwroot/localhost//Base/Lib/Core/Think.class.php(39): App::run() #8 /home/wwwroot/crm.gsi.com.cn/Base/Common/runtime.php(242): Think::start() #9 /home/wwwroot/localhost/Base/ThinkPHP.php(30): require('/home/wwwroot/c...') #10 /home/wwwroot/localhost/index.php(6): require('/home/wwwroot/c...') #11 {main}
代码：workersheet.php 1121 getCell方法
public function getCell($pCoordinate = 'A1')
{
// Check cell collection
if ($this->_cellCollection->isDataSet($pCoordinate)) {
return $this->_cellCollection->getCacheData($pCoordinate);
}
// Worksheet reference?
if (strpos($pCoordinate, '!') !== false) {
$worksheetReference = PHPExcel_Worksheet::extractSheetTitle($pCoordinate, true);
return $this->getParent()->getSheetByName($worksheetReference[0])->getCell($worksheetReference[1]);
}
// Named range?
if ((!preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_CELLREF.'$/i', $pCoordinate, $matches)) &&
(preg_match('/^'.PHPExcel_Calculation::CALCULATION_REGEXP_NAMEDRANGE.'$/i', $pCoordinate, $matches))) {
$namedRange = PHPExcel_NamedRange::resolveRange($pCoordinate, $this);
if ($namedRange !== NULL) {
$pCoordinate = $namedRange->getRange();
return $namedRange->getWorksheet()->getCell($pCoordinate);
}
}
// Uppercase coordinate
$pCoordinate = strtoupper($pCoordinate);
if (strpos($pCoordinate,':') !== false || strpos($pCoordinate,',') !== false) {
throw new Exception('Cell coordinate can not be a range of cells.');
} elseif (strpos($pCoordinate,'$') !== false) {
throw new Exception('Cell coordinate must not be absolute.');
} else {
// Create new cell object
// Coordinates
$aCoordinates = PHPExcel_Cell::coordinateFromString($pCoordinate);
$cell = $this->_cellCollection->addCacheData($pCoordinate,new PHPExcel_Cell($aCoordinates[0], $aCoordinates[1], null, PHPExcel_Cell_DataType::TYPE_NULL, $this));
$this->_cellCollectionIsSorted = false;
if (PHPExcel_Cell::columnIndexFromString($this->_cachedHighestColumn) < PHPExcel_Cell::columnIndexFromString($aCoordinates[0]))
$this->_cachedHighestColumn = $aCoordinates[0];
$this->_cachedHighestRow = max($this->_cachedHighestRow,$aCoordinates[1]);
// Cell needs appropriate xfIndex
$rowDimensions = $this->getRowDimensions();
$columnDimensions = $this->getColumnDimensions();
if ( isset($rowDimensions[$aCoordinates[1]]) && $rowDimensions[$aCoordinates[1]]->getXfIndex() !== null ) {
// then there is a row dimension with explicit style, assign it to the cell
$cell->setXfIndex($rowDimensions[$aCoordinates[1]]->getXfIndex());
} else if ( isset($columnDimensions[$aCoordinates[0]]) ) {
// then there is a column dimension, assign it to the cell
$cell->setXfIndex($columnDimensions[$aCoordinates[0]]->getXfIndex());
} else {
// set to default index
$cell->setXfIndex(0);
}
return $cell;
}
}
请问一下是什么问题？求解
相关阅读:
MAMP PRO配置出现本地网站无法打开的情况
vue的v-el指令获取不到元素
sublime text 制作vue文件模板
process.argv[2] 和 process.argv.slice(2) 有什么区别？
webpack多页面开发哪种目录结构比较好？
json排序的问题
新浪支付页面，嵌套在指定的页面里
前端发送一个ajax之后 express里面 res.redirect()一个页面为什么不能跳转呢？
android5.0真机无法获取短信广播
this.setData()
ThinkPHP中模型层的验证消息怎么怎么使用ajax返回呢？？
为什么靠jquery动态给的checked值只能点一次？
phpstorm 新建文件头部注释 如何增加一个最后修改时间?
javascript函数多分支获取不到返回值怎么解决和为什么？
antd rc-table那个组件中这行代码是什么意思？
关于SSL证书申请的问题
php怎么进行前后端分离?
ionic中ion-content里加ion-list和ion-item有自带的边距,这个要怎么去掉?
php做API后 由于API变动不大(题库),缓存用什么方案解决？
使用vue-cli引入外部jQuery文件的时候，报错