用asp、php或html读取excel 数据并显示在当前网...-php调用excel,phpexcel中文手册

如果要利用了php输出excel格式文件就必须利用header content-type:application/vnd.ms-excel来实现。如下
<?php
$filename = name .'.xls';
header("content-type:application/vnd.ms-excel");
header("content-disposition:attachment;filename=$filename");
?>
再看一php输出excel实例
<?php
header("content-type:application/vnd.ms-excel");
header("content-disposition:filename=test.xls");
echo "a1tb1tc1tna2ta3ta4tn";//r t单元格,n新一行
?>

<?php
require_once("../../config/sys_config.php"); //配置文件
require_once("../../include/db_class.php");
header("content-type: text/html; charset=$page_code"); //页面编码
header("content-type:application/vnd.ms-excel");
header("content-disposition:attachment;filename=".mb_convert_encoding("客户资料报表","gbk",$page_code).".xls");
header("pragma:no-cache");
header("expires:0");
//$usersid = intval( $_get['uid'] ); //用户id

//输出内容如下：
// 输出表头
echo iconv("utf-8", "gb2312", "客户名称")."t";
echo iconv("utf-8", "gb2312", "电话e69da5e887aa7a64361")."t";
echo iconv("utf-8", "gb2312", "地址")."t";
echo iconv("utf-8", "gb2312", "添加日期")."t";
echo "n"; //换行

$sqlstr = "select * from clients where usersid=32 order by clientsid desc";
$rows = $db -> select($sqlstr);
$num = count($rows); //客户总数
for( $i = 0; $i < $num; $i++ )
{
echo iconv("utf-8", "gb2312",$rows[$i][clientsname])."t";
echo iconv("utf-8", "gb2312",$rows[$i][clientsphone])."t";
echo iconv("utf-8", "gb2312",$rows[$i][clientsaddress])."t";
echo iconv("utf-8", "gb2312",$rows[$i][clientstime])."t";
echo "n"; //换行
}
?>

将excel文件作为数据源，如通过oledb连接方式，读取时，一个工作表等同于一个table数据表，循环读取即可
用phpexcel 来导出里面的数据啊 然后再用数据 在页面上展示就好了

phpexcel已经有很完整的demo了，好好看看吧