先下载Excel库,下载地址:excel.php
以下为实例代码:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>无标题文档</title>
<style type="text/css">
.xls_ls{font-size: 12px; margin:0px; padding:0px; border-bottom:#EEE 1px dashed; height:20px; padding-top:10px; list-style:none}
.xls_ls li{ float:left; width:200px;}
</style>
</head>
<body>
<?php
require_once 'excel.php';
$data = new Spreadsheet_Excel_Reader();
$data->setOutputEncoding('utf-8');
$data->read('Book.xls');
error_reporting(E_ALL ^ E_NOTICE);
$xls_text='';
for ($i = 1; $i <= $data->sheets[0]['numRows']; $i++) {
$xls_text.='<ul class="xls_ls">';
for ($j = 1; $j <= $data->sheets[0]['numCols']; $j++) {
$xls_val=$data->sheets[0]['cells'][$i][$j];
$xls_text.='<li>'.($xls_val==''?' ':$xls_val).'</li>'."\n";
}
$xls_text.='</ul>'."\n";
}
echo $xls_text;
?>
</body>
</html>
完整源文件下载:jaes_excel.zip
说明:如果以上文件不能下载,请加入QQ群:59103908,群主发给大家!
上一篇:PHP常用自定义函数(3)
讨论数量:0