18 January 2026:


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.

Returns null while reading excel

kannankannan Members
edited December 2013 in Sahi - Open Source
Hi
I am reading excel using sahi opensource, but it is displaying null value (number formatted type).But i am able to get proper values for string formatted cells.

Below is my code

var $won = _getDB("sun.jdbc.odbc.JdbcOdbcDriver","jdbc:odbc:Driver={Microsoft Excel Driver (*.xls)};DBQ=C:\\Invoice.xls;readOnly=false","","");

var $emp = $won.select("select * from [Summary$]")

for(var $i=0; $i<$emp.length; $i++){
_alert($emp)

// i am getting null value excel row col number datatype

_alert($emp[$i][0])
// getting null (if excel row col is number type )
// getting proper value (if excel row col is text type)

}

kindly help me on this

Answers

Sign In or Register to comment.