一、數據導出到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(); } }
