deawx / php-excel Goto Github PK

<?php

use Excel\SpreadsheetFactory;

$reader = SpreadsheetFactory::createReader(SpreadsheetFactory::EXCEL_CSV);

<?php

use Excel\SpreadsheetFactory;

$filename = 'sample.csv';
$reader = SpreadsheetFactory::createReaderForFile($filename);

<?php

use Excel\Reader\BaseReader;

class SampleReader extends BaseReader {
    
    /**
     * Load filename
     *
     * @return void
     */
    public function load($filename): void 
    {
        // TODO
    }
    ...
}

----------------------------------------------

<?php

use Excel\SpreadsheetFactory;

SpreadsheetFactory::registerReader('Xlsx', SampleReader::class);

<?php

use Excel\SpreadsheetFactory;

$filename = 'sample.xlsx';
$reader = SpreadsheetFactory::createReaderForFile($filename);

/**
 * @example
 * [
 *     'Sheet1',
 *     'Sheet2',
 *     'Sheet3',
 * ]
 */
$worksheetNames = $reader->listWorksheetNames($filename);

<?php

use Excel\SpreadsheetFactory;

$filename = 'sample.xlsx';
$reader = SpreadsheetFactory::createReaderForFile($filename);

/**
 * @example
 * [
 *     [
 *          'worksheetName' => 'Sheet1',
 *          'lastColumnLetter' => 'C', 
 *          'lastColumnIndex' => '2', 
 *          'totalRows' => '2', 
 *          'totalColumns' => '3', 
 *     ],
 *     [
 *          'worksheetName' => 'Sheet2',
 *          'lastColumnLetter' => 'C', 
 *          'lastColumnIndex' => '2', 
 *          'totalRows' => '2', 
 *          'totalColumns' => '3', 
 *     ],
 *     [
 *          'worksheetName' => 'Sheet3',
 *          'lastColumnLetter' => 'C', 
 *          'lastColumnIndex' => '2', 
 *          'totalRows' => '2', 
 *          'totalColumns' => '3', 
 *     ],
 * ]
 */
$worksheetInfo = $reader->listWorksheetInfo($filename);

<?php

use Excel\SpreadsheetFactory;

$filename = 'sample.xlsx';
$reader = SpreadsheetFactory::createReaderForFile($filename);

foreach($reader->getRowIteratorByWorksheetIndex(0) as $row) {

    foreach($row->getCellIterator() as $cell) {

        // TODO...
    }

}

<?php

use Excel\SpreadsheetFactory;

$filename = 'sample.xlsx';
$reader = SpreadsheetFactory::createReaderForFile($filename);

foreach($reader->getRowIteratorByWorksheetName('Sheet1') as $row) {

    foreach($row->getCellIterator() as $cell) {

        // TODO...
    }

}