DateTime))
{
cell.SetCellValue((DateTime)obj);
}
else if (obj.GetType() == typeof...cell.SetCellValue(obj.ToString());
}
}
cell.SetCellValue()方法只有四种重载方法,参数分别是string, bool, DateTime.../256个字符
sheet.SetColumnWidth(i, 256 * columnWidth[i]);
}
//测试数据
int rowCount = 3,...columnCount = 4;
object[,] data = {
{"列0", "列1", "列2", "列3"},
{"", 400, 5.2, 6.01...},
{"", true, "2014-07-02", DateTime.Now}
//日期可以直接传字符串,NPOI会自动识别
//如果是DateTime