如何将Excel中的内容复制到DataGridView 在WinForm中有一个DataGridView控件,现在我想从Excel中选种部分内容,复制,粘贴到Form中的DataGridView中,怎么实现呀,希望能有代码,呵呵,高手指点下,谢谢了。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 我提供一个思路吧:1,你先出excel 读出数据到dataset2,再把dataset绑定到dataGridView就可以了! 这种可以实现导入的功能,我想到的是直接粘贴到DataGridView中。应该要用到剪贴板,但是不知道具体怎么用。 Excel使用Windows粘贴板// Copy a string to the Windows clipboard.string sData = "FirstName\tLastName\tBirthdate\r\n" + "Bill\tBrown\t2/5/85\r\n" + "Joe\tThomas\t1/1/91";System.Windows.Forms.Clipboard.SetDataObject(sData);// Start a new workbook in Excel.m_objExcel = new Excel.Application();m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));// Paste the data starting at cell A1.m_objSheets = (Excel.Sheets)m_objBook.Worksheets;m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));m_objRange = m_objSheet.get_Range("A1", m_objOpt);m_objSheet.Paste(m_objRange, false);// Save the workbook and quit Excel.m_objBook.SaveAs(m_strSampleFolder + "Book5.xls", m_objOpt, m_objOpt, m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange, m_objOpt, m_objOpt, m_objOpt, m_objOpt);m_objBook.Close(false, m_objOpt, m_objOpt);m_objExcel.Quit(); NBC razor传用户的输入值 如何弹消息框 C#程序生成失败问题 winform程序问题,高手来 怎么样高效率汇总具有海量文本中的关键字数量? C#操作Excel的郁闷问题 DataGridView 编辑回写数据库 ActiveDirectory和DHCP的使用 comboBox添加"请选择" 这段VB.net代码用C#怎么写? GridView显示满足条件的记录集,当条件变化时GridView怎样刷新以反应变化? Process
1,你先出excel 读出数据到dataset
2,再把dataset绑定到dataGridView就可以了!
string sData = "FirstName\tLastName\tBirthdate\r\n" +
"Bill\tBrown\t2/5/85\r\n" +
"Joe\tThomas\t1/1/91";
System.Windows.Forms.Clipboard.SetDataObject(sData);// Start a new workbook in Excel.
m_objExcel = new Excel.Application();
m_objBooks = (Excel.Workbooks)m_objExcel.Workbooks;
m_objBook = (Excel._Workbook)(m_objBooks.Add(m_objOpt));// Paste the data starting at cell A1.
m_objSheets = (Excel.Sheets)m_objBook.Worksheets;
m_objSheet = (Excel._Worksheet)(m_objSheets.get_Item(1));
m_objRange = m_objSheet.get_Range("A1", m_objOpt);
m_objSheet.Paste(m_objRange, false);// Save the workbook and quit Excel.
m_objBook.SaveAs(m_strSampleFolder + "Book5.xls", m_objOpt, m_objOpt,
m_objOpt, m_objOpt, m_objOpt, Excel.XlSaveAsAccessMode.xlNoChange, m_objOpt, m_objOpt,
m_objOpt, m_objOpt);
m_objBook.Close(false, m_objOpt, m_objOpt);
m_objExcel.Quit();