Here are multiple-choice questions (MCQs) on reading data from Excel files using Apache POI in Java. These questions cover key concepts, methods, and practices related to using Apache POI to handle Excel files.
1. What is Apache POI primarily used for in Java?
A) Parsing HTML documents
B) Managing database connections
C) Reading and writing Microsoft Office documents
D) Creating RESTful web services
Answer: C) Reading and writing Microsoft Office documents
2. Which Apache POI class is used to read an Excel .xlsx file?
A) HSSFWorkbook
B) XSSFWorkbook
C) ExcelWorkbook
D) WorkbookFactory
Answer: B) XSSFWorkbook
3. Which class in Apache POI is specifically used for handling Excel .xls files?
A) HSSFWorkbook
B) XSSFWorkbook
C) SXSSFWorkbook
D) POIWorkbook
Answer: A) HSSFWorkbook
4. Which interface in Apache POI represents a sheet in an Excel workbook?
A) XSSFSheet
B) HSSFSheet
C) Sheet
D) WorkbookSheet
Answer: C) Sheet
5. How do you create a Workbook object to read from an existing Excel file?
A) Workbook workbook = new Workbook("file.xlsx");
B) Workbook workbook = new XSSFWorkbook(new FileInputStream("file.xlsx"));
C) Workbook workbook = WorkbookFactory.create("file.xlsx");
D) Workbook workbook = Workbook.getInstance("file.xlsx");
Answer: B) Workbook workbook = new XSSFWorkbook(new FileInputStream("file.xlsx"));
6. Which Apache POI interface represents an individual cell in a spreadsheet?
A) Cell
B) XSSFCell
C) HSSFCell
D) SpreadsheetCell
Answer: A) Cell
7. How can you get the content of a cell as a string using Apache POI?
A) cell.toString();
B) cell.getText();
C) cell.getStringCellValue();
D) cell.getCellString();
Answer: C) cell.getStringCellValue();
8. What is the correct way to close a Workbook in Apache POI to avoid memory leaks?
A) workbook.close();
B) workbook.shutdown();
C) workbook.terminate();
D) workbook.dispose();
Answer: A) workbook.close();
9. To read numeric data from an Excel cell, which Apache POI method should be used?
A) cell.getNumberValue();
B) cell.getNumericCellValue();
C) cell.getIntValue();
D) cell.getDouble();
Answer: B) cell.getNumericCellValue();
10. Which method of the Row interface retrieves a specific cell in a row?
A) getCellAt(int index);
B) findCell(int index);
C) cell(int columnIndex);
D) getCell(int columnIndex);
Answer: D) getCell(int columnIndex);
11. How do you iterate over all rows in an Excel sheet using Apache POI?
A) for (Row row : sheet) { ... }
B) while(sheet.hasNextRow()) { ... }
C) forEach(Row row : sheet.getRows()) { ... }
D) sheet.forEach(row -> { ... });
Answer: A) for (Row row : sheet) { ... }
12. Which Apache POI class would you use to create a new blank Excel workbook in .xlsx format?
A) HSSFWorkbook
B) WorkbookFactory
C) SXSSFWorkbook
D) XSSFWorkbook
Answer: D) XSSFWorkbook
13. What is the method used to obtain the number of sheets in a Workbook?
A) workbook.getSheetCount();
B) workbook.getSheetTotal();
C) workbook.getNumberOfSheets();
D) workbook.getSheetSize();
Answer: C) workbook.getNumberOfSheets();
14. How do you access a sheet by its name in an Apache POI Workbook?
A) workbook.getSheetByName("Sheet1");
B) workbook.getSheet("Sheet1");
C) workbook.openSheet("Sheet1");
D) workbook.findSheet("Sheet1");
Answer: B) workbook.getSheet("Sheet1");
15. What exception is commonly thrown by Apache POI methods when reading from an Excel file?
A) IOException
B) SQLException
C) FileNotFoundException
D) ExcelParseException
Answer: A) IOException
16. How do you determine the type of data stored in an Excel cell using Apache POI?
A) cell.getDataType();
B) cell.getCellType();
C) cell.getType();
D) cell.getValueType();
Answer: B) cell.getCellType();
These MCQs cover fundamental concepts and methods used to read data from Excel files using Apache POI in Java, including handling different cell types, iterating through rows and cells, and managing workbooks and sheets.
No comments:
Post a Comment