110,539
社区成员
发帖
与我相关
我的任务
分享
singers.Add(singer.Stunumber,singer);//把每条记录加载到 singers
//你在foreach里面使用i++感觉好别扭
for (int j = 0 ; j < singers.Values.Count(), j++)
{
Basis oneL = singers.Values[i];
int i = j + 3;
//遍历dictionary
ws.Cells[i, 1] = oneL.Stunumber;
ws.Columns.AutoFit();//自动调整宽度
ws.Cells[i, 2] = oneL.Stuname;
ws.Columns.AutoFit();
ws.Cells[i, 3] = oneL.Idcard;
ws.Columns.AutoFit();
ws.Cells[i, 4] = oneL.Sex;
ws.Columns.AutoFit();
ws.Cells[i, 5] = oneL.Birthrate;
ws.Columns.AutoFit();
ws.Cells[i, 6] = oneL.Nation;
ws.Columns.AutoFit();
ws.Cells[i, 7] = oneL.Handsetnumber;
ws.Columns.AutoFit();
ws.Cells[i, 8] = oneL.QQ;
ws.Columns.AutoFit();
ws.Cells[i, 9] = oneL.Bedchamber;
ws.Columns.AutoFit();
ws.Cells[i, 10] = oneL.Houseaddress;
ws.Columns.AutoFit();
ws.Cells[i, 11] = i.ToString();
i++;//行数增加
}