JScript有多种宿主,如IIS,WebBrowser,WSH,下面的代码是在WSH环境下,通过创建EXCEL对象,生成EXCEL表格的示例.
var
excelApp
=
new
ActiveXObject(
"
Excel.Application
"
);
WScript.Echo(excelApp);
excelApp.Visible = true ;
var wkBook = excelApp.Workbooks.Add();
var wkSheet = wkBook.Worksheets.Add();
for ( var i = 1 ; i < 10 ; i ++ ) ... {
for(var j=1; j<10; j++)...{
wkSheet.Cells(i + 2, j + 2).Value = i + "×" + j + "=" + (i * j);
}
}
var rng = wkSheet.Range( " C3:K11 " );
with (rng.Font) ... {
Name = "Lucida Console";
Size = 12;
Bold = true;
}
with (rng) ... {
RowHeight = 22;
ColumnWidth = 10;
Interior.ColorIndex = 15;
}
for ( var i = 7 ; i <= 12 ; i ++ ) ... {
with(rng.Borders(i))...{
LineStyle = 1;
Weight = (i>10 ? 2 : 4);
}
}
WScript.Echo(excelApp);
excelApp.Visible = true ;
var wkBook = excelApp.Workbooks.Add();
var wkSheet = wkBook.Worksheets.Add();
for ( var i = 1 ; i < 10 ; i ++ ) ... {
for(var j=1; j<10; j++)...{
wkSheet.Cells(i + 2, j + 2).Value = i + "×" + j + "=" + (i * j);
}
}
var rng = wkSheet.Range( " C3:K11 " );
with (rng.Font) ... {
Name = "Lucida Console";
Size = 12;
Bold = true;
}
with (rng) ... {
RowHeight = 22;
ColumnWidth = 10;
Interior.ColorIndex = 15;
}
for ( var i = 7 ; i <= 12 ; i ++ ) ... {
with(rng.Borders(i))...{
LineStyle = 1;
Weight = (i>10 ? 2 : 4);
}
}