原文地址:php操作excel文件
作者:phpxx
PHP操作excel文件
------------------------------------------
Excel 类
V1.1
By Monkey
------------------------------------------
-----函数说明
读取Excel文件
function Read_Excel_File($ExcelFile,$Result)
$ExcelFile
Excel文件名
$Result
返回的结果
函数返回值
正常返回0,否则返回错误信息
返回的值数组
$result[sheet名][行][列] 的值为相应Excel Cell的值
建立Excel文件
function Create_Excel_File($ExcelFile,$Data)
$ExcelFile
Excel文件名
$Data
Excel表格数据
请把函数写在PHP脚本的开头
例1:
<?
require "excel_class.php";
Read_Excel_File("Book1.xls",$return);
for ($i=0;$i<count($return[Sheet1]);$i++)
{
for ($j=0;$j<count($return[Sheet1][$i]);$j++)
{
echo $return[Sheet1][$i][$j]."|";
}
echo "<br>";
}
?>
例2:
<?
require "excel_class.php";
Read_Excel_File("Book1.xls",$return);
Create_Excel_File("ddd.xls",$return[Sheet1]);
?>
类文件:excel_class.zip
下载地址: http://www.cnblogs.com/Files/coolstr/excel_class.zip
Excel 类
------------------------------------------
-----函数说明
读取Excel文件
function Read_Excel_File($ExcelFile,$Result)
$ExcelFile
$Result
函数返回值
返回的值数组
建立Excel文件
function Create_Excel_File($ExcelFile,$Data)
$ExcelFile
$Data
请把函数写在PHP脚本的开头
例1:
<?
require "excel_class.php";
Read_Excel_File("Book1.xls",$return);
for ($i=0;$i<count($return[Sheet1]);$i++)
{
}
?>
例2:
<?
require "excel_class.php";
Read_Excel_File("Book1.xls",$return);
Create_Excel_File("ddd.xls",$return[Sheet1]);
?>
类文件:excel_class.zip
下载地址: http://www.cnblogs.com/Files/coolstr/excel_class.zip
需要往一个excel文件的某个单元格写数据,该如何操作?
//首先一步
$excel = new COM("Excel.sheet") or Die ("Did not instantiate Excel");// 建立EXCEL的COM对象
//打开一个工作簿
$pathin = "工作簿目录";
$workbook = "工作簿名称";
$wkb = $excel->application->Workbooks->Open($pathin.$workbook) or Die ("Did not open $pathin $workbook");
//建新工作簿
$wkb = $excel->application->Workbooks->Add or Die("Unable to add a new work book");
//打开工作表
$sheet_name = "sheet1"
$sheet = $wkb->Worksheets($sheet_name) or Die("Unable to active $sheet_name");
//读一个单元格
$readcell = $sheet->cells($row,$column); //行和列直接用十进制数表示
$readcell->activate;
$result = $selcell->value; //读出单元格值
$excel = new COM("Excel.sheet") or Die ("Did not instantiate Excel");// 建立EXCEL的COM对象
//打开一个工作簿
$pathin = "工作簿目录";
$workbook = "工作簿名称";
$wkb = $excel->application->Workbooks->Open($pathin.$workbook) or Die ("Did not open $pathin $workbook");
//建新工作簿
$wkb = $excel->application->Workbooks->Add or Die("Unable to add a new work book");
//打开工作表
$sheet_name = "sheet1"
$sheet = $wkb->Worksheets($sheet_name) or Die("Unable to active $sheet_name");
//读一个单元格
$readcell = $sheet->cells($row,$column); //行和列直接用十进制数表示
$readcell->activate;
$result = $selcell->value; //读出单元格值