Good guys I need your help I want to edit an excel document but I still can not get it to edit in some of the columns what I do is read the URLs directly and then open them from an excel
public void read_excel_update() throws Exception, IOException {
ExcelHelper exhelp = new ExcelHelper();
Sheet zipSheet = null;
zipSheet = exhelp.openSheet(
"../SlingTools/src/main/resources/urlTestCopy.xlsx", 0);
int length = exhelp.getSheetLength(zipSheet);
for (int i = 0; i <= length; i++) {
homepageLogin("");
Row row = zipSheet.getRow(i);
String excelURL = row.getCell(0).toString();
if (excelURL == row.getCell(0).toString()) {
homepageLogin(excelURL);
}
if (alacartetvBillingPage.find(By.xpath(row.getCell(1).toString())).isVisible()) {
} else {
System.out.println("false");
}
}
}
If they could help me I use excelhelper what I want is that in cell c1 to 5 they tell me Available and as the condition appears if there is no one that says not available and I tried several editors but I could not do it I hope you can help me