package com.whyc.service; import com.whyc.util.ThreadLocalUtil; import org.apache.poi.xssf.usermodel.XSSFSheet; import org.apache.poi.xssf.usermodel.XSSFWorkbook; import org.springframework.stereotype.Service; import java.io.FileOutputStream; import java.io.IOException; import java.util.Date; @Service public class ExcelService { public void dcReport() throws IOException { String filePath = "C:\\Users\\29550\\Desktop\\当前项目\\2023\\0智能机器人运维系统\\测试.xlsx"; //创建一个工作簿 XSSFWorkbook workbook = new XSSFWorkbook(); //创建sheet1 createSheet1(workbook); // 将工作簿写入文件 FileOutputStream fileOut = new FileOutputStream(filePath); workbook.write(fileOut); // 关闭工作簿 workbook.close(); } private void createSheet1(XSSFWorkbook workbook) { XSSFSheet sheet = workbook.createSheet("放电充电电压数据报表"); //总的列数根据 放电时长和充电时长决定 Date dischargeStartTime = ThreadLocalUtil.parse("2023-01-01 11:00:00", 1); Date dischargeEndTime = ThreadLocalUtil.parse("2023-01-02 01:00:00", 1); //查询时长,按小时 } }