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); } } } MyXLS .CodeEntity .code_pieces ul.piece_anchor{width:25px;position:absolute;top:25px;left:-30px;z-index:1000;}.CodeEntity .code_pieces ul.piece_anchor li{width:25px;background: #efe;margin-bottom:2px;}.CodeEntity .code_pieces ul.piece_anchor li{border-left:3px #40AA63 solid;border-right:3px #efe solid;}.CodeEntity .code_pieces ul.piece_anchor li:hover{border-right:3px #40AA63 solid;border-left:3px #efe solid;}.CodeEntity .code_pieces ul.piece_anchor li a{color: #333;padding: 3px 10px;}.CodeEntity .code_pieces .jump_to_code{visibility:hidden;position:relative;}.CodeEntity .code_pieces .code_piece:hover .jump_to_code{visibility:visible;}.CodeEntity .code_pieces .code_piece:hover .jump_to_code a{text-decoration:none;}.CodeEntity .code_pieces h2 i{float:right;font-style:normal;font-weight:normal;}.CodeEntity .code_pieces h2 i a{font-size:9pt;background: #FFFFFF;color:#00A;padding: 2px 5px;text-decoration:none;}
MyXls 导入EXECL到listview
