PHP HTML
(a simple example)
- PHP cannot read Excel files natively.
- Navigate to project folder in command line cd YOUR-HTTP-FOLDER.
- Run composer require phpoffice/phpspreadsheet.
USE PHPSPREADSHEET require "vendor/autoload.php"; $reader = new \PhpOffice\ PhpSpreadsheet\Reader\Xlsx();
READ EXCEL SPREADSHEET $ss = $reader->load("demo.xlsx"); $as = $ss->getActiveSheet();
foreach ($as->getRowIterator() as $r) { READ CELLS $iterator = $r->getCellIterator(); $iterator-> setIterateOnlyExistingCells(false); OUTPUT HTML foreach ($iterator as $c) { echo "<p>". $c->getValue() ." </p>"; } }