cn.afterturn.easypoi.view.MiniAbstractExcelView Maven / Gradle / Ivy
/**
* Copyright 2013-2015 JueYue ([email protected])
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package cn.afterturn.easypoi.view;
import cn.afterturn.easypoi.util.WebFilenameUtils;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.ss.usermodel.Workbook;
import jakarta.servlet.ServletOutputStream;
import jakarta.servlet.http.HttpServletRequest;
import jakarta.servlet.http.HttpServletResponse;
/**
* 基础抽象Excel View
* @author JueYue
* 2015年2月28日 下午1:41:05
*/
public abstract class MiniAbstractExcelView extends PoiBaseView {
private static final String CONTENT_TYPE = "text/html;application/vnd.ms-excel";
protected static final String HSSF = ".xls";
protected static final String XSSF = ".xlsx";
public MiniAbstractExcelView() {
setContentType(CONTENT_TYPE);
}
public void out(Workbook workbook, String codedFileName, HttpServletRequest request,
HttpServletResponse response) throws Exception {
if (workbook instanceof HSSFWorkbook) {
codedFileName += HSSF;
} else {
codedFileName += XSSF;
}
// 用工具类生成符合RFC 5987标准的文件名header, 去掉UA判断
response.setHeader("content-disposition", WebFilenameUtils.disposition(codedFileName));
ServletOutputStream out = response.getOutputStream();
workbook.write(out);
out.flush();
}
}