excel 怎么写 才可以 导入 SQL?

答案：public static DataSet GetDataSet(string FilePath)
    {
        string OledbConnectionString = string.Format("Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + FilePath + "';Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'");
        OleDbConnection conn = new OleDbConnection(OledbConnectionString);
        ArrayList SheetNameList = new ArrayList();
        try
        {
            if (conn.State == ConnectionState.Closed)
            {
                conn.Open();
            }
            DataTable dtExcelSchema = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
            string SheetName = "";
            for (int i = 0; i < dtExcelSchema.Rows.Count; i++)
            {
                SheetName = dtExcelSchema.Rows[i]["TABLE_NAME"].ToString();
                SheetNameList.Add(SheetName);
            }
        }
        catch (Exception ex)
        {
            throw ex;
        }
        finally
        {
            conn.Close();
        }
        DataSet dsExcel = new DataSet();

        try
        {
            string strSql = "";

            for (int i = 0; i < SheetNameList.Count; i++)
            {
                strSql = "select * from [" + (string)SheetNameList[i] + "]";
                OleDbDataAdapter oleExcelDataAdapter = new OleDbDataAdapter(strSql, conn);
                DataTable dtExcel = new DataTable((string)SheetNameList[i]);
                oleExcelDataAdapter.Fill(dtExcel);
                dsExcel.Tables.Add(dtExcel);
            }
            return dsExcel;
        }
        catch (Exception ex)
        {
            throw ex;
        }
    }

这个方法就是从EXCEL文件读取数据转换为DataSet 

下面一段时调用的时候要注意的，写要在服务器端保存一下上传的EXCEL，然后再调用

        string filePath = "";
        DataSet ds = new DataSet();
        if (System.IO.Path.GetExtension(FileUpload1.FileName) != ".xls")
        {
            ClientScript.RegisterStartupScript(Page.GetType(), "", "<script>alter('hao')</script>");
            return;
        }
        else
        {
            filePath = "D:\\" + FileUpload1.FileName;
            FileUpload1.SaveAs(filePath);
            string fileName = FileUpload1.FileName;
            int start = fileName.IndexOf('.');
            fileName = fileName.Substring(0, start);
            ds = GetDataSet(filePath);
        }

上一个：excel中 如何条件选择到指定单元格里面
下一个：EXCEL2003计算减法向下拉的时候结果和第一项一致无变更，这是怎么回事啊？