How to export dataGridView data Instantly to Excel on button click?

by

I solved this by simple copy and paste method. I don’t know it is the best way to do this but,for me it works good and almost instantaneously. Here is my code.

    private void copyAlltoClipboard()
    {
        dataGridView1.SelectAll();
        DataObject dataObj = dataGridView1.GetClipboardContent();
        if (dataObj != null)
            Clipboard.SetDataObject(dataObj);
    }
    private void button3_Click_1(object sender, EventArgs e)
    {
        copyAlltoClipboard();
        Microsoft.Office.Interop.Excel.Application xlexcel;
        Microsoft.Office.Interop.Excel.Workbook xlWorkBook;
        Microsoft.Office.Interop.Excel.Worksheet xlWorkSheet;
        object misValue = System.Reflection.Missing.Value;
        xlexcel = new Excel.Application();
        xlexcel.Visible = true;
        xlWorkBook = xlexcel.Workbooks.Add(misValue);
        xlWorkSheet = (Excel.Worksheet)xlWorkBook.Worksheets.get_Item(1);
        Excel.Range CR = (Excel.Range)xlWorkSheet.Cells[1, 1];
        CR.Select();
        xlWorkSheet.PasteSpecial(CR, Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing, true);          
    }

Thanks.

More Related Contents:

  1. Null Reference Exception when int parsing DataGridView row values
  2. Download Excel file via AJAX MVC
  3. Filtering DataGridView without changing datasource
  4. Copy the entire contents of a directory in C#
  5. C# Using Reflection to copy base class properties
  6. Format an Excel column (or cell) as Text in C#?
  7. List vs BindingList Advantages/DisAdvantages
  8. Export the dataGridView to Excel with all the cells format
  9. how I can show the sum of in a datagridview column?
  10. When is a C# value/object copied and when is its reference copied?
  11. C# DataGridView Checkbox checked event
  12. How to sort databound DataGridView column?
  13. Index of Currently Selected Row in DataGridView
  14. Show row number in row header of a DataGridView
  15. How to use textbox to search data in data grid view?
  16. Search for value in DataGridView in a column
  17. Adding Text to DataGridView Row Header
  18. Show Loading animation during loading data in other thread
  19. Programmatically add new column to DataGridView
  20. How do I implement automatic sorting of DataGridView?
  21. DataGridView with Button Control – Delete Row
  22. How do you automatically resize columns in a DataGridView control AND allow the user to resize the columns on that same grid?
  23. DataGridView AutoFit and Fill
  24. How do I change the datagridview selected row background color?
  25. Index was out of range. Must be non-negative and less than the size of the collection parameter name:index
  26. how to sort string as number in datagridview in winforms
  27. How to enable DataGridView sorting when user clicks on the column header?
  28. How to refresh datagridview when closing child form?
  29. DataGridView Image for Button Column
  30. Is it possible to switch rows and columns in a datagridview?

Leave a Comment