Set table starting row and column:
==========================
Syntax:
========
//Table start row
System.setProperty("ROW", "rownumber");
////Table start column
System.setProperty("COLUMN", "columnnumber");
//Example on Set table starting row and column
public class StTableDemo {
public static void main(String[] args) throws InterruptedException {
// Now set table start row and column
// Table start row
System.setProperty("ROW", "1");
// Table start column
System.setProperty("COLUMN", "4");
Fillo fillo = new Fillo();
Connection connection = fillo.getConnection("C:\\Ramesh\\Test.xlsx");
// with where method
Recordset recordset = connection.executeQuery("Select * from Sheet1")
.where("Name=Ramesh").where("Course='Selenium'");
connection.close();
}
}
==========================
Syntax:
========
//Table start row
System.setProperty("ROW", "rownumber");
////Table start column
System.setProperty("COLUMN", "columnnumber");
//Example on Set table starting row and column
public class StTableDemo {
public static void main(String[] args) throws InterruptedException {
// Now set table start row and column
// Table start row
System.setProperty("ROW", "1");
// Table start column
System.setProperty("COLUMN", "4");
Fillo fillo = new Fillo();
Connection connection = fillo.getConnection("C:\\Ramesh\\Test.xlsx");
// with where method
Recordset recordset = connection.executeQuery("Select * from Sheet1")
.where("Name=Ramesh").where("Course='Selenium'");
connection.close();
}
}
No comments:
Post a Comment