简单的导出excel设置

动态的导出excel设置

1.添加pom插件导入

		<dependency>
		    <groupId>org.apache.poi</groupId>
		    <artifactId>poi</artifactId>
		    <version>3.16-beta2</version>
		</dependency>

2.接口里加入List getAll方法、接口的实现类实现方法

3.控制器中设置

	//导出设置
	@RequestMapping("export")
	public void export(HttpServletResponse response) throws IOException {
		List<SalesChance> list = salesChanceService.getAll();
		//创建了一个工作簿
		Workbook wb = new HSSFWorkbook();
		//创建工作表
		Sheet sheet = wb.createSheet();
		int startRow = 1;
		//创建行
//		Row row = sheet.createRow(1);
		Row row=null;
		Cell cell = null;
		int startColum = 1;
		for(SalesChance salesChance : list) {
			row = sheet.createRow(startRow++);
			startColum=1;//设置列数
			cell = row.createCell(startColum++);
			cell.setCellValue(salesChance.getId());
			
			cell = row.createCell(startColum++);
			cell.setCellValue(salesChance.getSupplier().getId());
			
			cell = row.createCell(startColum++);
			cell.setCellValue(salesChance.getSupplierName());
			
			cell = row.createCell(startColum++);
			cell.setCellValue(salesChance.getSalDate());
			
			cell = row.createCell(startColum++);
			cell.setCellValue(salesChance.getGoods().getId());
			
			cell = row.createCell(startColum++);
			cell.setCellValue(salesChance.getGoodsNum());
			
			cell = row.createCell(startColum++);
			cell.setCellValue(salesChance.getPrice());
			
			cell = row.createCell(startColum++);
			cell.setCellValue(salesChance.getSalPrice());
			
		}
		
		/*//创建单元格
		Cell cell = row.createCell(1);*/
		//得到单元格的值
		cell.setCellValue("tom");
		
		
		//设置响应类型
		response.setContentType("application/vnd.ms-excel");
		//得到响应流
		ServletOutputStream outputStream = response.getOutputStream();
		//把工作簿写入到响应流中
		wb.write(outputStream);
		outputStream.close();
		wb.close();
	}