Home / CSE MCQs / Apache POI ::

CSE MCQs :: Apache POI

  1. Which of the following is correct about XSSFWorkbook class in Apache POI?
  2. A.
    It is a class that is used to represent both high and low level Excel file formats
    B.
    It belongs to the org.apache.xssf.usemodel package
    C.
    It implements the Workbook interface
    D.
    All of the above

  3. Which of the following is a valid way to compute max in a formula cell?
  4. A.
    cell.setCellValue("MAX(C2:C3)")
    B.
    cell.setCellValue("MAX_VALUE(C2:C3)")
    C.
    cell.setCellValue("MAXIMUM(C2:C3)")
    D.
    None of the above

  5. What are the steps to create a cell in a spreadsheet in Apache POI?
  6. A.
    //create new workbook
    B.
    XSSFWorkbook workbook = new XSSFWorkbook();
    C.
    //create spread sheet with a name
    D.
    XSSFSheet spreadsheet = workbook.createSheet("new sheet");
    E.
    All the above

  7. What are the features of the Apache POI?
  8. A.
    Apache POI provides stream-based processing, that is suitable for large files and requires less memory
    B.
    Apache POI is able to handle both XLS and XLSX formats of spreadsheets
    C.
    Apache POI contains HSSF implementation for Excel '97(-2007) file format i.e XLS
    D.
    All of these

  9. What are the commonly used components of Apache POI?
  10. A.
    HSSF
    B.
    XSSF
    C.
    POIFS
    D.
    All of the above

  11. What are the jar files minimum to run the sample code?
  12. A.
    poi-3.10-FINAL.jar
    B.
    poi-ooxml-3.10-FINAL.jar
    C.
    commons-codec-1.5.jar
    D.
    poi-ooxml-schemas-3.10-FINAL.jar
    E.
    All of these

  13. Which of the following is correct about XSSFPrintSetup class in Apache POI?
  14. A.
    This is a class under the org.apache.poi.xssf.usermodel package
    B.
    It is used to set print page size, area, options, and settings
    C.
    It implements the PrintSetup interface
    D.
    All of the above

  15. Which of the following type of cell represents number cell in Apache POI?
  16. A.
    XSSFCell.Cell_Type_Numeric
    B.
    XSSFCell.Cell_Numeric
    C.
    XSSFCell.Numeric
    D.
    None of the above

  17. What are the advantages of Apache POI?
  18. A.
    JExcel doesn't support xlsx format whereas POI supports both xls and xlsx formats
    B.
    Apache POI provides stream-based processing, that is suitable for large files and requires less memory
    C.
    Apache POI provides excellent support for working with Microsoft Excel documents and it's able to handle both XLS and XLSX formats of spreadsheets
    D.
    All of the above