用C#快速往Excel写数据-.NET教程,C#语言

本示例是用于将listview中的内容倒入到excel

与常用的逐单元格写不同的是，本例子采用数据写入到range的方法。该方法效率明显较高

excel.application app = new excel.applicationclass();

if( app == null)

{

messagebox.show("excel无法启动");

return;

}

app.visible = true;

excel.workbooks wbs = app.workbooks;

excel.workbook wb = wbs.add(missing.value);

excel.worksheet ws = (excel.worksheet)wb.worksheets[1];

excel.range r = ws.get_range("a1","h1");

object [] objheader = {"标题1","标题2","标题3",

"标题4","标题5","标题6",

"标题7","标题8"};

r.value = objheader;

if (lv.items.count >0)

{

r = ws.get_range("a2",missing.value);

object [,] objdata = new object[this.lv.items.count,8];

foreach(listviewitem lvi in lv.items)

{

objdata[lvi.index,0] = lvi.text;

objdata[lvi.index,1] = lvi.subitems[1].text;

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;