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;
}
