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