把Excel文档转换成DataTable

来源：互联网发布：软件培训机构网站编辑：程序博客网时间：2024/05/21 22:33

把Excel文档转换成DataTable的方法：

public DataTable XlsToDataTable(string strpath)            //适用于Excel 2003
    {
        string strConn;
        strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" +
        "Data Source=" + strpath + ";" +
        "Extended Properties=Excel 8.0;";
        OleDbConnection conn = new OleDbConnection(strConn);
        OleDbDataAdapter myCommand = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", strConn);
        DataTable dt = new DataTable();
        myCommand.Fill(dt);
        return dt;
    }

通过如下方法可以获取Excel表中几行几列的内容：
public string GetExcelContent()
{
        string strpath = FileUpload1.PostedFile.FileName.ToString();
        DataTable data = XlsToDataTable(strpath);
        string ch= "";
        string fzb = "";
        string caf = "";
        string mgf = "";

        for (int i = 0; i < data.Rows.Count; i++)
        {
            ch= data.Rows[i][0].ToString();
            fzb = data.Rows[i][1].ToString();
            caf = data.Rows[i][2].ToString();
            mgf = data.Rows[i][3].ToString();
        }
      return ch;
}