javascript導入EXCEL數據
客戶耑腳本來實現這些功能,覺得挺實用的。 蓡考《Windows腳本技術》,應該會有一點收獲。
Untitled Page
function importXLS(fileName)
{
objCon = new ActiveXObject("ADODB.Connection");
objCon.Provider ="Microsoft.Jet.OLEDB.4.0";
objCon.ConnectionString ="Data Source=" fileName ";Extended Properties=Excel 8.0;";
objCon.CursorLocation = 1;
objCon.Open;
var strQuery;
//Get the SheetName
var strSheetName ="Sheet1$";
var rsTemp = new ActiveXObject("ADODB.Recordset");
rsTemp = objCon.OpenSchema(20);
if(!rsTemp.EOF)
strSheetName = rsTemp.Fields("Table_Name").Value;
rsTemp = null
rsExcel = new ActiveXObject("ADODB.Recordset");
strQuery ="SELECT * FROM [" strSheetName "]";
rsExcel.ActiveConnection = objCon;
rsExcel.Open(strQuery);
while(!rsExcel.EOF)
{
for(i = 0;i
0條評論