I have data sheet and I need to read data for the data sheet by row wise
as example Information Security Refresher: Malicious Links S.17
So the code need to be select country and get the data based on selected country.
@kshaharier A suggestion would be to open a link to the Excel sheet and then read in the “select country”, then loop through the data “based on selected country”.
FileInputStream fis = new FileInputStream (GlobalVariable.gPathWay);
XSSFWorkbook workbook = new XSSFWorkbook (fis);
XSSFSheet sheet = workbook.getSheet(“Sheet1”);
‘Loop will execute for all the rows of the table’
Loop:
for (int crow = 0; crow < country_count; crow++)
{
// cell A2
Row row = sheet.getRow(1);
Cell cell = row.getCell(0);
countryPart = cell.getStringCellValue();