时间戳

首页 > 解决方案 > PHPExcell获取单元格值和单元格颜色？

php - PHPExcell获取单元格值和单元格颜色？

问题描述

如何从电子表格阅读器主或 PHPExcell 中获取单元格值和单元格颜色？

<?php

require('spreadsheet-reader-master/php-excel-reader/excel_reader2.php'); //spreadsheet-reader-master

require('spreadsheet-reader-master/SpreadsheetReader.php'); //spreadsheet-reader-master

$reader = new SpreadsheetReader('Book1.xlsx');   // xlsx file


foreach ($reader as $key ) {   
    //foreach loop 
    echo "<pre>";
    print_r($key);
 }

标签： phpexcelcodeigniter

解决方案

<?php
require('./PHPExcel-1.8/Classes/PHPExcel.php');

$tmpframe = './Book1.xlsx';
$exceReader = PHPExcel_IOFactory::createReaderForFile($tmpframe);
$excelObj = $exceReader->load($tmpframe);
$worksheet = $excelObj->getActiveSheet();
$lastRow = $worksheet->getHighestRow();
// $highestRow = $sheet->getHighestRow();
// $highestColumn = $worksheet->getHighestColumn();


$rowl = $worksheet->getHighestRow();
$coll = $worksheet->getHighestColumn();
echo "number of rows---".$rowl."<br>";
echo "number of column---".$coll."<br>";

$rowdumy = 20;
    $crt = 'QT';
    $crt++;
    for ($row=1; $row <= $rowdumy; $row++) { 
        echo "<h6>number of-----".$row."</h5><br>";
        for ($i = 'A'; $i !== $crt; $i++){
        $cell = $worksheet->getCell($i.$row);
        $colurc = $excelObj->getActiveSheet()->getStyle($i.$row)->getFill()->getStartColor()->getARGB();
        if($cell != '')
        {
            echo $cell."-[[".$colurc."]]";
        }
    }
    echo "<br>";
}
?>

推荐阅读