excel的导入和导出

strContent.Append("\n");
}
response.AddHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode("excel", System.Text.Encoding.UTF8) + ".xls");
{
string strConn = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" + filePath + ";Extended Properties='Excel 12.0;HDR=Yes;IMEX=1'";
}
#endregion
导出
/// <summary>
/// 将明细表导出到Excel
/// </summary>
/// <param name="sql">要导入到Excel中的中文表头的Sql,将需要的字段通过sql as成中文名</param>
for (int i = 0; i < dt.Rows.Count; i++)
{
for (int y = 0; y < dt.Columns.Count; y++)
strContent.Append(dt.Rows[i][y] + "\t");
catch (Exception)
{
return null;
}
return myDataTable;
}
/// <param name="sheetName">要读取的Excle中的工作表名</param>
/// <returns></returns>
public DataTable ImportExcelToDataTable(string filePath,string sheetName)
for (int i = 0; i < dt.Columns.Count; i++)
strContent.Append(dt.Columns[i] + "\t");
strContent.Append("\n");
response.Write(strContent.ToString());
response.End();
return 1;
}
else
return -1;
{
DataTable dt = CommOtherBLL.ExportToExcel(sql);
if (dt != null && dt.Rows.Count > 0)
{
StringBuilder strContent = new StringBuilder();
using (OleDbConnection conn = new OleDbConnection(strConn))
{
OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT*FROM[" + sheetName + "$]", strConn);
/// <param name="response"></param>
/// <returns>1 成功 -1失败</returns>
protected int ExportToExcel(string sql, HttpResponse response)
}
导入函数
#region 读取Excle,并将Excle中的数据保存在Datatable中
/// <summary>
/// 读取Excle,并将Excle中的数据保持在Datatable中
/// </summary>
/// <param name="filePath">要读取的文件路径</param>
res-excel";
response.ContentEncoding = System.Text.Encoding.GetEncoding("GB2312");
DataTable myDataTable = new DataTable();
try
{
myCommand.Fill(myDataTable);
}