com.fr.web.core.utils

类 ExportUtils

java.lang.Object

com.fr.web.core.utils.ExportUtils

public class ExportUtils
extends java.lang.Object

Created by IntelliJ IDEA. Author : Richer Version: 6.5.6 Date: 12-3-16 Time: 下午2:15 导出工具类，主要用于Excel导出，PDF导出等

方法概要

方法

限定符和类型	方法和说明
static void	applyReportHFFooter(ReportHFProvider reportHF, POIHeaderFooterAction footer) 将报表中的页脚对象设置apply到POI对象中
static void	applyReportHFHeader(ReportHFProvider reportHF, POIHeaderFooterAction header) 将报表中的页眉对象设置apply到POI对象中
static java.lang.Object	checkExcel2007NumberFormat(java.text.Format cFormat, java.lang.Object value)
static java.lang.Object	checkNumberFormat(java.text.Format cFormat, java.lang.Object value)
protected static java.lang.String	createHFString(java.util.List list) 根据页眉页脚对象列表, 转成字符串形式
static void	dealWithAlignAndMargin(POISheetAction sheet, ReportSettingsProvider reportSettings, Margin margin) 设置是否垂直水平居中, 以及边距
static void	dealWithBufferImage(java.lang.Object value, POIClientAnchorAction clientAnchor, POIPatriarchAction patriarch, java.awt.image.BufferedImage buffImg, POIWorkbookAction wb) 将BufferImage转化成excel中的悬浮元素
static void	dealWithPrintSetUp(POIPrintSetupAction printSetup, PaperSize paperSize, int orientation, ReportSettingsProvider reportSettings) 导出当前报表的打印设置到excel, 包括纸张, 横纵向, 页眉页脚距离
static int	loadPicture(java.awt.image.BufferedImage bufferedImage, POIWorkbookAction wb)
static java.lang.String	replaceNewLineChar(java.lang.String allString) peter:替换成newline
static void	setCPTContext(javax.servlet.http.HttpServletResponse res, java.lang.String fileName)
static void	setCSVContext(javax.servlet.http.HttpServletResponse res, java.lang.String fileName) setCSVContext&Header
static void	setExcel2007Content(javax.servlet.http.HttpServletResponse res, java.lang.String fileName)
static void	setExcelContent(javax.servlet.http.HttpServletResponse res, java.lang.String fileName) setExcelContext&Header
static void	setHTMLContext(javax.servlet.http.HttpServletResponse res, java.lang.String fileName)
static void	setImageContext(javax.servlet.http.HttpServletResponse res, java.lang.String fileName, java.lang.String imagetype)
static void	setPDFContent(javax.servlet.http.HttpServletResponse res, java.lang.String fileName, boolean isEmbbed) setPDFContent&Header
static void	setSheetName(POIWorkbookAction wb, java.lang.String name4Sheet) 设置Excelsheet的名字, 同时避免在Workbook中出现重命名现象 限定长度为31个字符
static void	setSVGContext(javax.servlet.http.HttpServletResponse res, java.lang.String fileName) setSVGContext&Header
static void	setTextContext(javax.servlet.http.HttpServletResponse res, java.lang.String fileName) setTextContext
static void	setWordConetent(javax.servlet.http.HttpServletResponse res, java.lang.String fileName) setWordContext&Header
static void	setZipContext(javax.servlet.http.HttpServletResponse res, java.lang.String fileName, boolean isSetContextTypeOnZipDownload) setZipContext&Header

从类继承的方法 java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

方法详细资料

dealWithBufferImage

public static void dealWithBufferImage(java.lang.Object value,
                       POIClientAnchorAction clientAnchor,
                       POIPatriarchAction patriarch,
                       java.awt.image.BufferedImage buffImg,
                       POIWorkbookAction wb)

将BufferImage转化成excel中的悬浮元素

参数:

value - 当前悬浮元素

clientAnchor - excel中定位元素

patriarch - excel中的悬浮元素

buffImg - 待转化的BufferImage

wb - 当前excel工作表

setSheetName

public static void setSheetName(POIWorkbookAction wb,
                java.lang.String name4Sheet)

设置Excelsheet的名字, 同时避免在Workbook中出现重命名现象 限定长度为31个字符

参数:

wb - 当前的Excel Book

name4Sheet - 指定的sheet名

dealWithPrintSetUp

public static void dealWithPrintSetUp(POIPrintSetupAction printSetup,
                      PaperSize paperSize,
                      int orientation,
                      ReportSettingsProvider reportSettings)

导出当前报表的打印设置到excel, 包括纸张, 横纵向, 页眉页脚距离

参数:

printSetup - excel中的打印设置

paperSize - 报表中的纸张设置

orientation - 横纵向显示

reportSettings - 报表页面设置

dealWithAlignAndMargin

public static void dealWithAlignAndMargin(POISheetAction sheet,
                          ReportSettingsProvider reportSettings,
                          Margin margin)

设置是否垂直水平居中, 以及边距

参数:

sheet - 导出的poisheet

reportSettings - 报表页面设置

margin - 边距

applyReportHFHeader

public static void applyReportHFHeader(ReportHFProvider reportHF,
                       POIHeaderFooterAction header)

将报表中的页眉对象设置apply到POI对象中

参数:

header - POI中的页眉

reportHF - 报表中的页眉

applyReportHFFooter

public static void applyReportHFFooter(ReportHFProvider reportHF,
                       POIHeaderFooterAction footer)

将报表中的页脚对象设置apply到POI对象中

参数:

footer - POI中的页脚

reportHF - 报表中的页脚

createHFString

protected static java.lang.String createHFString(java.util.List list)

根据页眉页脚对象列表, 转成字符串形式

参数:

list - 页眉页脚对象列表

replaceNewLineChar

public static java.lang.String replaceNewLineChar(java.lang.String allString)

peter:替换成newline

loadPicture

public static int loadPicture(java.awt.image.BufferedImage bufferedImage,
              POIWorkbookAction wb)
                       throws java.io.IOException

抛出:

java.io.IOException

checkNumberFormat

public static java.lang.Object checkNumberFormat(java.text.Format cFormat,
                                 java.lang.Object value)

checkExcel2007NumberFormat

public static java.lang.Object checkExcel2007NumberFormat(java.text.Format cFormat,
                                          java.lang.Object value)

setPDFContent

public static void setPDFContent(javax.servlet.http.HttpServletResponse res,
                 java.lang.String fileName,
                 boolean isEmbbed)

setPDFContent&Header

参数:

res -

isEmbbed -

fileName -

setExcelContent

public static void setExcelContent(javax.servlet.http.HttpServletResponse res,
                   java.lang.String fileName)

setExcelContext&Header

参数:

res -

fileName -

setExcel2007Content

public static void setExcel2007Content(javax.servlet.http.HttpServletResponse res,
                       java.lang.String fileName)

setWordConetent

public static void setWordConetent(javax.servlet.http.HttpServletResponse res,
                   java.lang.String fileName)

setWordContext&Header

参数:

res -

fileName -

setZipContext

public static void setZipContext(javax.servlet.http.HttpServletResponse res,
                 java.lang.String fileName,
                 boolean isSetContextTypeOnZipDownload)

setZipContext&Header

参数:

res -

fileName -

isSetContextTypeOnZipDownload -

setSVGContext

public static void setSVGContext(javax.servlet.http.HttpServletResponse res,
                 java.lang.String fileName)

setSVGContext&Header

参数:

res -

fileName -

setCSVContext

public static void setCSVContext(javax.servlet.http.HttpServletResponse res,
                 java.lang.String fileName)

setCSVContext&Header

参数:

res -

fileName -

setTextContext

public static void setTextContext(javax.servlet.http.HttpServletResponse res,
                  java.lang.String fileName)

setTextContext

参数:

res -

fileName -

setImageContext

public static void setImageContext(javax.servlet.http.HttpServletResponse res,
                   java.lang.String fileName,
                   java.lang.String imagetype)

setCPTContext

public static void setCPTContext(javax.servlet.http.HttpServletResponse res,
                 java.lang.String fileName)

setHTMLContext

public static void setHTMLContext(javax.servlet.http.HttpServletResponse res,
                  java.lang.String fileName)