Home >Web Front-end >JS Tutorial >jscript's Read an Excel Spreadsheet_javascript skills

jscript's Read an Excel Spreadsheet_javascript skills

WBOY
WBOYOriginal
2016-05-16 19:12:281170browse

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



Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn