Uses of Class
org.apache.poi.xssf.usermodel.XSSFWorkbook
Packages that use XSSFWorkbook
Package
Description
-
Uses of XSSFWorkbook in org.apache.poi.xddf.usermodel.chart
Methods in org.apache.poi.xddf.usermodel.chart that return XSSFWorkbookMethods in org.apache.poi.xddf.usermodel.chart with parameters of type XSSFWorkbookModifier and TypeMethodDescriptionvoidXDDFChart.saveWorkbook(XSSFWorkbook workbook) this method write the XSSFWorkbook object data into embedded excel filevoidXDDFChart.setWorkbook(XSSFWorkbook workbook) while reading chart from template file then we need to parse and store embedded excel file in chart object show that we can modify value according to use -
Uses of XSSFWorkbook in org.apache.poi.xssf
Methods in org.apache.poi.xssf that return XSSFWorkbookModifier and TypeMethodDescriptionstatic XSSFWorkbookParse the given InputStream and return a newXSSFWorkbookinstance.static XSSFWorkbookXSSFParser.parse(InputStream stream) Parse the given InputStream and return a newXSSFWorkbookinstance.static XSSFWorkbookXSSFParser.parse(InputStream stream, boolean closeStream) Parse the given InputStream and return a newXSSFWorkbookinstance.static XSSFWorkbookXSSFParser.parse(OPCPackage pkg) Parse the givenOPCPackageand return a newXSSFWorkbookinstance.static XSSFWorkbookXSSFParser.parse(PackagePart packagePart) Parse the givenPackagePartand return a newXSSFWorkbookinstance. -
Uses of XSSFWorkbook in org.apache.poi.xssf.extractor
Methods in org.apache.poi.xssf.extractor that return XSSFWorkbookModifier and TypeMethodDescriptionXSSFExcelExtractor.getDocument()XSSFExcelExtractor.getFilesystem()Constructors in org.apache.poi.xssf.extractor with parameters of type XSSFWorkbook -
Uses of XSSFWorkbook in org.apache.poi.xssf.model
Methods in org.apache.poi.xssf.model that return XSSFWorkbookMethods in org.apache.poi.xssf.model with parameters of type XSSFWorkbook -
Uses of XSSFWorkbook in org.apache.poi.xssf.streaming
Fields in org.apache.poi.xssf.streaming declared as XSSFWorkbookMethods in org.apache.poi.xssf.streaming that return XSSFWorkbookConstructors in org.apache.poi.xssf.streaming with parameters of type XSSFWorkbookModifierConstructorDescriptionDeferredSXSSFWorkbook(XSSFWorkbook workbook) DeferredSXSSFWorkbook(XSSFWorkbook workbook, int rowAccessWindowSize) SXSSFWorkbook(XSSFWorkbook workbook) Construct a workbook from a template.SXSSFWorkbook(XSSFWorkbook workbook, int rowAccessWindowSize) Constructs a workbook from an existing workbook.SXSSFWorkbook(XSSFWorkbook workbook, int rowAccessWindowSize, boolean compressTmpFiles) Constructs a workbook from an existing workbook.SXSSFWorkbook(XSSFWorkbook workbook, int rowAccessWindowSize, boolean compressTmpFiles, boolean useSharedStringsTable) Constructs a workbook from an existing workbook. -
Uses of XSSFWorkbook in org.apache.poi.xssf.usermodel
Fields in org.apache.poi.xssf.usermodel declared as XSSFWorkbookMethods in org.apache.poi.xssf.usermodel that return XSSFWorkbookModifier and TypeMethodDescriptionXSSFWorkbookFactory.create()Create a new empty WorkbookCreates the XSSFWorkbook from the given File, which must exist and be readable.XSSFWorkbookFactory.create(InputStream stream) Creates a XSSFWorkbook from the given InputStreamXSSFWorkbookFactory.create(DirectoryNode root, String password) static XSSFWorkbookXSSFWorkbookFactory.createWorkbook(OPCPackage pkg) Creates a XSSFWorkbook from the given OOXML PackageXSSFSheet.getWorkbook()Returns the parent XSSFWorkbookMethods in org.apache.poi.xssf.usermodel with parameters of type XSSFWorkbookModifier and TypeMethodDescriptionstatic XSSFEvaluationWorkbookXSSFEvaluationWorkbook.create(XSSFWorkbook book) static XSSFFormulaEvaluatorXSSFFormulaEvaluator.create(XSSFWorkbook workbook, IStabilityClassifier stabilityClassifier, UDFFinder udfFinder) static voidXSSFFormulaEvaluator.evaluateAllFormulaCells(XSSFWorkbook wb) Loops over all cells in all sheets of the supplied workbook.static intXSSFOptimiser.optimiseCellStyles(XSSFWorkbook workbook) Goes through the Workbook, optimising the cell styles by remapping cells that use duplicate styles to use the canonical (first) occurrence.static intXSSFOptimiser.optimiseFonts(XSSFWorkbook workbook) Goes through the Workbook, optimising the fonts by updating cell styles that reference duplicate fonts to use the canonical (first) occurrence.voidXSSFWorkbook.setVBAProject(XSSFWorkbook macroWorkbook) Adds a vbaProject.bin file taken from another, given workbook to this one.Constructors in org.apache.poi.xssf.usermodel with parameters of type XSSFWorkbookModifierConstructorDescriptionprotectedShould only be called bygetCreationHelper()XSSFFormulaEvaluator(XSSFWorkbook workbook) protectedXSSFFormulaEvaluator(XSSFWorkbook workbook, WorkbookEvaluator bookEvaluator) protectedXSSFName(org.openxmlformats.schemas.spreadsheetml.x2006.main.CTDefinedName name, XSSFWorkbook workbook) Creates an XSSFName object - called internally by XSSFWorkbook. -
Uses of XSSFWorkbook in org.apache.poi.xssf.usermodel.helpers
Constructors in org.apache.poi.xssf.usermodel.helpers with parameters of type XSSFWorkbook