js导入excel数据显示html界面,js import excel显示数据在页面

Untitled Page

function importXLS(fileName)

{

objCon = new ActiveXObject("ADODB.Connection");alert(123123);

objCon.Provider = "Microsoft.Jet.OLEDB.4.0";

objCon.ConnectionString = "Data Source=" + fileName + ";Extended Properties=Excel 8.0;";

objCon.CursorLocation = 1;

objCon.Open;

var strQuery;

var strSheetName = "Sheet1$";

var rsTemp = new ActiveXObject("ADODB.Recordset");

rsTemp = objCon.OpenSchema(20);

while(!rsTemp.EOF)

{

if (rsTemp("TABLE_TYPE")=="TABLE")

{

//alert(rsTemp("TABLE_NAME"));

rsExcel = new ActiveXObject("ADODB.Recordset");

strQuery = "SELECT * FROM [" + rsTemp("TABLE_NAME") + "]";

rsExcel.ActiveConnection = objCon;

rsExcel.Open(strQuery);

mm=rsTemp("TABLE_NAME")+"表内容

for(i = 0;i

{

mm=mm+"

"+rsExcel.Fields(i).name+"";

}

while(!rsExcel.EOF)

{

mm=mm+"

"

for(i = 0;i

{

mm=mm+"

"+rsExcel.Fields(i).value+"";

}

mm=mm+"

"

rsExcel.MoveNext;

}

}

document.write(mm+"

")

mm=""

rsExcel = null

rsTemp.MoveNext;

}

objCon.Close;

objCon =null;

rsExcel = null;

}