public class ExcelUtils {
public static String[] readData() throws EncryptedDocumentException, InvalidFormatException, IOException {
String path ="src/test/java/testdata.xlsx";
String[] values = new String[2];
Workbook workbook = WorkbookFactory.create(new File(path));
Sheet sheet = workbook.getSheet("Sheet1");
for (int i = 1; i < 3; i++) {
Row row =sheet.getRow(i);
Cell cell = row.getCell(0);
cell.setCellType(CellType.STRING);
values[i-1]=cell.getStringCellValue();
}
return values;
}
}