PHP Classes
elePHPant
Icontem

File: examples/04-upload_and_convert_to_html.php

Recommend this page to a friend!
  Classes of Sergey Shuchkin  >  Simple XLSX  >  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: Simple XLSX
Parse and retrieve data from Excel XLS files
Author: By
Last change: remove list( $x, $y ) for PHP 5 and 7 capabilities
Merge pull request #36 from tfve/master

use shared string in date cell
Date: 2 months 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>'
;