c# 导入导出excel

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
using System.Data.OleDb;
using System.Text;
using JJoobb.Web;
using System.IO;

public partial class Admin_ManageClient_dd : System.Web.UI.Page
{

    string strConn = SiteSetting.ConnectionString;
    string sqlSelectALL = SiteSetting.sqlSelALL;
    string exToDB = SiteSetting.ExToDB;
    protected void Page_Load(object sender, EventArgs e)
    {
    }
    protected void readFromDB_Click(object sender, EventArgs e)
    {
        Bind();
    }
    public void btnOut_Click(object sender, EventArgs e)
    {
        try
        {
            CreateExcel(getds());
            Response.Write("<script>alert('数据导出成功!')</script>");
        }
        catch
        {
            Response.Write("<script>alert('数据导出失败!')</script>");
        }
    }
    public void CreateExcel(DataSet ds)
    {
        string outPutPath = SiteSetting.OutPutPath + DateTime.Now.ToString("yyyyMMddHHmmss-") + SiteSetting.FileName;
        FileStream file = new FileStream(outPutPath, FileMode.Create);
        StreamWriter sw = new StreamWriter(file, Encoding.Default);//设置编码为当面页面编码         
        string colHeaders = "", ls_item = "";         //定义表对象与行对象，同时用DataSet对其值进行初始化          
        DataTable dt = ds.Tables[0]; DataRow[] myRow = dt.Select();//可以类似dt.Select("id>10")之形式达到数据筛选目的         
        int i = 0; int cl = dt.Columns.Count;         //取得数据表各列标题，各标题之间以\t分割，最后一个列标题后加回车符  
        for (i = 0; i < cl; i++)
        {
            if (i == (cl - 1))//最后一列，加\n             
            {
                colHeaders += dt.Columns[i].Caption.ToString() + "\n";
            }
            else
            {
                colHeaders += dt.Columns[i].Caption.ToString() + "\t";
            }
        }
        sw.Write(colHeaders);
        foreach (DataRow row in myRow)
        {             //当前行数据写入输出流，并且置空ls_item以便下行数据                  
            for (i = 0; i < cl; i++)
            {
                if (i == (cl - 1))
                {
                    ls_item += row[i].ToString() + "\n";
                }
                else
                {
                    ls_item += row[i].ToString() + "\t";
                }
            }
            sw.Write(ls_item);
            ls_item = "";
        }
        sw.Flush();
        sw.Close();
        file.Close();
    }
    private DataSet getds()
    {
        SqlConnection conns = new SqlConnection(strConn);
        SqlDataAdapter da = new SqlDataAdapter(sqlSelectALL, conns);
        DataSet ds = new DataSet();
        da.Fill(ds);
        conns.Close();
        conns.Dispose();
        return ds;
    }
    //绑定数据     
    public void Bind()
    {
        DataSet ds = new DataSet();
        using (SqlConnection conn = new SqlConnection())
        {
            SqlDataAdapter sda = new SqlDataAdapter(sqlSelectALL, strConn);
            sda.Fill(ds, "Client");
        }
        GridView1.DataSource = ds.Tables["Client"];
        GridView1.DataBind();
    }     //导入数据     
    protected void Import_Click(object sender, EventArgs e)
    {
        string getErrMsg = "";
        DataSet excelDs = new DataSet();
        if (FileUpload1.PostedFile.FileName == "")
        {
            Response.Write("<script language=javascript>alert('请选择要上传的文件！');</script>");
            return;
        }
        //从Excel读取数据    


        string  filePath = FileUpload1.PostedFile.FileName;
        string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Extended Properties=\"Excel 8.0;HDR=Yes;IMEX=1\";Data Source=" + filePath;
        OleDbConnection excelConn = new OleDbConnection(connString);
        OleDbDataAdapter ExcelDA = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", excelConn);
        try
        {
            ExcelDA.Fill(excelDs, "Client");
        }
        catch (Exception err)
        {
            Response.Write(err.Message);
        }
        finally
        {
            excelConn.Close();
            excelConn = null;

        }
        //将数据写入数据库  
        if (excelDs.Tables[0].Rows.Count != 0) 
        { 
            SqlConnection sqlConn = new SqlConnection(strConn); 
            sqlConn.Open(); SqlCommand myCommand = sqlConn.CreateCommand(); 
            SqlTransaction myTrans = sqlConn.BeginTransaction(); 
            myCommand.Transaction = myTrans; 
            try 
            {
                for (int i = 0; i < excelDs.Tables[0].Rows.Count; i++) 
                {
                    string sql = "insert into Client( name, fullname,email) values('"  + excelDs.Tables[0].Rows[i]["姓名"].ToString() + "','" + excelDs.Tables[0].Rows[i]["昵称"].ToString() + "','" + excelDs.Tables[0].Rows[i]["邮箱"].ToString() + "')"; 
                    myCommand.CommandText = sql; 
                    myCommand.ExecuteNonQuery(); 
                } 
                myTrans.Commit(); 
            }
            catch (Exception ex) 
            { 
                getErrMsg = ex.Message.ToString(); 
                Response.Write(ex.Message.ToString()); myTrans.Rollback();
            } 
            finally
            { 
                sqlConn.Close(); sqlConn = null; 
            } 
        }         //返回提示信息          
        if (getErrMsg == "" || getErrMsg == null)         
        {            
            Response.Write("<script language='Javascript'>alert('导入成功！')</script>"); 
            Bind(); 
        }        
        else         
        {             
            Response.Write("<script language='Javascript'>alert('导入失败！')</script>"); 
            return;  
        } 




    }
}

前台aspx页面

<%@ Page Language="C#" AutoEventWireup="true" CodeFile="dd.aspx.cs" Inherits="Admin_ManageClient_dd" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>导入导出页面</title>
</head>
<body>
<form id="form1" runat="server"> 
    <table style="width: 858px">         
    <tr> 
    <td style="width: 334px">
    <asp:Button ID="readFromDB" runat="server" OnClick="readFromDB_Click" Text="从数据库读取数据" /> 
     <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="True" BackColor="White" BorderColor="#E7E7FF" BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Names="Arial" Font-Size="12px" GridLines="Horizontal" RowStyle-HorizontalAlign="Center" Width="98%">                  
     <FooterStyle BackColor="#B5C7DE" ForeColor="#4A3C8C" /> <RowStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Center" />                  
     <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="#F7F7F7" />                  
     <PagerStyle BackColor="#E7E7FF" ForeColor="#4A3C8C" HorizontalAlign="Right" />                  
     <HeaderStyle BackColor="#4A3C8C" Font-Bold="True" ForeColor="#F7F7F7" HorizontalAlign="Center" />                  
     <AlternatingRowStyle BackColor="#F7F7F7" /> </asp:GridView>                 
     <asp:FileUpload ID="FileUpload1" runat="server" />                  
     <asp:Button ID="Import" runat="server" OnClick="Import_Click" Text="导入" />                 
     <asp:Button ID="output" runat="server" OnClick="btnOut_Click" Text="导出" />             
      </td>         
      </tr>     
      </table>     
      </form>
</body>
</html>