The two mainly used classes for managing Excel Workbooks are: There are certain classes that implement this interface and we use these classes to create, modify, read, and write data in Excel files.
It provides a "Workbook " interface to maintain Excel Workbooks.
Let's now understand how we can access and manage various components in an Excel file using Apache POI ? How to manage Excel workbooks pragmatically?Īpache POI provides various interfaces and classes that help us to work with Excel. The below image clearly depicts the structure and how the classes and interfaces are aligned in Apache POI.
You can download the Apache POI library by referring to Steps to Download Apache POI. Data can be of the type such as string, numeric value, or formula.īefore we start, the first step is to download the jar files required to use the library. Data entered by a user is stored in a cell. A workbook may contain many sheets.Ī sheet refers to a page in a Microsoft Excel file that contains the number of rows and columns.Ī row represents a collection of cells, which is used to represent a row in the spreadsheet.Ī cell is indicated by a row and column combination. It can be used for creating and maintaining the spreadsheet. TermĪ workbook represents a Microsoft Excel file. Let's get familiar with these before we go into the details of the code.
Now, we know that these web applications are used by multiple users, and each one of those uses the applications as per their own data. Selenium WebDriver is the most used automation tool for the automation of web applications.