Paste from DataGridview into Excel

Question

Hi folks,

I have a datagridView in my WInforms App. It can contain thousands of rows.

I am looking for a quick way of copying the cells from the datagridView into an Excel Worksheet. When I try and do it cell by cell programmatically, it takes forever. But when I copy the cells from the datagridview using the Ctrl=C and just paste (Ctrl+V) into the worksheet it just takes a sec.

Is there a way I can simulate the above using code?

ie

When I press a form button, I want to

1. Select all the rows in the grid (should be easy enough),
2. Simulate a Ctrl+C keypress.
3. Open up a Excel Worksheet (using the Microsoft.Office.Interop.Excel.Application),
4. Select a target cell and simulate Ctrl+V

Thanks,

John

Answer 1

Hi again,

I managed to get a solution....

// Select All Rows in grid
grid.SelectAll();

// Get the selected rows from the grid
var contents = grid.GetClipboardContent();

// Copy selected rows into clipboard
Clipboard.SetDataObject(contents);

// Set starting cell on Excel worksheet
Microsoft.Office.Interop.Excel.Range targetRange = sh.Cells[2, 1];

// Paste into target cell
sh.Paste(targetRange);

Answer 2

Select all the data, get the clipboard content and then set the clipboard.

grid.SelectAll();
var contents = grid.GetClipboardContent();
Clipboard.SetDataObject(contents);