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);
|
//查询时长,按小时
|
|
}
|
|
|
}
|
