JAVA IO 流写LIST集合到EXCEL文件

本文主要是介绍JAVA IO 流写LIST集合到EXCEL文件，希望对大家解决编程问题提供一定的参考价值，需要的开发者们随着小编来一起学习吧！

 提供部分代码

   String sql="*****"; 
   List list = commonDao.getAllRecord(sql);
GetProperties gp = new GetProperties("dictionary");
String spath = ServletActionContext.getServletContext().getRealPath("/")+ gp.getProp("uploadpath");
String name = "planbuycar"+ StrUtil.dateFormatstr(new Date(), "yyyyMMddHHmmss")+ ".csv";
   if (CsvPlanBuyCarFile(spath + name, list)) {
message = "导出成功";
} else {
message = "导出失败";
}
         

         private static String userxlsinfo = "序号,用户ID,姓名,手机,留言信息,注册时间,";
public static boolean CsvPlanBuyCarFile(String path, List body) {
try {
File file = new File(path);
if (file.isFile()) {
file.mkdir();
}
FileOutputStream out = new FileOutputStream(file);
OutputStreamWriter osw = new OutputStreamWriter(out, "GB2312");
BufferedWriter bw = new BufferedWriter(osw);
// 创建表头
String sheader = userxlsinfo;
sheader += "\r\n";
bw.write(sheader);
if (body != null) {
for (int i = 0; i < body.size(); i++) {
CamPlanBuyCar buycar = (CamPlanBuyCar) body.get(i);
StringBuffer mess = new StringBuffer();
// 用户信息
mess.append((i + 1) + ",");
mess.append(buycar.getId() + ",");
mess.append(buycar.getName().trim() + ",");
mess.append(buycar.getPhone().trim() + ",");
mess.append(buycar.getMessage().trim() + ",");
mess.append(StrUtil.dateFormatstr(buycar.getDate(),"yyyy-MM-dd HH:mm:ss"));
mess.append("\r\n");	
System.out.println(i);
bw.write(mess.toString());
}
}
bw.close();
osw.close();
out.close();
return true;
} catch (FileNotFoundException e) {
e.printStackTrace();
} catch (UnsupportedEncodingException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (IOException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return false;
}

 

这篇关于JAVA IO 流写LIST集合到EXCEL文件的文章就介绍到这儿，希望我们推荐的文章对编程师们有所帮助！

---