It belongs to the package and implements the Workbook interface. It is a class that is used to represent both high and low level Excel file formats. If you require these class methods, then refer POI-HSSFWorkbook class API at. Hence, the class methods of HSSFWorkbook are not listed here. In this tutorial, the focus is on the latest version of Excel file formats. Note − The HSSFWorkbook class contains a number of methods however they are compatible with xls format only. It consumes a lot of memory as it stores all the POIFileSystem in memory (if set). Preservenodes − This is an optional parameter that decides whether to preserve other nodes like macros. The frequently used parameters inside these constructors are −ĭirectory − It is the POI filesystem directory to process from.įs − It is the POI filesystem that contains the workbook stream. Given a POIFSFileSystem object, it creates a new HSSFWorkbook object to read a specified workbook. HSSFWorkbook(POIFSFileSystem fs, boolean preserveNodes)
HSSFWorkbook(java.io.InputStream s, boolean preserveNodes)Ĭonstructs a POI file system around your input stream.Ĭonstructs a new HSSFWorkbook object using a POIFSFileSystem object. Given a POIFSFileSystem object and a specific directory within it, it creates an SSFWorkbook object to read a specified workbook.Ĭreates a new HSSFWorkbook object using an input stream.
HSSFWorkbook(DirectoryNode directory, POIFSFileSystem fs, boolean preserveNodes) HSSFWorkbook(DirectoryNode directory, boolean preserveNodes)Ĭreates a new HSSFWworkbook objectinside a specific directory. Class Constructors Sr.No.Ĭreates a new HSSFWorkbook object from scratch. Listed below are some of the methods and constructors under this class. It implements the Workbook interface and is used for Excel files in. It is a high-level class under the .usermodel package. It is compatible with MS-Office versions 2007 or later. XSSFWorkbook − This class has methods to read and write Microsoft Excel and OpenOffice xml files in. It is compatible with MS-Office versions 97-2003. HSSFWorkbook − This class has methods to read and write Microsoft Excel files in. The two classes that implement this interface are as follows − This is the super-interface of all classes that create or maintain Excel workbooks. This chapter explains a few classes and methods under the Apache POI API that are critical to work on Excel files using Java programs.
0 kommentar(er)
