后台php生成的表格,ajax提交excel表格数据格式-用ajax传数据到后台php。如何生成excel...

最新推荐文章于 2024-03-07 17:08:51 发布

老卫15034297801

最新推荐文章于 2024-03-07 17:08:51 发布

阅读量157

点赞数

文章标签：后台php生成的表格

ajax导出excel响应结果如下,应该怎么解决呢？

这个一般是后台做的台生excel文件返回前端下载。

主要原因是虽这种插件(ExcellentExport.jsexceljs、js-xlsx等等)，但是受到jquery版本和浏览器支持的限制，处理起来也比后端处理复杂。而且一旦数据量大起来浏览器是承受不了的。

问下，form表单提交一个excel文件之后，后台返回的...

这个一般是后台做的台生excel文件返回前端下载。

用ajax传数据到后台php。如何生成excel

的poiEXCEL操作。部分代码。嘿嘿

/**

* 创建标准模板

* param request

* @param response

* @throws Exception

private void createEXCELTemplet(HttpServletRequest request,

HttpServletResponse response) throws Exception {

HSSFWorkbook hssfworkbook = new HSSFWorkbook();

HSSFSheet hssfsheet = hssfworkbook.createSheet();

String downloadFileName = sellActivityTitle;

createSheetTableTile(hssfsheet,ExcelConstantTitle.sellActivityTitleMap,TEMPLET_CELL_COUNT);

downloadEXCEL(hssfworkbook, downloadFileName, request, response);

}

/**

* 提载

* @param hssfworkbook

* @param downloadFileName

* @param request

* @param response

* @throws Exception

private void downloadEXCEL(HSSFWorkbook hssfworkbook,

String downloadFileName, HttpServletRequest request,

HttpServletResponse response) throws Exception {

try {

//设置response,下载头设置

response.setContentType("application/vnd.ms-excel");

response.setHeader("content-disposition",

"attachment;filename=\""

new String(downloadFileName.getBytes("GBK"),

"ISO-8859-1") "\";size="

hssfworkbook.getBytes().length);

OutputStream out = response.getOutputStream();

//将工作簿输出到response

hssfworkbook.write(out);

out.flush();

out.close();

} catch (Exception e) {

throw new Exception(e);

}

/**

* 创建校验数据之后的模板

private void createValidateExcelAfterTemplet(HttpServletRequest request,

HttpServletResponse response,List list) throws Exception {

HSSFWorkbook hssfworkbook = new HSSFWorkbook();

HSSFSheet hssfsheet = hssfworkbook.createSheet();

// 创建正文

String downloadFileName = validateSellActivityAfterTitle;

createSheetTableTile(hssfsheet,ExcelConstantTitle.sellActivityTitleMap,VALIDATE_AFTER_CELL_COUNT);

//添加数据

addSheetContentList(hssfsheet,ExcelConstantTitle.sellActivityContentMap,list);

downloadEXCEL(hssfworkbook, downloadFileName, request, response);

}

/**

* 创建EXCEL表头

* @param hssfsheet

* @param titleMap

* @param size

* @return

private HSSFSheet createSheetTableTile(HSSFSheet hssfsheet,Map titleMap,int size){

// 创建正文

HSSFRow hssfrow = hssfsheet.createRow(0);

for (int i = 0; i < size; i ) {

// 设置列宽度

hssfsheet.setColumnWidth((short) i, (short) 4000);

HSSFCell hssfcell = hssfrow.createCell((short) i);

hssfcell.setEncoding(HSSFWorkbook.ENCODING_UTF_16);

switch (i) {

case 0: