怎么使用多线程导出excel gpt上面搜出来的代码都不对
下面的是gpt回答的 不行
@PostMapping("/export2")
public void export2(HttpServletResponse response){
ExecutorService executor=Executors.newFixedThreadPool(5);
for (int i = 0; i <=5 ; i++) {
executor.execute(() ->{
Workbook workbook=new XSSFWorkbook();
Sheet sheet=workbook.createSheet("sheet");
List<String> data=getDatas();
int rowNum=0;
for (String s:data){
Row row= sheet.createRow(rowNum++);
Cell cell=row.createCell(0);
cell.setCellValue(s);
}
try {
response.setHeader("Content-Disposition", "attachment; filename=\"export.xlsx\"");
response.setContentType("application/vnd.openxmlformats-officedocument.spreadsheetml.sheet");
workbook.write(response.getOutputStream());
}catch (IOException e){
e.printStackTrace();;
}
});
}
executor.shutdown();
}
private List<String> getDatas(){
List<String> data=new ArrayList<>();
for (int i = 0; i <=100; i++) {
data.add("Data"+i);
}
return data;
}
在pycharm的终端中,我们进入到chatgpt_academic-master:
输入指令:python -m pip install -r requirements.txt
对依赖的包进行安装。稍等一会,安装完成之后运行main.py文件即可,出现如下界面表示连接成功:将http://localhost:54024复制到浏览器中,或者直接点击进去,进入学术优化界面,开始操作!
这里提示我们:This share link expires in 72 hours. For free permanent hosting and GPU upgrades (NEW!), check out Spaces: https://huggingface.co/spaces
此共享链接将在72小时后过期,三天之后这个网站要重新运行main.py才能使用 应该是这个意思。