private void btnLoad_Click(object sender, EventArgs e) { var filename = "902.xls"; var dt = NpoiHelper.ImportExcelFile(filename);//通过NPOI读取excel dgv.DataSource = dt; }
private void btnLoad_Click(object sender, EventArgs e) { string rootpath = Path.Combine(System.Environment.CurrentDirectory, "read"); var files = Directory.GetFiles(rootpath, "*.xls"); float sumOfFloder = 0;//当前文件夹下所有充电 foreach (var item in files) { FileInfo fi = new FileInfo(item); var dt = NpoiHelper.ImportExcelFile(fi.FullName);//通过NPOI读取excel //dgv.DataSource = dt;//测试时候, 看下内容是否正确 //break; var sum = GetSum(dt, "充电量");// dt.Compute("sum(充电量)", "");//由于读取时候全部作为字符串处理,所以这个方法不正确的 sumOfFloder += sum; txtResult.AppendText(fi.Name + "\t" + sum.ToString() + Environment.NewLine); } txtResult.AppendText("充电量合计:" + "\t" + sumOfFloder.ToString() + Environment.NewLine); }
private void LoadFile(string file) { var dt = NpoiHelper.ImportExcelFile(file); dgv.DataSource = dt; }