package com.zhuanche.util.excel;
import javax.servlet.http.HttpServletResponse;
import java.io.BufferedWriter;
import java.io.IOException;
import java.io.OutputStreamWriter;
import java.util.List;/**
* 导出的excel 需要添加额外的输出*/
public classSupplierFeeCsvUtils {public static final Integer downPerSize = 10000;public static final String tab = "\t";privateOutputStreamWriter osw;private BufferedWriter bw = null;publicOutputStreamWriter getOsw() {returnosw;
}public voidsetOsw(OutputStreamWriter osw) {this.osw =osw;
}publicBufferedWriter getBw() {returnbw;
}public voidsetBw(BufferedWriter bw) {this.bw =bw;
}publicboolean exportCsvV2(HttpServletResponse response,
ListdataList,
ListheaddataList,
String fileName,boolean isFirst,boolean islast,List footerList,intlength) throws IOException {
boolean isSucess=false;
OutputStreamWriter osw= this.getOsw();
BufferedWriter bw= this.getBw();try{if(isFirst){
response.reset();//设置response
response.setContentType("application/octet-stream;charset=UTF-8");
response.setHeader("content-disposition", "attachment; filename="+fileName);
}if(osw == null){
osw= new OutputStreamWriter(response.getOutputStream(), "UTF-8");
osw.write(new String(new byte[] { (byte) 0xEF, (byte) 0xBB,(byte) 0xBF}));this.setOsw(osw);
}if(bw == null){
bw= newBufferedWriter(osw);this.setBw(bw);
}if(isFirst){if(headdataList!=null && !headdataList.isEmpty()){for(int k = 0;k
bw.write(headdataList.get(k)+"\r\n");
bw.write(dataList.get(k)+"\r\n");
}
}
}if(footerList != null && !footerList.isEmpty()){for(String data : footerList){
bw.write(data+"\r\n");
}
}
isSucess=true;
}catch(Exception e) {
isSucess=false;
}finally{if(islast){if(bw!=null){try{
bw.close();
bw=null;
}catch(IOException e) {
e.printStackTrace();
}
}if(osw!=null){try{
osw.close();
osw=null;
}catch(IOException e) {
e.printStackTrace();
}
}
}else{if(bw!=null){try{
bw.flush();
}catch(IOException e) {
e.printStackTrace();
}
}if(osw!=null){try{
osw.flush();
}catch(IOException e) {
e.printStackTrace();
}
}
}
}returnisSucess;
}
}
216
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
