private void View_Load(object sender, EventArgs e)
{
InitHeader();
InitSelectData();
sheet = report.CurrentWorksheet;
sheet.DeleteRows(0, 2);//删除模板1、2行
LoadCompanys();
reportLogic = new DataReportLogic();
LoadCharData();
LoadReportData();
sheet.SetCols(22);
ExcelHelper.SetDecimalFormat(sheet, 2);
sheet.AutoFitColumnWidth(0, false);
}
private void ViewReport_Load(object sender, EventArgs e)
{
//sheet.InsertColumns(0,23);
dataReport = new DataReportLogic();
selects = new List <Company>();
InitHeader();
sheet = excel.CurrentWorksheet;
sheet.DeleteRows(0, 2);//删除模板1、2行
//LoadData();
LoadSelectItems();
sheet.SetCols(22);
sheet.Resize(200, 22);
sheet.BeforeCellEdit += (s, ev) => ev.IsCancelled = true;
if (comboBox1.Items.Count > 0)
{
comboBox1.SelectedIndex = 0;
}
ExcelHelper.SetDecimalFormat(sheet, 2);
sheet.AutoFitColumnWidth(0, false);
}
