src/main/java/com/yssh/entity/xls/DayExcel.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/yssh/entity/xls/ExcelHead.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/yssh/entity/xls/MonthExcel.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/yssh/entity/xls/WeekExcel.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/yssh/service/XlsExportService.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/java/com/yssh/utils/ExcelUtils.java | ●●●●● 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/resources/templates/day.xlsx | 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/resources/templates/month.xlsx | 补丁 | 查看 | 原始文档 | blame | 历史 | |
src/main/resources/templates/week.xlsx | 补丁 | 查看 | 原始文档 | blame | 历史 |
src/main/java/com/yssh/entity/xls/DayExcel.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,102 @@ package com.yssh.entity.xls; /** * æ¥æ¥Excel * @author WWW * @date 2023-08-08 */ public class DayExcel { /** * æ¥åå¼ */ private String rjz; /** * 累计 */ private String lj; /** * ç´¯è®¡åæ¯ */ private String ljtb; /** * åå½±åå ç´ ååå */ private String ys; /** * é£é */ private String fs; /** * é£å */ private String fx; /** * 温度 */ private String wd; public DayExcel() { } public String getRjz() { return rjz; } public void setRjz(String rjz) { this.rjz = rjz; } public String getLj() { return lj; } public void setLj(String lj) { this.lj = lj; } public String getLjtb() { return ljtb; } public void setLjtb(String ljtb) { this.ljtb = ljtb; } public String getYs() { return ys; } public void setYs(String ys) { this.ys = ys; } public String getFs() { return fs; } public void setFs(String fs) { this.fs = fs; } public String getFx() { return fx; } public void setFx(String fx) { this.fx = fx; } public String getWd() { return wd; } public void setWd(String wd) { this.wd = wd; } } src/main/java/com/yssh/entity/xls/ExcelHead.java
ÎļþÃû´Ó src/main/java/com/yssh/entity/ExcelHead.java ÐÞ¸Ä @@ -1,4 +1,4 @@ package com.yssh.entity; package com.yssh.entity.xls; import java.lang.annotation.ElementType; import java.lang.annotation.Retention; src/main/java/com/yssh/entity/xls/MonthExcel.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,167 @@ package com.yssh.entity.xls; /** * ææ¥Excel * @author WWW * @date 2023-08-08 */ public class MonthExcel { /** * 䏿 */ private String sy; /** * æç¯æ¯ */ private String yhb; /** * æåæ */ private String ytq; /** * æåæ¯ */ private String ytb; /** * æç¯æ¯2 */ private String yhb2; /** * 累计 */ private String lj; /** * ç´¯è®¡åæ¯ */ private String ljtb; /** * è¾åä¸å¹´åå¼ååå¹ åº¦ */ private String qyn; /** * åå½±åå ç´ ååå */ private String ys; /** * é£é */ private String fs; /** * é£å */ private String fx; /** * 温度 */ private String wd; public MonthExcel() { } public String getSy() { return sy; } public void setSy(String sy) { this.sy = sy; } public String getYhb() { return yhb; } public void setYhb(String yhb) { this.yhb = yhb; } public String getYtq() { return ytq; } public void setYtq(String ytq) { this.ytq = ytq; } public String getYtb() { return ytb; } public void setYtb(String ytb) { this.ytb = ytb; } public String getYhb2() { return yhb2; } public void setYhb2(String yhb2) { this.yhb2 = yhb2; } public String getLj() { return lj; } public void setLj(String lj) { this.lj = lj; } public String getLjtb() { return ljtb; } public void setLjtb(String ljtb) { this.ljtb = ljtb; } public String getQyn() { return qyn; } public void setQyn(String qyn) { this.qyn = qyn; } public String getYs() { return ys; } public void setYs(String ys) { this.ys = ys; } public String getFs() { return fs; } public void setFs(String fs) { this.fs = fs; } public String getFx() { return fx; } public void setFx(String fx) { this.fx = fx; } public String getWd() { return wd; } public void setWd(String wd) { this.wd = wd; } } src/main/java/com/yssh/entity/xls/WeekExcel.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,167 @@ package com.yssh.entity.xls; /** * 卿¥Excel * @author WWW * @date 2023-08-08 */ public class WeekExcel { /** * ä¸å¨ */ private String sz; /** * å¨ç¯æ¯ */ private String zhb; /** * å¨åæ */ private String ztq; /** * å¨åæ¯ */ private String ztb; /** * å¨ç¯æ¯2 */ private String zhb2; /** * 累计 */ private String lj; /** * ç´¯è®¡åæ¯ */ private String ljtb; /** * è¾ä¸ä¸å¹´åº¦ååå¹ åº¦ */ private String syn; /** * åå½±åå ç´ ååå */ private String ys; /** * é£é */ private String fs; /** * é£å */ private String fx; /** * 温度 */ private String wd; public WeekExcel() { } public String getSz() { return sz; } public void setSz(String sz) { this.sz = sz; } public String getZhb() { return zhb; } public void setZhb(String zhb) { this.zhb = zhb; } public String getZtq() { return ztq; } public void setZtq(String ztq) { this.ztq = ztq; } public String getZtb() { return ztb; } public void setZtb(String ztb) { this.ztb = ztb; } public String getZhb2() { return zhb2; } public void setZhb2(String zhb2) { this.zhb2 = zhb2; } public String getLj() { return lj; } public void setLj(String lj) { this.lj = lj; } public String getLjtb() { return ljtb; } public void setLjtb(String ljtb) { this.ljtb = ljtb; } public String getSyn() { return syn; } public void setSyn(String syn) { this.syn = syn; } public String getYs() { return ys; } public void setYs(String ys) { this.ys = ys; } public String getFs() { return fs; } public void setFs(String fs) { this.fs = fs; } public String getFx() { return fx; } public void setFx(String fx) { this.fx = fx; } public String getWd() { return wd; } public void setWd(String wd) { this.wd = wd; } } src/main/java/com/yssh/service/XlsExportService.java
¶Ô±ÈÐÂÎļþ @@ -0,0 +1,24 @@ package com.yssh.service; import org.springframework.core.io.ClassPathResource; import org.springframework.stereotype.Service; import java.io.IOException; /** * Excelå¯¼åºæå¡ç±» * @author WWW * @author 2023-08-05 */ @Service public class XlsExportService { /** * è·åExcelæ¨¡æ¿ */ private String getXslTemplate(String type) throws IOException { ClassPathResource resource = new ClassPathResource(String.format("templates/%s.xlsx", type)); return resource.exists() ? resource.getFile().getPath() : null; } } src/main/java/com/yssh/utils/ExcelUtils.java
@@ -10,7 +10,7 @@ import com.alibaba.excel.write.metadata.WriteSheet; import com.alibaba.excel.write.metadata.fill.FillConfig; import com.alibaba.excel.write.metadata.fill.FillWrapper; import com.yssh.entity.ExcelHead; import com.yssh.entity.xls.ExcelHead; import java.util.*; src/main/resources/templates/day.xlsxBinary files differ
src/main/resources/templates/month.xlsxBinary files differ
src/main/resources/templates/week.xlsxBinary files differ