PHP Classes

File: examples/04-upload_and_convert_to_html.php

Recommend this page to a friend!
  Classes 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: Update of examples/04-upload_and_convert_to_html.php
Date: 3 years ago
Size: 908 bytes
 

Contents

Class file image Download
<?php

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->rows() 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>';