<form name="excelImportForm" action="${pageContext.request.contextPath}/brand/importBrandSort" method="post" onsubmit="return checkImportPath();" enctype="multipart/form-data" id="excelImportForm">
                <input  type="hidden" name="ids" id="ids">
                <div class="modal-body">
                    <div class="row gap">
                        <label class="col-sm-7 control-label"><input class="btn btn-default" id="excel_file" type="file" name="filename"  accept="xls"/></label>
                        <div class="col-sm-3">
                            
                        	<input class="btn btn-primary" id="excel_button" type="submit" value=http://www.mamicode.com/"导入Excel"/>>

@RequestMapping(value = http://www.mamicode.com/"/importBrandSort", method = RequestMethod.POST)>代码中的注释部分是如果不使用spring的方式，如何拿到提交过来的文件名（需要是要apache的一些工具包），其实使用spring的也是一样，只是已经做好了封装，方便我们写代码。

InputStream in = file.getInputStream();
		List<BrandMobileInfoEntity> BrandMobileInfos = brandService
				.importBrandPeriodSort(in);

@Override
	public List<BrandMobileInfoEntity> importBrandPeriodSort(InputStream in) throws Exception  {
		
		List<BrandMobileInfoEntity> brandMobileInfos = readBrandPeriodSorXls(in);
		for (BrandMobileInfoEntity brandMobileInfo : brandMobileInfos) {
			mapper.updateByConditions(brandMobileInfo);
		}
		return brandMobileInfos;
	}

$(".exportBrandSort").on('click', function() {
    	
    	 var url = contextPath+"/brand/exportBrandSort";
    	 $('#searchform').attr('action', url);
    	 $('#searchform').submit();
    	 //还原action值
    	 url = contextPath+"/brand/getBrand";
    	 $('#searchform').attr('action', url);<span style="font-family: 'Microsoft YaHei UI', 'Microsoft YaHei', SimSun, 'Segoe UI', Tahoma, Helvetica, sans-serif, 'Microsoft YaHei', Georgia, Helvetica, Arial, sans-serif, 宋体, PMingLiU, serif; font-size: 14px;">}</span>

@RequestMapping(value = http://www.mamicode.com/"/exportBrandSort", method = RequestMethod.GET)>
代码中前半部分只是根据表单信息去后台那数据并保存在List<BrandCompleteInfoEntity>中，可忽略细节。

byte[] fileNameByte = ("档期列表.xls").getBytes("GBK");
			String filename = new String(fileNameByte, "ISO8859-1");

			byte[] bytes = brandService.exportBrandPeriodSort(list);

@Override
	public byte[] exportBrandPeriodSort(List<BrandCompleteInfoEntity>  list) throws Exception {
		
		ByteArrayOutputStream out = new ByteArrayOutputStream();
		// 第一步，创建一个webbook，对应一个Excel文件
		HSSFWorkbook wb = new HSSFWorkbook();
		// 第二步，在webbook中添加一个sheet,对应Excel文件中的sheet
		HSSFSheet sheet = wb.createSheet("档期排序表");
		// 第三步，在sheet中添加表头第0行,注意老版本poi对Excel的行数列数有限制short
		HSSFRow row = sheet.createRow((int) 0);
		// 第四步，创建单元格，并设置值表头 设置表头居中
		HSSFCellStyle style = wb.createCellStyle();
		style.setAlignment(HSSFCellStyle.ALIGN_CENTER); // 创建一个居中格式

		//设置表头
		List<String> excelHead = getExcelHead();
		
		HSSFCell cell = null;
		// excel头
		for (int i = 0; i < excelHead.size(); i++) {
			cell = row.createCell(i);
			cell.setCellValue(excelHead.get(i));
			cell.setCellStyle(style);
		}

		// 第五步，写入实体数据 实际应用中这些数据从数据库得到
		//List<BrandPeriodSortEntity> list = getBrandPeriodSortDynamicOrder(entity, orderType);

		BrandCompleteInfoEntity brandCompleteInfo = null; // 拼装excel内容
		for (int i = 0; i < list.size(); i++) {
			row = sheet.createRow((int) i + 1);
			brandCompleteInfo = list.get(i);
			// 创建单元格，并设置值
		
			
			int j=0;
			insertCell(row, j++, brandCompleteInfo.getBrandId());
			insertCell(row, j++, brandCompleteInfo.getBrandName());
			insertCell(row, j++, brandCompleteInfo.getMobileShowFrom());
			insertCell(row, j++, brandCompleteInfo.getMobileShowTo());
			insertCell(row, j++, brandCompleteInfo.getSellMarkValue());
			insertCell(row, j++, brandCompleteInfo.getWarehouse());
			insertCell(row, j++, brandCompleteInfo.getSortA1());
			insertCell(row, j++, brandCompleteInfo.getSortA2());
			insertCell(row, j++, brandCompleteInfo.getSortB());
			insertCell(row, j++, brandCompleteInfo.getSortC10());
			insertCell(row, j++, brandCompleteInfo.getSortC());
			insertCell(row, j++, brandCompleteInfo.getHitA());
			insertCell(row, j++, brandCompleteInfo.getHitB());
			insertCell(row, j++, brandCompleteInfo.getHitC());
			insertCell(row, j++, brandCompleteInfo.getCustomSellType());
			insertCell(row, j++, channelInfoMapper.loadChannelNameById(brandCompleteInfo.getChannelId()));
			insertCell(row, j++, brandCompleteInfo.getChannelId());
			
		}
		wb.write(out);
		return out.toByteArray();
	}
	
	/**
	 * 获取excel表头
	 * 
	 * @return
	 */
	private List<String> getExcelHead() {
		List<String> result = new ArrayList<String>(17);
		result.add("XXXXX");<pre name="code" class="java" style="font-size: 14.44444465637207px; line-height: 21px;"><span style="white-space:pre">		</span>result.add("XXXXX");

<pre name="code" class="java" style="font-size: 14.44444465637207px; line-height: 21px;"><span style="white-space:pre">		</span>result.add("XXXXX");
<pre name="code" class="java"><span>		</span>result.add("XXXXX");

<pre name="code" class="java" style="font-size: 14.44444465637207px; line-height: 21px;"><span style="white-space:pre">		</span>result.add("XXXXX");
<pre name="code" class="java"><span>		</span>result.add("XXXXX");

<span>		</span>result.add("XXXXX");
<pre name="code" class="java"><span>		</span>result.add("XXXXX");