Package org.apache.poi.xssf.usermodel

Class XSSFSheetHelper

java.lang.Object

org.apache.poi.xssf.usermodel.XSSFSheetHelper

public class XSSFSheetHelper
extends Object

A XSSF Sheet helper to access some protected APIs

Author:

jumperchen

Constructor Summary

Constructors

Constructor	Description
XSSFSheetHelper()

Method Summary

Modifier and Type	Method	Description
static void	addConditionalFormattingToExtensionList(org.apache.poi.xssf.usermodel.XSSFSheet sheet, ConditionalFormatting cf, Map<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule,String> extRuleIdMap)
static org.openxmlformats.schemas.spreadsheetml.x2006.main.CTAutoFilter	getCTAutoFilter(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
static SheetProtection	getOrCreateSheetProtection(org.apache.poi.xssf.usermodel.XSSFSheet sheet)
static void	protectSheet(org.apache.poi.xssf.usermodel.XSSFSheet sheet, String password)
static void	setPrintHeadings(org.apache.poi.xssf.usermodel.XSSFSheet sheet, boolean value)
static void	setSheetPassword(org.apache.poi.xssf.usermodel.XSSFSheet sheet, String saltValue, String hashValue, String spinCount, String algName)
static void	setSheetPasswordHash(org.apache.poi.xssf.usermodel.XSSFSheet sheet, short hashpass)
static void	setSparkline(org.apache.poi.xssf.usermodel.XSSFSheet sheet, String valuesFormula, String anchor, String type, boolean isWinlose, boolean firstVisible, boolean lastVisible, boolean highVisible, boolean lowVisible, boolean negativeVisible, boolean markersVisible, String seriesColor, String firstColor, String lastColor, String highColor, String lowColor, String negativeColor, String markersColor)
static void	unsetSheetProtection(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

Methods inherited from class java.lang.Object

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

Constructor Detail

XSSFSheetHelper

public XSSFSheetHelper()

Method Detail

setSheetPasswordHash

public static void setSheetPasswordHash(org.apache.poi.xssf.usermodel.XSSFSheet sheet,
                                        short hashpass)

setSheetPassword

public static void setSheetPassword(org.apache.poi.xssf.usermodel.XSSFSheet sheet,
                                    String saltValue,
                                    String hashValue,
                                    String spinCount,
                                    String algName)

unsetSheetProtection

public static void unsetSheetProtection(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

setSparkline

public static void setSparkline(org.apache.poi.xssf.usermodel.XSSFSheet sheet,
                                String valuesFormula,
                                String anchor,
                                String type,
                                boolean isWinlose,
                                boolean firstVisible,
                                boolean lastVisible,
                                boolean highVisible,
                                boolean lowVisible,
                                boolean negativeVisible,
                                boolean markersVisible,
                                String seriesColor,
                                String firstColor,
                                String lastColor,
                                String highColor,
                                String lowColor,
                                String negativeColor,
                                String markersColor)

addConditionalFormattingToExtensionList

public static void addConditionalFormattingToExtensionList(org.apache.poi.xssf.usermodel.XSSFSheet sheet,
                                                           ConditionalFormatting cf,
                                                           Map<org.openxmlformats.schemas.spreadsheetml.x2006.main.CTCfRule,String> extRuleIdMap)

getOrCreateSheetProtection

public static SheetProtection getOrCreateSheetProtection(org.apache.poi.xssf.usermodel.XSSFSheet sheet)

setPrintHeadings

public static void setPrintHeadings(org.apache.poi.xssf.usermodel.XSSFSheet sheet,
                                    boolean value)

protectSheet

public static void protectSheet(org.apache.poi.xssf.usermodel.XSSFSheet sheet,
                                String password)

getCTAutoFilter

public static org.openxmlformats.schemas.spreadsheetml.x2006.main.CTAutoFilter getCTAutoFilter(org.apache.poi.xssf.usermodel.XSSFSheet sheet)