求C#大神帮忙,npoi创建后写入显示空值，数据库没问题

private void button1_Click(object sender, EventArgs e)

{
string constr = @"server=PC-20150913KMBW;uid=sa;pwd=sa;database=dlDB";
using (SqlConnection con = new SqlConnection(constr))
{
using (SqlCommand com = new SqlCommand("select Name,Sex from student1", con))
{
con.Open();
using (SqlDataReader dr = com.ExecuteReader())
{
if (dr.HasRows)
{
using (Workbook wk = new NPOI.HSSF.UserModel.HSSFWorkbook())
{
using (Sheet sheet = wk.CreateSheet("T_Seats"))
{
int rowIndex = 0;
while (dr.Read())
{
Row row = sheet.CreateRow(rowIndex);
for (int i = 0; i < dr.FieldCount; i++)
{
Cell cell = row.CreateCell(i);
cell.SetCellValue(dr.GetValue(i).ToString());
}
rowIndex++;
}
}

using (FileStream fs = File.OpenWrite(@"D:\123.txt"))
{
wk.Write(fs);
}
}
MessageBox.Show("数据导出成功");
}
else
{
MessageBox.Show("表中没有数据!");
}

wk.Write(fs) 运行提示 未将对象引用到设置实例

看看wk的几个属性，在Write之前先看看wk里表的个数。
MessageBox.Show( wk.NumberOfSheets.ToString());

支持一下感觉挺不错的