關于導出excel報表,網上也是一搜一大把。整理一下,無非就是幾種思路,有利用安裝excel軟件或插件的服務器直接生成,或者直接在客戶端生成(通常都是利用excel軟件或插件直接在瀏覽器生成)。反正萬變不離其宗,離開excel插件,這個活你還真的干不了,由此你可以看到軟件公司尤其是微軟的強大。下面貼一個比較簡單的導出excel報表的方法。在安裝了office2003的機器上,通過ie瀏覽器可以成功生成excel,而且一直有人在使用。如果你在測試的時候發(fā)現這個根本無法使用,請注意,這個很可能和你的機器配置有關,別懷疑代碼的正確性。下面就一個利用iBatis開發(fā)的例子來簡單說明一下。
1、實體類
Code
using System;
using System.Collections.Generic;
using System.Text;
#region Apache Notice
/*****************************************************************************
* $Header: $
* $Revision: 383115 $
* $Date: 2006-04-15 13:21:51 +0800 (星期六, 04 三月 2006) $
*
* IBatisNetDemo
* Copyright (C) 2006 - Shanyou Zhang
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* https://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*
********************************************************************************/
#endregion
namespace IBatisNetDemo.Domain
{
[Serializable]
public class Person
{
private int id;
private string firstName;
private string lastName;
private DateTime? birthDate;
private double? weightInKilograms;
private double? heightInMeters;
public Person() { }
public int Id
{
get { return id; }
set { id = value; }
}
public string FirstName
{
get { return firstName; }
set { firstName = value; }
}
public string LastName
{
get { return lastName; }
set { lastName = value; }
}
public DateTime? BirthDate
{
get { return birthDate; }
set { birthDate = value; }
}
public double? WeightInKilograms
{
get { return weightInKilograms; }
set { weightInKilograms = value; }
}
public double? HeightInMeters
{
get { return heightInMeters; }
set { heightInMeters = value; }
}
}
}
2、導出excel報表主程序方法
Code
using System;
using System.Collections.Generic;
using System.Text;
using System.Web;
using System.Web.UI;
using System.IO;
using System.Reflection;
#p#副標題#e#
namespace DotNet.Common.Util
{
/// <summary>
/// 導出excel 簡單實現
/// </summary>
public static class ExcelUtil
{
private static Page currentPage = HttpContext.Current.Handler as Page;
private static Object sycObj = new Object();
private static int incremental = 10;
/// <summary>
/// 按照時間生成excel名稱 防止生成相同名的excel造成文件覆蓋
/// </summary>
/// <returns></returns>
private static string CreateExcelName()
{
lock (sycObj)
{
incremental = incremental + 1;
if (incremental > 99)
incremental = 10;
return Convert.ToInt64(DateTime.Now.ToString("yyyyMMddHHmmssfff") + incremental).ToString();
}
}
/// <summary>
/// 導出excel
/// </summary>
/// <typeparam name="T">泛型實體</typeparam>
/// <param name="response"></param>
/// <param name="listColumes">要顯示的列名</param>
/// <param name="listProperty">要顯示的導出屬性名 和實體的屬性名有關,順序由顯示的列確定 可以同listColumes</param>
/// <param name="listModel">實體集合</param>
public static void ExportExcel<T>(HttpResponse response, IList<string> listColumns, IList<string> listProperty, IList<T> listModel) where T : class, new()
{
if (listColumns.Count == 0)
{
throw new IndexOutOfRangeException("No Columnes!");
}
if (listColumns.Count != listProperty.Count)
{
throw new ArgumentException("Columns and properties length are not equal.");
}
string sheetName = "sheetName";
using (StringWriter writer = new StringWriter())
{
writer.WriteLine("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");
writer.WriteLine("<head>");
writer.WriteLine("<!--[if gte mso 9]>");
writer.WriteLine("<xml>");
writer.WriteLine(" <x:ExcelWorkbook>");
writer.WriteLine(" <x:ExcelWorksheets>");
writer.WriteLine(" <x:ExcelWorksheet>");
writer.WriteLine(" <x:Name>" + sheetName + "</x:Name>");
writer.WriteLine(" <x:WorksheetOptions>");
writer.WriteLine(" <x:Print>");
writer.WriteLine(" <x:ValidPrinterInfo />");
writer.WriteLine(" </x:Print>");
writer.WriteLine(" </x:WorksheetOptions>");
writer.WriteLine(" </x:ExcelWorksheet>");
writer.WriteLine(" </x:ExcelWorksheets>");
writer.WriteLine("</x:ExcelWorkbook>");
writer.WriteLine("</xml>");
writer.WriteLine("<![endif]-->");
writer.WriteLine("</head>");
writer.WriteLine("<body>");
writer.WriteLine("<table>");
writer.WriteLine("<tr>");
foreach (string item in listColumns)
{
writer.WriteLine("<td>" + item + "</td>"); //列名
}
writer.WriteLine("</tr>");
//通過反射 顯示要顯示的列
BindingFlags bf = BindingFlags.Instance | BindingFlags.NonPublic | BindingFlags.Public | BindingFlags.Static;//反射標識
Type objType = typeof(T);
PropertyInfo[] propInfoArr = objType.GetProperties(bf);
foreach (T model in listModel)
{
writer.WriteLine("<tr>");
foreach (PropertyInfo propInf
關鍵詞標簽:asp.net,excel報表
相關閱讀
熱門文章 手把手教你用好LINQ to SQL在.NET環(huán)境下為網站增加IP過濾功能ASP.NET 如何避免頁面重新整理時重復送出用Asp.net擴展ExtJS
人氣排行 asp.net表單提交方法GET\POST在ASP.NET中如何判斷用戶IE瀏覽器的版本Asp.net中messagebox的實現方法Asp.net中的web.config配置在ASP.NET MVC中實現大文件異步上傳用Iformattable接口控制.Net中文本格式c#.Net經典面試題目用Asp.net擴展ExtJS