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;
}