ListView中的数据表格写入Excel中

    SaveFileDialog sfd = new SaveFileDialog();

    sfd.DefaultExt = "xls";

    sfd.Filter = "Excel文?件t(*.xls)|*.xls";

   if (sfd.ShowDialog() == DialogResult.OK)

    {

     DoExport(this.listView1, sfd.FileName);

   }

    private void DoExport(ListView listView, string strFileName)

    {

         int rowNum = listView.Items.Count;

       int columnNum = 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.ApplicationClass();

    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;

    }

    for (int i = 0; i < rowNum; i++)

  {

     rowIndex++;

     columnIndex = 0;

     for (int j = 0; j < columnNum; j++)

    {

        columnIndex++;

          //注意这个在导出的时候加了"\t"的目的是避免导出的数据显示为科学计数法,可以放在每行的首尾

           xlApp.Cells[rowIndex, columnIndex] = Convert.ToString(listView.Items[i].SubItems[j].Text) + "\t";

       }

    }

    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.Close();

    xlBook = null;

   MessageBox.Show("OK");

   }

   }

上一篇:Gridview中的数据导出到excel中


下一篇:photoshop合成制作出美女梦见白鹤送子的场景