Web页面生成 Excel 表格

        最近在做一个运动会的项目，要实现一个简单的 Excel  报表 ，虽然用 Crystal Reports 很容易实现，但是这个报表太简单，除了系统管理员其他用户也可以使用，所以就没放在“报表中心”里面，想用纯代码实现。
       做了好久在 Web 页面还是没有实现，最后用 ASP 的思想给实现了，现在把代码贴出来跟大家分享，并请大家指点！！！
  要得到的效果  ： 
        

首先在 ASPX 页面放上表格：

再切换到 HTML 页面，代码如下：


<%@ Import Namespace="System.Data" %>请大家多多指教啊……<%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><%@ Import Namespace="System.Data" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><% Response.ContentType = "application/vnd.ms-excel"; Response.Charset= "gb2312"; Response.AddHeader("content-disposition", "attachment;filename=report.xls"); %> <%@ Import Namespace="System.Data" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><% Response.ContentType = "application/vnd.ms-excel"; Response.Charset= "gb2312"; Response.AddHeader("content-disposition", "attachment;filename=report.xls"); %> <%@ Import Namespace="System.Data" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><% Response.ContentType = "application/vnd.ms-excel"; Response.Charset= "gb2312"; Response.AddHeader("content-disposition", "attachment;filename=report.xls"); %> <%@ Import Namespace="System.Data" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><% Response.ContentType = "application/vnd.ms-excel"; Response.Charset= "gb2312"; Response.AddHeader("content-disposition", "attachment;filename=report.xls"); %> <%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><% Response.ContentType = "application/vnd.ms-excel"; Response.Charset= "gb2312"; Response.AddHeader("content-disposition", "attachment;filename=report.xls"); %> <%@ Import Namespace="System.Data" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><% Response.ContentType = "application/vnd.ms-excel"; Response.Charset= "gb2312"; Response.AddHeader("content-disposition", "attachment;filename=report.xls"); %> <%@ Import Namespace="System.Data" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><% Response.ContentType = "application/vnd.ms-excel"; Response.Charset= "gb2312"; Response.AddHeader("content-disposition", "attachment;filename=report.xls"); %> <%@ Import Namespace="System.Data" %><%@ Import Namespace="Game2006.Model" %><%@ Import Namespace="Game2006.DAL" %><%@ Import Namespace="Game2006.BLL" %><%@ Import Namespace="Game2006" %><%@ Page Language="c#" CodeBehind="excel_down_item.aspx.cs" AutoEventWireup="false" Inherits="Game2006.excel_down_item" %><% Response.ContentType = "application/vnd.ms-excel"; Response.Charset= "gb2312"; Response.AddHeader("content-disposition", "attachment;filename=report.xls"); %>