本示例是用于將listview中的內(nèi)容倒入到excel
與常用的逐單元格寫不同的是，本例子采用數(shù)據(jù)寫入到range的方法。該方法效率明顯較高
excel.application app = new excel.applicationclass();
if( app == null)
{
messagebox.show("excel無法啟動(dòng)");
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 = {"標(biāo)題1","標(biāo)題2","標(biāo)題3",
"標(biāo)題4","標(biāo)題5","標(biāo)題6",
"標(biāo)題7","標(biāo)題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;
本文來源于網(wǎng)頁設(shè)計(jì)愛好者web開發(fā)社區(qū)http://www.html.org.cn收集整理，歡迎訪問。
