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