// 生成全部公司按工会分组的报表 private void GroupByUnion(DateTime time) { ExcelInterface excel = new ExcelInterface(null, 'w'); GroupByUnionFillCells(excel.GetWorksheet().Cells, time); GroupByUnionStyleCells(excel.GetWorksheet().Cells); string filename = Path.Combine(Directory.GetCurrentDirectory(), time.ToString(timeFormat_) + "各县(市)区总工会经费收解返计算表.xls"); excel.Save(filename); excel.Close(); }
// 生成总工会所属公司按税务局分组的报表 private void GroupByTaxAuthority(DateTime time) { ExcelInterface excel = new ExcelInterface(null, 'w'); FillCells(excel.GetWorksheet().Cells, time, "三门峡市总工会", "TaxAuthority"); StyleCells(excel.GetWorksheet().Cells); string filename = Path.Combine(Directory.GetCurrentDirectory(), time.ToString(timeFormat_) + "工会经费征收明细.xls"); excel.Save(filename); excel.Close(); }