private void MsgExportData()
{
System.Windows.Forms.SaveFileDialog sfd = new SaveFileDialog();
sfd.DefaultExt = "xlsx";
sfd.Filter = "Excel文件(*.xlsx)|*.xlsx";
if (sfd.ShowDialog() == DialogResult.OK)
{
ExcelExport(listView1,sfd.FileName);
}
}
//导出方法
public void ExcelExport(ListView listview, string strFileName)
{
int rowNum = listview.Items.Count;
int column = listview.Items[0].SubItems.Count;
int rowIndex = 1;
int columnIndex = 0;
if (rowNum == 0 || string.IsNullOrEmpty(strFileName))
{
return;
}
if (rowNum > 0)
{
Microsoft.Office.Interop.Excel.Application xlApp = new Microsoft.Office.Interop.Excel.Application();
if (xlApp == null)
{
MessageBox.Show("无法创建excel,请检查是否安装Excel");
return;
}
xlApp.DefaultFilePath = "";
xlApp.DisplayAlerts = true;
xlApp.SheetsInNewWorkbook = 1;
Microsoft.Office.Interop.Excel.Workbook xlBook = xlApp.Workbooks.Add(true);
//将ListView的列名导入Excel表的第一行
foreach (ColumnHeader dc in listview.Columns)
{
columnIndex++;
xlApp.Cells[rowIndex, columnIndex] = dc.Text;
}
//将ListView中的数据导入到Excel中
for (rowIndex = 2; rowIndex < listview.Items.Count + 2; rowIndex++)
{
xlApp.Cells[rowIndex, 1] = listview.Items[rowIndex - 2].Text;
for (columnIndex = 2; columnIndex <= listview.Columns.Count; columnIndex++)
{
xlApp.Cells[rowIndex, columnIndex] = listview.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(strFileName, Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlExclusive, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing);
xlApp = null;
xlBook = null;
MessageBox.Show("导出成功!");
}
}
C# ListView 数据导出到Excel
最新推荐文章于 2024-02-23 13:31:49 发布