java.lang.NullPointerException: Cannot invoke method getCell() on null object

Web Testing
2

Hello, I am pasting the code here to have everything on the same place.

FileInputStream file = new FileInputStream (new File("E:\\Testdata.xlsx"))
XSSFWorkbook workbook = new XSSFWorkbook(file);
XSSFSheet sheet = workbook.getSheetAt(0);

'Read data from excel'
String Data_fromCell=sheet.getRow(1).getCell(1).getStringCellValue();
'Write data to excel'
sheet.getRow(1).createCell(1).setCellValue("Mahesh2");

file.close();
FileOutputStream outFile =new FileOutputStream(new File("E:\\Testdata.xlsx"));
workbook.write(outFile);
outFile.close();

The exception says that you are calling getCell() on null object. I’d say your sheet object is either null or empty. Can you check it?

String Data_fromCell=sheet.getRow(1).getCell(1).getStringCellValue();