excel文件

最新推荐文章于 2022-11-29 13:04:20 发布

stone1116

最新推荐文章于 2022-11-29 13:04:20 发布

阅读量461

点赞数

分类专栏： java 文章标签： excel file exception user os list

本文链接：https://blog.csdn.net/stone1116/article/details/4812617

版权

94 篇文章 0 订阅

订阅专栏

//Service中

public InputStream getInputStream()
{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("sheet1");

HSSFRow row = sheet.createRow(0);

  HSSFCell cell = row.createCell((short) 0);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16);
  cell.setCellValue("序号");

  cell = row.createCell((short) 1);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16);
  cell.setCellValue("姓");

  cell = row.createCell((short) 2);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16);
  cell.setCellValue("名");

  cell = row.createCell((short) 3);
  cell.setEncoding(HSSFCell.ENCODING_UTF_16);
  cell.setCellValue("年龄");

List<User> list = this.findAll();

  for (int i = 0; i < list.size(); ++i)
  {
   User user = list.get(i);

row = sheet.createRow(i + 1);

   cell = row.createCell((short) 0);
   cell.setEncoding(HSSFCell.ENCODING_UTF_16);
   cell.setCellValue(i + 1);

   cell = row.createCell((short) 1);
   cell.setEncoding(HSSFCell.ENCODING_UTF_16);
   cell.setCellValue(user.getFirstname());

   cell = row.createCell((short) 2);
   cell.setEncoding(HSSFCell.ENCODING_UTF_16);
   cell.setCellValue(user.getLastname());

   cell = row.createCell((short) 3);
   cell.setEncoding(HSSFCell.ENCODING_UTF_16);
   cell.setCellValue(user.getAge());
  }

File file = new File("test.xls");

  try
  {
   OutputStream os = new FileOutputStream(file);
   wb.write(os);
   os.close();
  }
  catch (Exception e)
  {
   e.printStackTrace();
  }

  InputStream is = null;
  try
  {
   is = new FileInputStream(file);
  }
  catch (FileNotFoundException e)
  {
   e.printStackTrace();
  }

return is;

}

Action中

public InputStream getDownloadFile()
{
return this.service.getInputStream();
}

关注