douxun7992 2014-06-24 07:53
浏览 46
已采纳

PHPExcel csv文件的computeWorksheetDimension

I use PHPExcel to import data from a .csv file which has the same rows and columns with a excel file. Basically I open them with LibreOffice and they look the same. However there are two result when calculating theirs worksheet dimensions.

  1. csv: A1:A10
  2. xlsx: A1: AMK10

I just want to ask that it is always like that due to the different formats or I do something wrong?

$pi = pathinfo($filePath);
  switch ($pi['extension']) {
    case 'xls':
      $reader = PHPExcel_IOFactory::createReader('Excel5');
      break;
    case 'xlsx':
      $reader = PHPExcel_IOFactory::createReader('Excel2007');
      break;
    case 'csv':
      $reader = PHPExcel_IOFactory::createReader('CSV');
      break;
    default:
      return array();
  }
  $phpexcel = $reader->load($filePath);
  $sheet = $phpexcel->getActiveSheet();
  $sheet->calculateWorksheetDimension();
  • 写回答

1条回答 默认 最新

  • dongqiang8058 2014-06-24 11:31
    关注

    When loading a CSV file, if the delimiter isn't a default comma (,) then you need to explicitly set the delimiter for the reader. e.g.

    PHPExcel_IOFactory::createReader('CSV'); 
    $reader->setDelimiter(';');
    
    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论

报告相同问题?

悬赏问题

  • ¥15 MATLAB动图问题
  • ¥15 有段代码不知道怎么理解,const isToken = (config.headers || {}).isToken === false
  • ¥100 采用栈和深度优先算法对我的代码进行修改显示路径
  • ¥15 pointnet2包安装
  • ¥20 射频功率问题,解答者有酬谢!
  • ¥80 构建降雨和积水的预测模型
  • ¥15 #Qt Transform setTransform()在鼠标拖动移动视角是一致在原地不动,无法变换视角(细微观察似乎视图有在原地抖动),无法变换视角(细微观察似乎视图有在原地抖动)
  • ¥50 如何利用无人机拍摄的数码照片测量鸟卵的长短径
  • ¥100 github贡献者给与奖励
  • ¥15 使用DS18B20+ESP8266获取温度数据返回-127.00