Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- 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);
- }
Advertisement
Add Comment
Please, Sign In to add comment