myxls很好用，最近做項(xiàng)目發(fā)現(xiàn)myxls導(dǎo)出EXCLE的解釋很多而如何將excel導(dǎo)入到winform中dataview或者listview中的介紹很少，研究了2天。寫點(diǎn)代碼給大家分享下
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];
//讀取數(shù)據(jù) 循環(huán)每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);
}
}
}
