大家帮我看看这个代码，excel导出没有数据

[legu1]

protected void Button1_Click(object sender, EventArgs e)
{

string strConnection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = D:\\duijiangzhong.xls;Extended Properties ='Excel 8.0;HDR=NO;IMEX=1'";
OleDbConnection objConnection = new OleDbConnection(strConnection);
objConnection.Open();
OleDbDataAdapter myCommandd = new OleDbDataAdapter("select * from [Sheet1$]", objConnection);
DataSet ds = new DataSet();
myCommandd.Fill(ds);
DataTable dt = ds.Tables["[Sheet1$]"];
for (int i = 0; i < dt.Rows.Count; i++)
{
LAwards la =LAwards.CreateInstance();
la.ID= int.Parse(dt.Rows[i][0].ToString());
la.AwardName = dt.Rows[i][1].ToString();
}
}

[liao02163595]

select * from [Sheet1$]
表可能不是 Sheet1$

[legu1]

我弄出来了，嘿嘿

[super1021love]

楼主把你的DataTable dt = ds.Tables["[Sheet1$]"];
修改成DataTable dt = ds.Tables[0];

[子夜__]

 DataTable Excel_UserInfo = new DataTable();
            FileInfo fileInfo = new FileInfo(Path.Combine(TEMP_DIRECTORY, Guid.NewGuid().ToString() + ".xlsx"));
            try
            {
                using (Stream xlsStream = new BufferedStream(fileInfo.Open(FileMode.CreateNew), 1024))
                {
                    xlsStream.Write(EmployeeBytes, 0, EmployeeBytes.Length);
                }
                string strConn = @"Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + fileInfo.FullName + ";" + "Extended Properties=\"Excel 12.0;HDR=YES;IMEX=1;\"";
                string strExcel = "select * from [Chengdu Resources$]";

                using (OleDbDataAdapter adaptor = new OleDbDataAdapter(strExcel, strConn))
                {
                    DataSet ds = new DataSet();
                    adaptor.Fill(ds);
                    Excel_UserInfo = ds.Tables[0];
                }
            }
            finally
            {
                fileInfo.Delete();
            }