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.
Problem reading chinese character from excel
Hi forum,
Sahi Version : 5.1.0
Excel Version : 2007
I have an excel sheet that contains Chinese values and when I am trying to retrieve those values from excel using select query it is giving as '???'. Is there any solution for this?
This is the data I have in excel
| Seq ID | Name |
| 1 | 汉语漢語 |
Below is my code
$workbookLocation="C:/Users/admin/Desktop"
$workbookName="i18n.xls"
var $db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + $workbookLocation + "/" + $workbookName + ";readOnly=false", "","");
var $rsForActions=$db.select("select * from [Sheet1$]");
_alert($rsForActions);
Output is shown as "1.0","????"
Regards,
PS
Sahi Version : 5.1.0
Excel Version : 2007
I have an excel sheet that contains Chinese values and when I am trying to retrieve those values from excel using select query it is giving as '???'. Is there any solution for this?
This is the data I have in excel
| Seq ID | Name |
| 1 | 汉语漢語 |
Below is my code
$workbookLocation="C:/Users/admin/Desktop"
$workbookName="i18n.xls"
var $db = _getDB("sun.jdbc.odbc.JdbcOdbcDriver", "jdbc:odbc:Driver={Microsoft Excel Driver (*.xls, *.xlsx, *.xlsm, *.xlsb)};DBQ=" + $workbookLocation + "/" + $workbookName + ";readOnly=false", "","");
var $rsForActions=$db.select("select * from [Sheet1$]");
_alert($rsForActions);
Output is shown as "1.0","????"
Regards,
PS
Answers