Read date from excel
To handle an Excel sheet date with an online website date using Selenium and Java, you can use the Apache POI library to read data from the Excel sheet and compare it with the date obtained from the website. Here's an example:
```java
import org.apache.poi.ss.usermodel.*;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
import org.openqa.selenium.By;
import org.openqa.selenium.WebDriver;
import org.openqa.selenium.chrome.ChromeDriver;
import java.io.FileInputStream;
import java.time.LocalDate;
import java.time.format.DateTimeFormatter;
public class ExcelDateComparator {
public static void main(String[] args) {
// Set the path to chromedriver.exe
System.setProperty("webdriver.chrome.driver", "path/to/chromedriver.exe");
// Create a new instance of ChromeDriver
WebDriver driver = new ChromeDriver();
try {
// Launch the web page
driver.get("http://example.com");
// Load the Excel workbook
FileInputStream file = new FileInputStream("path/to/excel_file.xlsx");
Workbook workbook = new XSSFWorkbook(file);
// Read the date from Excel sheet
Sheet sheet = workbook.getSheet("Sheet1");
Row row = sheet.getRow(0); // Assuming the date is in the first row
Cell cell = row.getCell(0); // Assuming the date is in the first column
LocalDate excelDate = cell.getLocalDateTimeCellValue().toLocalDate();
// Get the website date
String websiteDateText = driver.findElement(By.id("date-element")).getText();
LocalDate websiteDate = LocalDate.parse(websiteDateText, DateTimeFormatter.ofPattern("yyyy-MM-dd"));
// Compare the dates
if (excelDate.equals(websiteDate)) {
System.out.println("Dates match!");
} else {
System.out.println("Dates do not match!");
}
// Close the workbook and browser
workbook.close();
driver.quit();
} catch (Exception e) {
e.printStackTrace();
}
}
}
```
Make sure to replace `"path/to/chromedriver.exe"` with the actual path to the `chromedriver.exe` file on your system. Also, modify the web page URL, `date-element` ID, and the Excel file path (`path/to/excel_file.xlsx`) based on your specific scenario.
In this example, we use Apache POI to read the date from the Excel sheet. We assume that the date is located in the first row and first column of the "Sheet1" worksheet. We then extract the date from the website using Selenium by locating the corresponding element and parsing it into a `LocalDate` object.
Finally, we compare the two dates and print a message indicating whether they match or not. Remember to handle any exceptions that may occur during the process.
Comments
Post a Comment