FileOutputStream temp = new FileOutputStream(new File(“C1.xlsx”));
// List<NoTemplateSheetWrapper> sheets = new ArrayList<>();
try {
//前面生成xlsx的就不写了,太简单了,重点记录一下这里(发布到服务器上也可以用)
ExcelUtils.getInstance().noTemplateSheet2Excel(sheets, temp);
} catch (Excel4JException e) {
e.printStackTrace();
}
// ByteArrayOutputStream baos=new ByteArrayOutputStream();
// baos=(ByteArrayOutputStream) temp;
// ByteArrayInputStream swapStream = new ByteArrayInputStream(baos.toByteArray());
System.out.println("上面那个的长的"+temp.toString().indexOf(2,9));
ByteArrayOutputStream out = null;
File file = new File("C1.xlsx");
try {
FileInputStream in = new FileInputStream(file);
out = new ByteArrayOutputStream();
byte[] b = new byte[1024];
int i = 0;
while ((i = in.read(b)) != -1) {
out.write(b, 0, b.length);
}
out.close();
in.close();
} catch (FileNotFoundException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
System.out.println("下面的Arr"+out.size());
HttpHeaders httpHeaders = new HttpHeaders();
String fileName = new String("C1.xlsx".getBytes("UTF-8"), "iso-8859-1");
httpHeaders.setContentDispositionFormData("attachment", fileName);
httpHeaders.setContentType(MediaType.APPLICATION_OCTET_STREAM);
ResponseEntity<byte[]> filebyte = new ResponseEntity<>(out.toByteArray(), httpHeaders, HttpStatus.CREATED);
return filebyte;