一、数据导出到excel
public static void ResponseExcel(Control ControlId, HttpResponse Response, string FileName)
...{
Response.Clear(); Response.ContentType = "application/vnd.ms-excel"; Response.ContentEncoding = System.Text.Encoding.GetEncoding("utf-8"); Response.AddHeader("Content-Disposition", "inline;filename=" + HttpUtility.UrlEncode(FileName, Encoding.UTF8) + ".xls"); System.Text.StringBuilder sb = new System.Text.StringBuilder(); System.IO.StringWriter sw = new System.IO.StringWriter(sb); System.Web.UI.HtmlTextWriter hw = new System.Web.UI.HtmlTextWriter(sw); sb.Append("<html><head>"); sb.Append("<meta http-equiv=Content-Type content=text/html;charset=UTF-8>"); sb.Append("</head><body>"); ControlId.RenderControl(hw); sb.Append("</body></html>"); Response.Write(sb.ToString()); Response.End();
}数据导入数据库
public static DataSet ExcelToDataSet(string opnFileName) ...{ string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + opnFileName + ";Extended Properties="Excel 8.0;HDR=YES;IMEX=1""; OleDbConnection conn = new OleDbConnection(strConn); string strExcel = ""; OleDbDataAdapter myCommand = null; DataSet ds = new DataSet(); strExcel = "select * from [sheet1$]"; try
...{ conn.Open(); myCommand = new OleDbDataAdapter(strExcel, strConn); myCommand.Fill(ds, "dtSource"); return ds;
} catch (Exception ex) ...{ return ds; } finally ...{ conn.Close(); conn.Dispose(); } }
扫一扫
3135
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
