listview 數(shù)據(jù)的導(dǎo)入和導(dǎo)出

1、此方法接收一個(gè)ListView將全部數(shù)據(jù)導(dǎo)入EXCELpublicvoidOperateExcel(ListViewliststringtext)text為些Excel的標(biāo)題Excel.Applicationss=newExcel.Application()開(kāi)啟Excelss.Application.Wkbooks.Add(true)ss.Visible=truess.Cells[14]=textf(intx=1x=list.Colum

2、ns.Countx)ss.Rows.Cells[2x]=list.Columns[x1].Textf(inti=3i=list.Items.Count2i)f(intj=1j=list.Columns.Countj)ss.Rows.Cells[ij]=list.Items[i3].SubItems[j1].Text““此方法接收一個(gè)ListView將其中選中數(shù)據(jù)導(dǎo)入EXCELpublicvoidOperatePostExcel(List

3、Viewliststringtext)Excel.Applicationss=newExcel.Application()ss.Application.Wkbooks.Add(true)ss.Visible=truess.Cells[14]=textExcel.Wksheetsheet=(Excel.Wksheet)wksheets.get_Item(1)excel.Visible=trueExcel.Rangerangeexcel.C

4、ells.()excel.Cells.RowHeight=30excel.Cells.Font.Size=10excel.Cells.HizontalAlignment=Excel.XlHAlign.xlHAlignCenterintrowPos=2range=excel.get_Range(sheet.Cells[rowPos1]sheet.Cells[rowPos1])range.()f(inti=1i=lst.Columns.Co

5、unti)range=excel.get_Range(sheet.Cells[rowPosi]sheet.Cells[rowPosi])range.Bders.LineStyle=1range.Font.Name=“華文仿宋“range.Font.Size=16range.Font.Bold=truerange.HizontalAlignment=Excel.XlHAlign.xlHAlignCenterrange.ColumnWidt

6、h=18sheet.Cells[rowPosi]=listviewname.Columns[i1].Text.ToString()rowPosfeach(ListViewItemiteminlistviewname.Items)f(inti=1i=listviewname.Columns.Counti)range=excel.get_Range(sheet.Cells[rowPosi]sheet.Cells[rowPosi])range

7、.Bders.LineStyle=1range.Font.Name=“華文仿宋“range.Font.Size=12range.HizontalAlignment=Excel.XlHAlign.xlHAlignCenterrange.NumberFmat=Excel.XlParameterDataType.xlParamTypeUnknownsheet.Cells[rowPosi]=item.SubItems[i1].TextrowPo