private void AdjustColumnWidth(Worksheet sheet, int maxColumnNum) { for (int i = 0; i < maxColumnNum; i++) { sheet.AutoFitColumnWidth(i); } }
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 LineChart_Load(object sender, EventArgs e) { initData(); worksheet.SetColumnsWidth(0, 1, 200); worksheet.AutoFitColumnWidth(0); }