Login   Register  
PHP Classes
elePHPant
Icontem

File: inputExcel.php

Recommend this page to a friend!
Stumble It! Stumble It! Bookmark in del.icio.us Bookmark in del.icio.us
  Classes of Umesh Rai  >  Excel convertor  >  inputExcel.php  >  Download  
File: inputExcel.php
Role: Example script
Content type: text/plain
Description: Converts the Excel file read through the class file to HTML file
Class: Excel convertor
Read data from Excel files using COM objects
Author: By
Last change: Some browsers are truncating the path.
Date: 2004-08-19 05:03
Size: 2,631 bytes
 

Contents

Class file image Download
<?php
require ("excel2html.php");
// require ("function.php");
$pathInName = $_POST['inFile'];
$worksheet = $_POST['worksheet'];
$startCell = $_POST['startCell'];
$endCell = $_POST['endCell'];
$pathInName = realpath($pathInName); //some browser store differently

// Instantiate Excel
$E = new Excel2html;
$workbook = $E->myfile($pathInName);
$pathin = $E->mypath($pathInName);



// Default value for Worksheet
if (!$worksheet)$worksheet = 'Sheet1';

// Open the workbook
$E->XL($workbook, $pathin, $sheet);

// Default value for Starting Cell
if (!$startCell)$startCell = 'A1';

// Default value for End Cell
if (!$endCell)$endCell = 'd5';
$sheet = $worksheet;
$startStr = $E->getCellString($startCell);
$startNum = $E->getCellNum($startCell);
$endStr = $E->getCellString($endCell);
$endNum = $E->getCellNum($endCell);

// Read the content of range of cells and output to html file
$cellRange = $startCell . ":" . $endCell;
$content = $E->readrange($sheet, $cellRange);
echo "<html><head><title>Excel to HTML</title></head>";
echo "<body style='background-color: #DEEEF3'>";
echo "<div align='center'><br><table border='1' cellspacing='1' cellpadding='1'>";
if (is_array($content)) {
    $count = sizeof($content);
    for ($num = 0; $num < $count; $num++)
    if (is_array($content[$num])) {
        $countArray = sizeof($content[$num]);
        if ($num == 0) {
            echo "<tr bgcolor='#CDFE98' align='center'><td>&nbsp</td>";
            for ($numArray = 0; $numArray < $countArray; $numArray++) {
                echo "<td>";
                echo strtoupper($startStr++);
                echo "</td>";
            } 
            echo "</tr>";
        } 
        echo "<tr>";
        for ($numArray = 0; $numArray < $countArray; $numArray++) {
            if ($num == 0) {
                if ($numArray == 0)
                    print "<td bgcolor='#CDFE98'>" . $startNum++ . "</td>";
                echo "<td bgcolor='blue'><font size='5' color='white'>";
                echo $content[$num][$numArray];
                echo "</font></td>";
            } else {
                if ($numArray == 0)
                    print "<td bgcolor='#CDFE98'>" . $startNum++ . "</td>";
                echo "<td>";
                echo $content[$num][$numArray];
                echo "</td>";
            } 
        } 
        echo "</tr>";
    } 
} 
echo "</table></div><br><br>";
echo "<div align='right'><font color='blue'>Contact at: bumeshrai@hotmail.com</font></div>";
echo "</body></html>";

// Close the file
$E->closexl();
unset ($E);

?>