myxls很好用，最近做项目发现myxls导出EXCLE的解释很多而如何将excel导入到winform中dataview或者listview中的介绍很少，研究了2天。写点代码给大家分享下
private void button1_Click(object sender, EventArgs e)
{
System.Windows.Forms.OpenFileDialog ofd = new OpenFileDialog();
if (ofd.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
textBoxReadFile.Text = ofd.FileName;
button1_Click(null, null);
}
}
private void button2_Click(object sender, EventArgs e)
{
string fileName = textBoxReadFile.Text;
if (!File.Exists(fileName))
{
MessageBox.Show(string.Format("{0} not found!", fileName));
return;
}
XlsDocument xls = new XlsDocument(@fileName);//打开EXCLE
//获得Excel中的指定一个工作页
Worksheet sheet = xls.Workbook.Worksheets[0];
//读取数据 循环每sheet工作页的第5行开始
for (int i = 5; i < sheet.Rows.Count; i++)
{
//读取第一行第一列
zid = Convert.ToString(sheet.Rows[ushort.Parse(i.ToString())].GetCell(1).Value);
ListViewItem lv1 = new ListViewItem(zid);
// 第一行第5列
j = Convert.ToString(sheet.Rows[ushort.Parse(i.ToString())].GetCell(5).Value);
lv1.SubItems.Add(j);
listview1.Items.Add(lv1);
}
}
}
