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: 10 years ago
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);

?>