Please note that Sahi's development and support teams do not actively monitor this. This is more a community forum. If you are a Sahi Pro user looking for commercial support, please email support @ sahipro.com with your query.

Problem reading chinese character from excel

PSPS Members
edited December 2013 in Sahi Pro
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

Answers

Sign In or Register to comment.