ListView 到 Excel

     using System.Reflection;Function（）｛           Excel.Application app = new Excel.Application();            if (app == null)            {                MessageBox.Show("Failed to Load Excel,Please Ensure Excel Is Installed ！", "！Excel Error");                return;            }            app.Visible = false;            Excel.Workbooks wbs = app.Workbooks;            Excel.Workbook wb = wbs.Add(Excel.XlWBATemplate.xlWBATWorksheet);            Excel.Worksheet ws = (Excel.Worksheet)wb.Worksheets[1];            Excel.Range r = ws.get_Range("A1", "M1");            //-----------------------------header---------------------------------------------------            object[] objHeader = new object[this.listView1.Columns.Count];            //------------------------write list items to excel--------------------------------------            r.Value2 = objHeader;            if (listView1.Items.Count > 0)            {                r = ws.get_Range("A1", Missing.Value);                object[,] objData = new Object[this.listView1.Items.Count, listView1.Columns.Count];                foreach (ListViewItem lvi in listView1.Items)                {                    objData[lvi.Index, 0] = lvi.Text;                    for (int i = 1; i < listView1.Columns.Count; i++)                    {                        if (i >= lvi.SubItems.Count)                            objData[lvi.Index, i] = "";                        else                            objData[lvi.Index, i] = lvi.SubItems[i].Text;                    }                }//end foreach                r = r.get_Resize(listView1.Items.Count, listView1.Columns.Count);                r.Value2 = objData;                r.EntireColumn.AutoFit();            }//end if            app.Visible = true;｝