listView数据显示到Excel中

最新推荐文章于 2018-01-16 15:29:50 发布

hehuanhehuan

最新推荐文章于 2018-01-16 15:29:50 发布

阅读量860

点赞数

分类专栏： C#源码文章标签： listview excel object exception string null

本文链接：https://blog.csdn.net/hehuanhehuan/article/details/2511306

版权

C#源码专栏收录该内容

1 篇文章 0 订阅

订阅专栏

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using ExcelApplication = Microsoft.Office.Interop.Excel.Application;
using System.Reflection;

namespace UseingExcel
{
    class ViewinExcel
    {
        public void TurnToExcel(ListView listView,string stname)
        {
            string Sheetname = stname;
                ListView listView1 = listView;
            if (listView1.Items.Count < 1)
                return;
            try
            {
                ExcelApplication MyExcel = new ExcelApplication();
                MyExcel.Visible = true;
                if (MyExcel == null)
                {

return;
}

Workbooks MyWorkBooks = (Workbooks)MyExcel.Workbooks;

Workbook MyWorkBook = (Workbook)MyWorkBooks.Add(Missing.Value);

Worksheet MyWorkSheet = (Worksheet)MyWorkBook.Worksheets[1];

                Range MyRange = MyWorkSheet.get_Range("A1","H1");
                MyRange = MyRange.get_Resize(1, listView1.Columns.Count);
                object[] MyHeader = new object[listView1.Columns.Count];
                for (int i = 0; i < listView1.Columns.Count; i++)
                {
                    MyHeader.SetValue(listView1.Columns[i].Text,i);
                }
                MyRange.Value2 = MyHeader;
                MyWorkSheet.Name = Sheetname;

                if (listView1.Items.Count > 0)
                {
                    MyRange = MyWorkSheet.get_Range("A2", Missing.Value);

                    object[,] MyData = new Object[listView1.Items.Count, listView1.Columns.Count];
                    for (int j = 0; j < listView1.Items.Count; j++)
                    {
                        ListViewItem lvi = listView.Items[j];
                        for (int k = 0; k < listView1.Columns.Count; k++)
                        {

                            MyData[j, k] = lvi.SubItems[k].Text;
                        }

                    }
                    MyRange = MyRange.get_Resize(listView1.Items.Count, listView1.Columns.Count);
                    MyRange.Value2 = MyData;
                    MyRange.EntireColumn.AutoFit();
                }
                MyExcel = null;
            }
            catch (Exception Err)
            {
                MessageBox.Show(Err.Message);
            }