C#listview导出到excel

不好次啊

于 2024-02-23 13:31:49 发布

阅读量433

点赞数 9

文章标签： c# excel

本文链接：https://blog.csdn.net/apparition_/article/details/136253889

版权

public void ExportExcel(ListView lv, string fileName)
{
int rowNum = lv.Items.Count;
if (rowNum == 0 || string.IsNullOrEmpty(fileName))
{
return;
}
int column = lv.Items[0].SubItems.Count;
int rowIndex = 1;
int columnIndex = 0;

        if (rowNum > 0)
        {
            Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
            if (xlApp == null)
            {
                MessageBox.Show("无法创建excel");
                return;
            }
            //保存路径
            xlApp.DefaultFilePath = formApplication.StartupPath;  
            xlApp.DisplayAlerts = true;
            xlApp.SheetsInNewWorkbook = 1;
            Microsoft.Office.Interop.Excel.Workbook xlBook = xlApp.Workbooks.Add(true);
            //将ListView的列名导入Excel表的第一行
            foreach (ColumnHeader dc in lv.Columns)
            {
                columnIndex++;
                xlApp.Cells[rowIndex, columnIndex] = dc.Text;
            }
            //将ListView中的数据导入到Excel中
            for (rowIndex = 2; rowIndex < lv.Items.Count + 2; rowIndex++)
            {
                xlApp.Cells[rowIndex, 1] = lv.Items[rowIndex - 2].Text;
                for (columnIndex = 2; columnIndex <= lv.Columns.Count; columnIndex++)
                {
                    xlApp.Cells[rowIndex, columnIndex] = lv.Items[rowIndex - 2].SubItems[columnIndex - 1].Text;
                }
            }
            //例外需要说明的是用strFileName,Excel.XlFileFormat.xlExcel9795保存方式时 当你的Excel版本不是95、97 而是2003、2007 时导出的时候会报一个错误：异常来自 HRESULT:0x800A03EC。 解决办法就是换成strFileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal。 
            xlBook.SaveAs(fileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlShared, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
            
            //释放com对象以完全终止excel进程在后台的运行
            xlBook.Close(true, Type.Missing, Type.Missing);
            Marshal.ReleaseComObject(xlBook); //释放
            xlApp.DisplayAlerts = false;
            xlApp.AlertBeforeOverwriting = false;
            xlApp.Quit();
            Marshal.ReleaseComObject(xlApp);  //释放
            MessageBox.Show("导出成功！");
        }
    }