/// <summary> /// 构造函数 /// </summary> /// <param name="tr">行</param> /// <param name="value">值</param> /// <param name="index">列</param> /// <param name="rowspan">跨行</param> /// <param name="colspan">跨列</param> /// <param name="cssClass">css类</param> internal TCell(TRow tr, string value, int index, int rowspan, int colspan, string cssClass) { Row = tr; Value = value; Index = index; Rowspan = rowspan; Colspan = colspan; Class = cssClass; }
/// <summary> /// 导出空气质量指数日报 /// </summary> public static void ExportDayAQIReport() { Table table = new Table(); #region thead TRow tr = table.Thead.AddTr(); tr.AddTh(DateTime.Today.ToString("yyyy年MM月dd日"), 1, 21); tr = table.Thead.AddTr(); tr.AddTh("城市名称", 4, 1); tr.AddTh("监测点位名称", 4, 1); tr.AddTh("污染物浓度及空气质量分指数(IAQI)", 1, 14); tr.AddTh("空气质量指数(AQI)", 4, 1); tr.AddTh("首要污染物", 4, 1); tr.AddTh("空气质量指数级别", 4, 1); tr.AddTh("空气质量指数类别", 2, 2); tr = table.Thead.AddTr(); tr.AddTh("二氧化硫(SO2)24小时平均", 2, 2); tr.AddTh("二氧化氮(NO2)24小时平均", 2, 2); tr.AddTh("颗粒物(粒径小于等于10μm)24小时平均", 2, 2); tr.AddTh("一氧化碳(CO)24小时平均", 2, 2); tr.AddTh("臭氧(O3)最大1小时平均", 2, 2); tr.AddTh("臭氧(O3)最大8小时滑动平均", 2, 2); tr.AddTh("颗粒物(粒径小于等于2.5μm)24小时平均", 2, 2); tr = table.Thead.AddTr(); tr.AddTh("类别", 2, 1); tr.AddTh("颜色", 2, 1); tr = table.Thead.AddTr(); for (int i = 0; i < 7; i++) { if (i == 3) { tr.AddTh("浓度/(mg/m³)"); } else { tr.AddTh("浓度/(μg/m³)"); } tr.AddTh("分指数"); } #endregion #region tfoot tr = table.Tfoot.AddTr(); tr.AddTd("注:缺测指标的浓度及分指数均使用NA标识。"); #endregion #region tbody Random rand = new Random(); for (int i = 0; i < 10; i++) { tr = table.Tbody.AddTr(); tr.AddTd("广州"); tr.AddTd("未知点位"); tr.AddTd(rand.Next(100).ToString()); tr.AddTd(rand.Next(50).ToString()); tr.AddTd(rand.Next(100).ToString()); tr.AddTd(rand.Next(50).ToString()); tr.AddTd(rand.Next(100).ToString()); tr.AddTd(rand.Next(50).ToString()); tr.AddTd(rand.Next(10).ToString()); tr.AddTd(rand.Next(50).ToString()); tr.AddTd(rand.Next(100).ToString()); tr.AddTd(rand.Next(50).ToString()); tr.AddTd(rand.Next(100).ToString()); tr.AddTd(rand.Next(50).ToString()); tr.AddTd(rand.Next(100).ToString()); tr.AddTd(rand.Next(50).ToString()); tr.AddTd(rand.Next(50).ToString()); tr.AddTd("NA"); tr.AddTd("一级"); tr.AddTd("优"); tr.AddTd("绿色"); } #endregion NPOIHelper.Export(table, "DayAQIReport.xlsx", 2); }
/// <summary> /// 构造函数 /// </summary> /// <param name="tr">行</param> /// <param name="value">值</param> /// <param name="index">列</param> /// <param name="rowspan">跨行</param> /// <param name="colspan">跨列</param> /// <param name="cssClass">css类</param> internal Th(TRow tr, string value, int index, int rowspan, int colspan, string cssClass) : base(tr, value, index, rowspan, colspan, cssClass) { }