ExelでADO

すっごい簡単なんだ。

var file = "data.xls";

Enumerator.prototype.each = function(f){
	this.moveFirst();
	for(; !this.atEnd(); this.moveNext())
		f(this.item());
};

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

cn.Provider = "Microsoft.Jet.OLEDB.4.0";
cn.ConnectionString = "Data Source=" + file + ";" + "Extended Properties=Excel 8.0;";
cn.Open();

var q = "SELECT * FROM [Sheet1$A4:AV90]";
var rs = cn.Execute(q);

while(!rs.EOF){
	(new Enumerator(rs.Fields)).each(function(item){
		if(item.Value != null)
			WSH.Echo(item.Name, item.Value);
	});
	rs.MoveNext();
}

酔っ払ったときにADOの素晴らしさを語らないように！（というかそんな風に思わないし）