Tutorial Example: How to Access Microsoft Excel (Chart) using the Windows Scripting Host (JScript)

C:\Windows\system32>cscript/?
Microsoft (R) Windows Script Host Version 5.8
Copyright (C) Microsoft Corporation. All rights reserved.

Usage: CScript scriptname.extension [option...] [arguments...]

Options:
 //B         Batch mode: Suppresses script errors and prompts from displaying
 //D         Enable Active Debugging
 //E:engine  Use engine for executing script
 //H:CScript Changes the default script host to CScript.exe
 //H:WScript Changes the default script host to WScript.exe (default)
 //I         Interactive mode (default, opposite of //B)
 //Job:xxxx  Execute a WSF job
 //Logo      Display logo (default)
 //Nologo    Prevent logo display: No banner will be shown at execution time
 //S         Save current command line options for this user
 //T:nn      Time out in seconds:  Maximum time a script is permitted to run
 //X         Execute script in debugger
 //U         Use Unicode for redirected I/O from the console

//////////////////////////////////////////////////////////////////////////////////
//
// Excel Sample
//

var objEXL;

objEXL = WScript.CreateObject("Excel.Application"); // create Excel object
objEXL.Workbooks.Add;
objEXL.Cells(1,1).Value = 5;
objEXL.Cells(1,2).Value = 10;
objEXL.Cells(1,3).Value = 15
objEXL.Range("A1:C1").Select;

var chart = objEXL.Charts.Add();
objEXL.Visible = true;
chart.Type = -4100;

var rotate;
for(rotate = 5; rotate <= 180; rotate += 5) {     
    chart.Rotation = rotate; 
} 
for (rotate = 175; rotate >= 0; rotate -= 5) {
    chart.Rotation = rotate;
}