Selenium : Fetch Data from Excel using Query (Better Version)

Fetch Data from Excel using Query  (Better Version)

Link to download JAR files for Apache POI : http://poi.apache.org/download.html#POI-3.9 and http://www.apache.org/dyn/closer.cgi/poi/release/bin/poi-bin-3.9-20121203.zip (might change according to the new update ).

Configuration :
http://catchbug.blogspot.in/2013/04/selenium-connect-to-excel-spreadsheet.html

public class Sample1

{

public static void main(String[] args)

{

Object oData=Excel.DB_Read("Datasheet", "Select Label,Xpath from [Sheet1$] where Module='Module 1'");

System.out.println(oData);

oData.toString();

}

}

class Excel{

public static Object DB_Read(String sWb,String sQuery)

{

try

{

Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");

Connection con = DriverManager.getConnection("jdbc:odbc:"+sWb);

Statement st = con.createStatement();

ResultSet rs = st.executeQuery(sQuery);

ResultSetMetaData rsmd = rs.getMetaData();

int numberOfColumns = rsmd.getColumnCount(); //Get Column Count

Object columnValue ="";// null;

while (rs.next())

{

for (int i = 1; i <= numberOfColumns; i++)

{

columnValue = columnValue+rs.getString(i);

if (i != numberOfColumns)

columnValue = columnValue+"|";

}

columnValue=columnValue+"\n";

}

st.close();

con.close();

return columnValue;

}

catch (Exception ex)

{

System.err.print("Exception: ");

System.err.println(ex.getMessage());

return null;

}

}

}