PHP Classes

File: examples/04-upload_and_convert_to_html.php

Recommend this page to a friend!
  Packages of Sergey Shuchkin   SimpleXLSX   examples/04-upload_and_convert_to_html.php   Download  
File: examples/04-upload_and_convert_to_html.php
Role: Example script
Content type: text/plain
Description: Example script
Class: SimpleXLSX
Parse and retrieve data from Excel XLS files
Author: By
Last change: 1.0.12
1.0.10
0.9.10
Date: 3 days ago
Size: 1,043 bytes
 

Contents

Class file image Download
<?php

use Shuchkin\SimpleXLSX;

ini_set('error_reporting', E_ALL);
ini_set('display_errors', true);

require_once __DIR__.'/../src/SimpleXLSX.php';

echo '<h1>XLSX to HTML</h1>';

if (isset($_FILES['file'])) {
    if ($xlsx = SimpleXLSX::parse($_FILES['file']['tmp_name'])) {
        echo '<h2>Parsing Result</h2>';
        echo '<table border="1" cellpadding="3" style="border-collapse: collapse">';

        $dim = $xlsx->dimension();
        $cols = $dim[0];

        foreach ($xlsx->readRows() as $k => $r) {
            // if ($k == 0) continue; // skip first row
            echo '<tr>';
            for ($i = 0; $i < $cols; $i ++) {
                echo '<td>' . ( isset($r[ $i ]) ? $r[ $i ] : '&nbsp;' ) . '</td>';
            }
            echo '</tr>';
        }
        echo '</table>';
    } else {
        echo SimpleXLSX::parseError();
    }
}
echo '<h2>Upload form</h2>
<form method="post" enctype="multipart/form-data">
*.XLSX <input type="file" name="file" />&nbsp;&nbsp;<input type="submit" value="Parse" />
</form>';