Java Class 38 By Rahul Data reading from Excel file 1/5/2023 скачать в хорошем качестве

Java Class 38 By Rahul Data reading from Excel file 1/5/2023

public static String readExcel(String path,int sheetNum,int Row, int Cell) throws Exception { FileInputStream fis = new FileInputStream(path); XSSFWorkbook wb = new XSSFWorkbook(fis); XSSFSheet sh = wb.getSheetAt(sheetNum); XSSFRow row = sh.getRow(Row); XSSFCell cell = row.getCell(Cell); String value = cell.getStringCellValue(); return value; } public static void main(String[] args) throws Exception { String filePath = "D:\\Automation\\demo\\TestData\\regDetails.xlsx"; Scanner sc = new Scanner(System.in); int sheet = sc.nextInt(); int row = sc.nextInt(); int cell = sc.nextInt(); sc.close(); String data = readExcel(filePath,sheet,row,cell); System.out.println(data); }