L'exportation datagridview en document word c#

Vous pouvez essayer ma nouvelle méthode pour exporter des données au format Word (*.docx) , il est facile à utiliser et fonctionne à 100% avec tout DataGridView , il suffit d'ajouter Microsoft.Bureau de.Interop.Mot de référence et de copier le code suivant :

       using Word = Microsoft.Office.Interop.Word;
public void Export_Data_To_Word(DataGridView DGV, string filename)
{
if (DGV.Rows.Count != 0)
{
int RowCount = DGV.Rows.Count;
int ColumnCount = DGV.Columns.Count;
Object[,] DataArray = new object[RowCount + 1, ColumnCount + 1];
//add rows
int r = 0;
for (int c = 0; c <= ColumnCount - 1; c++)
{
for (r = 0; r <= RowCount - 1; r++)
{
DataArray[r, c] = DGV.Rows[r].Cells[c].Value;
} //end row loop
} //end column loop
Word.Document oDoc = new Word.Document();
oDoc.Application.Visible = true;
//page orintation
oDoc.PageSetup.Orientation = Word.WdOrientation.wdOrientLandscape;
dynamic oRange = oDoc.Content.Application.Selection.Range;
string oTemp = "";
for (r = 0; r <= RowCount - 1; r++)
{
for (int c = 0; c <= ColumnCount - 1; c++)
{
oTemp = oTemp + DataArray[r, c] + "\t";
}
}
//table format
oRange.Text = oTemp;
object Separator = Word.WdTableFieldSeparator.wdSeparateByTabs;
object ApplyBorders = true;
object AutoFit = true;
object AutoFitBehavior = Word.WdAutoFitBehavior.wdAutoFitContent;
oRange.ConvertToTable(ref Separator, ref RowCount, ref ColumnCount,
Type.Missing, Type.Missing, ref ApplyBorders,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing, Type.Missing, Type.Missing,
Type.Missing, ref AutoFit, ref AutoFitBehavior, Type.Missing);
oRange.Select();
oDoc.Application.Selection.Tables[1].Select();
oDoc.Application.Selection.Tables[1].Rows.AllowBreakAcrossPages = 0;
oDoc.Application.Selection.Tables[1].Rows.Alignment = 0;
oDoc.Application.Selection.Tables[1].Rows[1].Select();
oDoc.Application.Selection.InsertRowsAbove(1);
oDoc.Application.Selection.Tables[1].Rows[1].Select();
//header row style
oDoc.Application.Selection.Tables[1].Rows[1].Range.Bold = 1;
oDoc.Application.Selection.Tables[1].Rows[1].Range.Font.Name = "Tahoma";
oDoc.Application.Selection.Tables[1].Rows[1].Range.Font.Size = 14;
//add header row manually
for (int c = 0; c <= ColumnCount - 1; c++)
{
oDoc.Application.Selection.Tables[1].Cell(1, c + 1).Range.Text = DGV.Columns[c].HeaderText;
}
//table style 
oDoc.Application.Selection.Tables[1].set_Style("Grid Table 4 - Accent 5");
oDoc.Application.Selection.Tables[1].Rows[1].Select();
oDoc.Application.Selection.Cells.VerticalAlignment = Word.WdCellVerticalAlignment.wdCellAlignVerticalCenter;
//header text
foreach (Word.Section section in oDoc.Application.ActiveDocument.Sections)
{
Word.Range headerRange = section.Headers[Word.WdHeaderFooterIndex.wdHeaderFooterPrimary].Range;
headerRange.Fields.Add(headerRange, Word.WdFieldType.wdFieldPage);
headerRange.Text = "your header text";
headerRange.Font.Size = 16;
headerRange.ParagraphFormat.Alignment = Word.WdParagraphAlignment.wdAlignParagraphCenter;
}
//save the file
oDoc.SaveAs2(filename);
//NASSIM LOUCHANI
}  
}
private void button_Click(object sender, EventArgs e)
{
SaveFileDialog sfd = new SaveFileDialog();
sfd.Filter = "Word Documents (*.docx)|*.docx";
sfd.FileName = "export.docx";
if (sfd.ShowDialog() == DialogResult.OK)
{
Export_Data_To_Word(dataGridView1, sfd.FileName); 
}
}

Ce code pour l'exportation gridview données

namespace WindowsFormsApplication1
{
using System;
using System.IO;
using System.Reflection;
using System.Runtime.InteropServices;
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
using Application = Microsoft.Office.Interop.Excel.Application;
public partial class Form1 : Form
{
private Application xlExcel;
private Workbook xlWorkBook;
public Form1()
{
this.InitializeComponent();
}
private void btnExport_Click(object sender, EventArgs e)
{
try
{
this.QuitExcel();
this.xlExcel = new Application { Visible = false };
this.xlWorkBook = this.xlExcel.Workbooks.Add(Missing.Value);
//Copy contents of grid into clipboard, open new instance of excel, a new workbook and sheet,
//paste clipboard contents into new sheet.
this.CopyGrid();
var xlWorkSheet = (Worksheet)this.xlWorkBook.Worksheets.Item[1];
try
{
var cr = (Range)xlWorkSheet.Cells[1, 1];
try
{
cr.Select();
xlWorkSheet.PasteSpecial(cr, NoHTMLFormatting: true);
}
finally
{
Marshal.ReleaseComObject(cr);
}
this.xlWorkBook.SaveAs(Path.Combine(Path.GetTempPath(), "ItemUpdate.xls"), XlFileFormat.xlExcel5);
}
finally
{
Marshal.ReleaseComObject(xlWorkSheet);
}
MessageBox.Show("File Save Successful", "Information", MessageBoxButtons.OK);
//If box is checked, show the exported file. Otherwise quit Excel.
if (this.checkBox1.Checked)
{
this.xlExcel.Visible = true;
}
else
{
this.QuitExcel();
}
}
catch (SystemException ex)
{
MessageBox.Show(ex.ToString());
}
//Set the Selection Mode back to Cell Select to avoid conflict with sorting mode.
this.dataGridView1.SelectionMode = DataGridViewSelectionMode.CellSelect;
}
private void Form1_FormClosed(object sender, FormClosedEventArgs e)
{
this.QuitExcel();
}
private void QuitExcel()
{
if (this.xlWorkBook != null)
{
try
{
this.xlWorkBook.Close();
Marshal.ReleaseComObject(this.xlWorkBook);
}
catch (COMException)
{
}
this.xlWorkBook = null;
}
if (this.xlExcel != null)
{
try
{
this.xlExcel.Quit();
Marshal.ReleaseComObject(this.xlExcel);
}
catch (COMException)
{
}
this.xlExcel = null;
}
}
private void CopyGrid()
{
//I'm making this up...
this.dataGridView1.SelectAll();
var data = this.dataGridView1.GetClipboardContent();
if (data != null)
{
Clipboard.SetDataObject(data, true);
}
}
}
}

Essayer cette lien

et cela aussi