jscript之Read an Excel Spreadsheet

240 阅读 0 评论 159 点赞

我是靠谱客的博主火星上悟空，最近开发中收集的这篇文章主要介绍jscript之Read an Excel Spreadsheet，觉得挺不错的，现在分享给大家，希望可以做个参考。

概述

Description

Demonstration script that reads the values stored in a spreadsheet
named C:ScriptsNew_users.xls.
Script Code

复制代码代码如下:

Set objExcel = CreateObject("Excel.Application") 
Set objWorkbook = objExcel.Workbooks.Open _ 
    ("C:ScriptsNew_users.xls") 

intRow = 2 

Do Until objExcel.Cells(intRow,1).Value = "" 
    Wscript.Echo "CN: " & objExcel.Cells(intRow, 1).Value 
    Wscript.Echo "sAMAccountName: " & objExcel.Cells(intRow, 2).Value 
    Wscript.Echo "GivenName: " & objExcel.Cells(intRow, 3).Value 
    Wscript.Echo "LastName: " & objExcel.Cells(intRow, 4).Value 
    intRow = intRow + 1 
Loop 

objExcel.Quit 