芝麻web文件管理V1.00

编辑当前文件:/home/prismawe/www/projets/include/class.xls.php

<?php

Class xls
{
    private $fp = null;
    private $state = "CLOSED";
    private $newRow = false;

/*
		* @Params : $file  : file name of excel file to be created.
		* @Return : On Success Valid File Pointer to file
		* 			On Failure return false
		*/

function __construct($file = "")
    {
        return $this->open($file);
    }

function open($file)
    {
        if ($this->state != "CLOSED")
        {
            return false;
        }

if (!empty($file))
        {
            $this->fp = @fopen($file, "w+");
        }
        else
        {
            return false;
        }
        if ($this->fp == false)
        {
            return false;
        }
        $this->state = "OPENED";
        fwrite($this->fp, $this->GetHeader());
        return $this->fp;
    }

function close()
    {
        if ($this->state != "OPENED")
        {
            return false;
        }
        if ($this->newRow)
        {
            fwrite($this->fp, "</tr>");
            $this->newRow = false;
        }

fwrite($this->fp, $this->GetFooter());
        fclose($this->fp);
        $this->state = "CLOSED";
        return ;
    }

function GetHeader()
    {
        $lastsav = date("e");
        $header = <<<EOH
				<html xmlns:o="urn:schemas-microsoft-com:office:office"
				xmlns:x="urn:schemas-microsoft-com:office:excel"
				xmlns="http://www.w3.org/TR/REC-html40">

<head>
				<meta http-equiv=Content-Type content="text/html; charset=utf-8">
				<meta name=ProgId content=Excel.Sheet>
				
				<style>
				
				</style>
				
				</head>

<body link=blue vlink=purple>
				<table x:str border=0 cellpadding=0 cellspacing=0 style="border-collapse: collapse;table-layout:fixed;">
EOH;
        return $header;
    }

function GetFooter()
    {
        return "</table></body></html>";
    }

function writeLine(array $line_arr, $width = 64)
    {
        if ($this->state != "OPENED")
        {
            return false;
        }

fwrite($this->fp, "<tr>");
        foreach($line_arr as $col)
        {
            fwrite($this->fp, "<td class=xl24 width=$width >$col</td>");
        }
        fwrite($this->fp, "</tr>");
    }

function writeBoldLine(array $line_arr, $width = 64)
    {
        if ($this->state != "OPENED")
        {
            return false;
        }

fwrite($this->fp, "<tr>");
        foreach($line_arr as $col)
        {
            fwrite($this->fp, "<td class = x125 width=$width ><b>$col</b></td>");
        }
        fwrite($this->fp, "</tr>");
    }

function writeHeadLine(array $line_arr, $width = 64)
    {
        if ($this->state != "OPENED")
        {
            return false;
        }

fwrite($this->fp, "<tr>");
        foreach($line_arr as $col)
        {
            fwrite($this->fp, "<td class = x125 width=$width ><h3>$col</h3></td>");
        }
        fwrite($this->fp, "</tr>");
    }

function writeColspan($value, $colspan = 0)
    {
        if ($this->state != "OPENED")
        {
            return false;
        }
        fwrite($this->fp, "<td colspan=$colspan class=xl24 width=64 >$value</td>");
    }

function writeCol($value)
    {
        if ($this->state != "OPENED")
        {
            return false;
        }
        fwrite($this->fp, "<td class=xl24 width=64 >$value</td>");
    }
}