數(shù)據(jù)導出為Excel在我們寫項目的過程中經(jīng)常用到

需要用到的jar包 poi-3.17.jar

//第一步創(chuàng)建一個webbook,對應一個Excel文件HSSFWorkbook wb=new HSSFWorkbook();//第二步,在webbook中添加一個sheet,對應Excel文件中的sheetHSSFSheet sheet=wb.createSheet('食物信息數(shù)據(jù)');//第三步，在sheet中添加表頭第0行HSSFRow row = sheet.createRow(0);//第四步，創(chuàng)建單元格，并設置表頭居中HSSFCellStyle style = wb.createCellStyle();style.setAlignment(HorizontalAlignment.CENTER);//居中格式HSSFCell cell = row.createCell(0);cell.setCellValue('編號');cell.setCellStyle(style);cell=row.createCell((short)1);cell.setCellValue('名稱');cell.setCellStyle(style);cell=row.createCell((short)2);cell.setCellValue('類型');cell.setCellStyle(style);cell=row.createCell((short)3);cell.setCellValue('單價');cell.setCellStyle(style);cell=row.createCell((short)4);cell.setCellValue('庫存');cell.setCellStyle(style);//第五步，寫入實體數(shù)據(jù)，從數(shù)據(jù)庫拿數(shù)據(jù)FoodController controller=new FoodController();List<Foods> foodsList = controller.foodsList(null, null);for (int i = 0; i < foodsList.size(); i++) {//創(chuàng)建單元格，并賦值row=sheet.createRow(i+1);Foods foods = foodsList.get(i);row.createCell((short)0).setCellValue(foods.getId());row.createCell((short)1).setCellValue(foods.getName());row.createCell((short)2).setCellValue(foods.getType());row.createCell((short)3).setCellValue(foods.getPrice());row.createCell((short)4).setCellValue(foods.getNum());}//第六步，下載ExcelOutputStream out=null;out=response.getOutputStream();String fileName='食物信息.xls';response.setContentType('application/x-=msdownload');response.setHeader('Content-Disposition', 'attachment; filename='+URLEncoder.encode(fileName, 'UTF-8'));wb.write(out);三、實現(xiàn)效果圖

導出成功后數(shù)據(jù)成功顯示

到此這篇關于Java中用POI實現(xiàn)將數(shù)據(jù)導出到Excel的文章就介紹到這了,更多相關java數(shù)據(jù)導出到Excel內容請搜索好吧啦網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關文章希望大家以后多多支持好吧啦網(wǎng)！