Forum Discussion
try
{
//var excelName = "C:\\TestData.xls"
var excelFileName = "Test"
var excelConnection = new Sys.OleObject("ADODB.Connection");
var str_Connection = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source = " + excelFileName + ";Persist Security Info=False;Extended Properties=Excel 8.0;"
excelConnection.Open(str_Connection);
var excel_recordSet = new Sys.OleObject("ADODB.Recordset");
var excelQuery = select * from login;(example)
excel_recordSet.Open(excelQuery, excelConnection);
if(!excel_recordSet.bof)
{
try
{
resultValue = aqConvert.VarToStr(excel_recordSet.fields.Item(ColumnName));
}
catch(e)
{
resultValue = undefined;
}
}
excel_recordSet.Close();
excelConnection.Close();