在c#应用程序中实现从Excel文件导入数据，但是为什么每次导入都会多出三空白行的，以下是程序片段：
string FileName;
            openFileDialog1.Filter = "Excle文件(*.xls)|*.xls";

            if (openFileDialog1.ShowDialog() == DialogResult.OK)
            {
                FileName = openFileDialog1.FileName;

                string constr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source='" + FileName + "';Extended Properties=Excel 8.0";

                DataSet myDataset = new DataSet();
                OleDbDataAdapter da = new OleDbDataAdapter("SELECT * FROM [Sheet1$]", constr);
                da.Fill(myDataset);
                //显示在dataGridView1
                try
                {

                    dataGridView1.DataSource = myDataset.Tables[0];

                }
                catch (Exception ex)
                {
                    MessageBox.Show(ex.Message.ToString());
                }

[[it] 本帖最后由 huangjojo 于 2008-4-12 20:41 编辑 [/it]]