datalist生成excel.docVIP

DataView dataView1 = dsExcelList.Tables[0].DefaultView; DataList7.DataSource = dataView1; DataList7.DataBind(); string fileName = DateTime.Now.ToString(yyyyMMddHHmmss--) + userLogin.E_NAME + .xls; string path = Server.MapPath(Document/Excel/ + fileName); HyperLink14142.NavigateUrl = ~/Headhunter/SQL + FreedomManager.InteropExcel(GetDataSet(DataList7), path).Replace(\\, /); ; HyperLink14142.Text = 下载文档; public DataSet GetDataSet(DataList dl) { DataSet ds = new DataSet(); DataTable dt = new DataTable(); DataListItem col = dl.Items[0]; int colcount = col.Controls.Count; int colnum = 0; for (int j = 0; j colcount; j++) { if (col.Controls[j] is Label || col.Controls[j] is HyperLink) { dt.Columns.Add(column + colnum, System.Type.GetType(System.String));  colnum++; } } int dataListCount = dl.Items.Count; for (int i = 0; i dataListCount; i++) { DataRow dr = dt.NewRow(); colnum = 0;  DataListItem dli = dl.Items[i]; int count = dli.Controls.Count; for (int j = 0; j count; j++) { if (dli.Controls[j] is Label || dli.Controls[j] is HyperLink) { string column = column + colnum; dr[column] = getConttrilText(dli.Controls[j]); colnum++; } } dt.Rows.Add(dr); } ds.Tables.Add(dt); return ds; } View Code 1 /// summary 2 /// 生成excel 3 /// /summary 4 /// param name=dsDataSet/param 5 /// param name=strFileName绝对路径/param 6 /// returnsstring/returns 7 ? public static string InteropExcel(DataSet ds, string strFileName) 8 { 9 Microsoft.Office.I