René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"I am not able to get data from Excel to testng class","articleBody":"public class Readandwrite {\r\n\t\r\n\t\r\n\r\n\tpublic static void main(String[] args) throws IOException {\t\r\n\t\t\r\n\t\t\r\n\t      Workbook wb = new XSSFWorkbook();\r\n\t\t FileOutputStream f = new FileOutputStream(\"C:\\\\Users\\\\Desktop\\\\Selenium\\\\FileHandling\\\\MyExcelSheet.xlsx\");\r\n\t\t Sheet s = wb.createSheet(\"MySheet\");\r\n\t\t s.createRow(0).createCell(0).setCellValue(\"abc@facebook.com\");\r\n\t\t s.getRow(0).createCell(1).setCellValue(\"abc123\");\r\n\t\t wb.write(f);\r\n\t\t\r\n\t\t\r\n\t\r\n\t//public static void read() throws IOException {\r\n\t\r\n\t\t File S = new File(\"C:\\\\Users\\\\Desktop\\\\Selenium\\\\FileHandling\\\\MyExcelSheet.xlsx\");\r\n\t\t FileInputStream input = new FileInputStream(S);\r\n\t\t XSSFWorkbook wb1 = new XSSFWorkbook(input);\r\n\t\t XSSFSheet Sh = wb1.getSheet(\"MySheet\");\r\n\t\t\r\n\t\t \r\n\t}}\r\n\r\n\r\n\r\n\r\n\r\npublic class ReadandWrite2 extends Readandwrite {\r\n\tChromeDriver cd;\r\n\t\r\n\r\n//@Parameters ({\"UserName\",\"pass\"})\r\n@BeforeTest\r\npublic void ReadandWriteExcel() {\r\n\r\n\t\r\n\tSystem.setProperty(\"webdriver.chrome.driver\",\"C:\\\\Users\\Desktop\\\\Selenium\\\\chromedriver_win32\\\\chromedriver.exe\");\r\n\t cd=new ChromeDriver();\r\n\t cd.get(\"https://www.facebook.com/login.php\");\t\r\n\t\t\t\t\r\n}\r\n\r\n@Test\r\npublic void usernameandpassword()  {\r\n\tWebElement UserName=cd.findElement(By.id(\"email\"));\r\n\tWebElement pass= cd.findElement(By.id(\"pass\"));\r\n\tUserName.sendKeys(Sh.getRow(1).getCell(0).getStringCellValue());//Error\r\n\tpass.sendKeys(Sh.getRow(1).getCell(1).getStringCellValue());//Error\r\n\tcd.findElement(By.xpath(\"//*[@id=\\\"loginbutton\\\"]\")).click();\r\n\t\r\n}}\r\n\t","author":{"url":"https://github.com/Ojasadi","@type":"Person","name":"Ojasadi"},"datePublished":"2021-01-25T04:12:12.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":2},"url":"https://github.com/24/testng-browserstack/issues/24"}