/// <summary>
/// 导出
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="collection">数据源</param>
/// <param name="title">列名</param>
/// <param name="fileName">文件名</param>
public static void Except <T>(IEnumerable <T> collection, string title, string fileName)
{
var tb = Utility.ToDataTable(collection);
Spire.Xls.Workbook workbook = new Spire.Xls.Workbook();
Spire.Xls.Worksheet sheet = workbook.Worksheets[0];
sheet.InsertDataTable(tb, true, 1, 1);
var dataRow = sheet.Rows[0];
var strColumns = title;
string[] strArry = strColumns.Split(',');
for (int i = 0; i < strArry.Length; i++)
{
dataRow.Cells[i].Value = strArry[i];
}
var resp = System.Web.HttpContext.Current.Response;
workbook.SaveToHttpResponse(fileName + ".xls", resp);
resp.Flush();
resp.End();
}
