18 January 2026:
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
This forum is now archived and is in read-only mode. Please continue discussions on our improved new Sahi Pro Community forum.
Sahi Pro is an enterprise grade test automation platform which can automate web, mobile, API, windows and java based applications and SAP.
Specific select in excel using where clause
lonely_girl01
Members
Hi,
I've searched the forum for some queries but didn't find any.
Anyways, i have this code:
My select doesn't work.
attributes.xls contains:
[Sheet1]
id name
1 Paper
2 Size
3 Type
I've searched the forum for some queries but didn't find any.
Anyways, i have this code:
var $db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)}; DBQ=C:/attributes.xls;readOnly=false", "", "");
var $attributes = $db.select("select id from [Sheet1$] WHERE name='Paper'");
My select doesn't work.
attributes.xls contains:
[Sheet1]
id name
1 Paper
2 Size
3 Type