先需要在dataGridView1 中添加与EXCLE中对应的列(复制的列数),
try
{
string pasteText = Clipboard.GetText();
if (string.IsNullOrEmpty(pasteText))
{
return;
}
string[] lines = pasteText.Split(new char[]
{
‘\n’,
‘\r’
}, StringSplitOptions.RemoveEmptyEntries);
string[] array = lines;
for (int i = 0; i < array.Length; i++)
{
string line = array[i];
string[] strs = line.Split(new char[]
{
‘\t’
});
this.dataGridView1.Rows.Add(strs);
}
Clipboard.Clear();
}
catch(Exception ex)
{
MessageBox.Show(ex.Message);
}
excel表格复制粘贴WinFrom DataGridView
最新推荐文章于 2023-08-28 18:18:34 发布