//验证剪切板是否为空
if (string.IsNullOrEmpty(Clipboard.GetText().Trim()))
{
MessageBox.Show("剪切板为空!");
return;
}
//读取内容:
string copyText = System.Windows.Forms.Clipboard.GetText();
//把复制的Excel数据按没行截取,放到一个string数组里
string[] allRow = copyText.Trim().Split(new string[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries);
//添加数据到DataTable
for (int i = 0; i < allRow.Length; i++)
{
//把每行的数据按单元格截取,放到一个string数组里,第二个参数是不返回空字符
string[] content = allRow[i].Trim().Split(new string[] { "\t" }, StringSplitOptions.RemoveEmptyEntries);
//新增行
DataRowView dr = this.DtTable.DefaultView.AddNew();
//复制的数据列大于等于当前表格列
if (content.Length >= this.DtTable.Columns.Count)
{
for (int j = 0; j < this.DtTable.Columns.Count; j++)
{
dr[j] = content[j];
}
}
//赋值的数据列小于当前表格列
else if (content.Length < this.DtTable.Columns.Count)
{
for (int j = 0; j < content.Length; j++)
{
dr[j] = content[j];
}
}
dr.EndEdit();
}