/// <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(); }