用C#快速往Excel写数据

objData[lvi.Index,2] = lvi.SubItems[2].Text;

objData[lvi.Index,3] = lvi.SubItems[3].Text;

objData[lvi.Index,4] = lvi.SubItems[4].Text;

objData[lvi.Index,5] = lvi.SubItems[5].Text;

objData[lvi.Index,6] = lvi.SubItems[6].Text;

objData[lvi.Index,7] = lvi.SubItems[7].Text;

}

r = r.get_Resize(lv.Items.Count,8);

r.Value = objData;

r.EntireColumn.AutoFit();

}

app = null;