excel 内容粘贴到datagridview
时间:2010-10-12 来源:abenz
private void Form1_Load(object sender, EventArgs e)
{
dataGridView1.Columns.Add("FIELD_NAME", "字段名");
dataGridView1.Columns.Add("FIELD_DESC", "字段描述");
dataGridView1.Columns.Add("FIELD_TYPE", "字段类型");
dataGridView1.Columns.Add("FIELD_LEN", "长度");
}
private void ToolStripMenuItem_Click(object sender, EventArgs e)
{
try
{
string pasteText = Clipboard.GetText();
if (string.IsNullOrEmpty(pasteText))
{
return;
}
string[] lines = pasteText.Split(new char[] { '\n', '\r' }, StringSplitOptions.RemoveEmptyEntries);
foreach (string line in lines)
{
string[] vals = line.Split(new char[] { '\t' });
dataGridView1.Rows.Add(vals);
}
}
catch
{
//
}
}