wpf中将数据导出为Excel

Microsoft.Office.Interop.Excel.Application excelApp = new Microsoft.Office.Interop.Excel.Application();

     try
        {
          excelApp.Visible = false;

          //Cria Planilha
          Workbook excelWB = excelApp.Workbooks.Add(System.Type.Missing);

          //Cria Worksheet
          Worksheet excelWS = (Worksheet)excelWB.Worksheets[1];

          Range celulas = null;
          celulas = excelWS.get_Range("A1", System.Type.Missing);
         
          //Laço para ler todas as linhas e colunas do grid
          for (int i = 0; i < ((System.Data.DataTable)(dataGrid2.DataContext)).Rows.Count; i++)
          {
            for (int j = 0; j < ((System.Data.DataTable)(dataGrid2.DataContext)).Columns.Count; j++)
            {
              //Insere valores das células do grid na célula do excel
              celulas.get_Offset(i, j).Cells.Value2 = ((System.Data.DataTable)(dataGrid2.DataContext)).Rows[i][j].ToString();
            }
          }

          excelApp.ActiveWorkbook.RefreshAll();
          excelApp.Workbooks.Application.ActiveWorkbook.RefreshAll();

          //Salva Arquivo
          excelWB.SaveAs(txtArmazenagem.Text + "//" + txtNomeArquivoArmazenagem.Text + ".xls", XlSaveAction.xlSaveChanges, System.Type.Missing, System.Type.Missing, false, false, XlSaveAsAccessMode.xlNoChange, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing, System.Type.Missing);
          excelWB.Close(false, null, null);
        }
        catch (Exception ex)
        {
          MessageBoxResult result = MessageBox.Show(ex.Message);
          //throw ex;
        }
        finally
        {
          excelApp.Quit();
          MessageBoxResult result = MessageBox.Show("Exportação concluida com sucesso.");
          txtArmazenagem.Text = "";
          txtNomeArquivoArmazenagem.Text = "";
          dataGrid2.DataContext = null;
        }

posted @ 2011-05-11 19:04  liancs  阅读(1979)  评论(0编辑  收藏  举报