ListView 到 Excel

最新推荐文章于 2015-11-27 11:18:00 发布

原创最新推荐文章于 2015-11-27 11:18:00 发布 · 833 阅读

1 ·

CC 4.0 BY-SA版权

C# 专栏收录该内容

20 篇文章

订阅专栏

本文介绍了一种使用C#将ListView中的数据导出到Excel文件的方法。该过程涉及创建Excel应用程序对象，设置不可见属性以避免干扰用户工作，并将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;
｝