php excel false,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;

}

}

请问一下是什么问题?求解

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值