Winfrom ListView 导出Ecel

最新推荐文章于 2025-08-22 08:42:02 发布

deepwishly

最新推荐文章于 2025-08-22 08:42:02 发布

阅读量680

点赞数

CC 4.0 BY-SA版权

文章标签： listview excel string list

本文链接：https://blog.youkuaiyun.com/deepwishly/article/details/5380112

本文介绍了一种方法，能够将ListView中的数据批量或者选择性地导出到Excel文件中。该方法通过调用Microsoft Office Interop Excel组件实现，并详细展示了如何设置Excel的工作表标题、列名以及单元格数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

        //接收一个ListView将全部数据导入EXCEL
        public void OperateExcel(ListView list, string text)
        {
            btnTotalExcel.Enabled = false;
            //text为些Excel的标题
            Microsoft.Office.Interop.Excel.Application ss = new Microsoft.Office.Interop.Excel.Application();//开启Excel
            ss.Application.Workbooks.Add(true);
            ss.Visible = true;
            ss.Cells[1, 4] = text;
            for (int x = 1; x <= list.Columns.Count; x++)
            {

                ss.Rows.Cells[2, x] = list.Columns[x - 1].Text;
            }
            for (int i = 3; i <= list.Items.Count + 2; i++)
            {
                for (int j = 1; j <= list.Columns.Count; j++)
                {
                    ss.Rows.Cells[i, j] = list.Items[i - 3].SubItems[j - 1].Text + ",";
                }
            }
            btnTotalExcel.Enabled = true;
        }
        //接收一个ListView将其中选中数据导入EXCEL
        public void OperatePostExcel(ListView list, string text)
        {
            btnPartExel.Enabled = false;
            Microsoft.Office.Interop.Excel.Application ss = new Microsoft.Office.Interop.Excel.Application();
            ss.Application.Workbooks.Add(true);
            ss.Visible = true;
            ss.Cells[1, 4] = text;
            for (int x = 1; x <= list.Columns.Count; x++)
            {
                ss.Rows.Cells[2, x] = list.Columns[x - 1].Text;
            }
            for (int i = 3; i <= list.SelectedItems.Count + 2; i++)
            {
                for (int j = 1; j <= list.Columns.Count; j++)
                {