62,046
社区成员
发帖
与我相关
我的任务
分享
// database
Excel.Worksheet workSheet2 = m_workBook.Worksheets.get_Item("database");
if (workSheet2 == null)
{
throw new Exception("WorkBook.WorkSheets.get_Item('database') failed!");
}
for (int row = 2; row < 2+nRow; row++)
{
dynamic dy1 = workSheet2.Cells[row, 1].Value;
dynamic dy2 = workSheet2.Cells[row, 2].Value;
dynamic dy3 = workSheet2.Cells[row, 3].Value;
dynamic dy4 = workSheet2.Cells[row, 4].Value;
dynamic dy5 = workSheet2.Cells[row, 5].Value;
CGuidanceOne gd1 = new CGuidanceOne();
gd1.Title = (dy1 == null) ? "" : dy1.ToString();
gd1.Intro = (dy2 == null) ? "" : dy2.ToString();
gd1.Date = (dy3 == null) ? "" : dy3.ToString();
gd1.Source = (dy4 == null) ? "" : dy4.ToString();
gd1.Src = (dy5 == null) ? "" : dy5.ToString();
m_lstGuidance.Add(gd1);
}