JScript で Excel

Excel のシート名を列挙する (ADO)

lesson007.js

var cn = WScript.CreateObject("ADODB.Connection");

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

cn.ConnectionString = "Data Source=" + WScript.Arguments(0) + ";Extended Properties=Excel 8.0;";

cn.CursorLocation   = 3; // adUseClient

cn.Open;
var rs = cn.OpenSchema(20); // adSchemaTables

while (!rs.EOF)

{

    WScript.Echo(rs.Fields("TABLE_NAME").Value);

    rs.MoveNext;

}

rs.Close;
cn.Close;

実行結果

C:\>cscript c:\study\jscript\chapter004\lesson007.js c:\study\Book1.xls //nologo
Sheet1$

Sheet2$

Sheet3$