//粘贴按钮的代码
private void btnPast_Click(object sender, EventArgs e)
{
//past from clipboad
try
{
string[] itemRow = Regex.Split(Clipboard.GetText(), Environment.NewLine); //Excel 的每行以回车键分开
foreach (var item in itemRow .AsEnumerable ().Where ((o)=>o.Trim().Length >0))
{
dgvImport.Rows.Add(Regex.Split(Convert.ToString(item), @"\t")); //每一个单元格以 tab键分开
}
}
catch (Exception ex)
{
throw ex;
}
}
C#将Excel文件中选择的内容,复制粘贴到 winform datagridview
最新推荐文章于 2023-08-26 18:59:54 发布