jscript之List Excel Color Values

2019-11-21 02:02:50

字体：大中小

来源：转载

供稿：网友

Description

Demonstration script that displays the various colors -- and their related color index -- available when programmatically controlling Microsoft Excel.
Script Code

复制代码代码如下:

set objExcel = CreateObject("Excel.Application") 

objExcel.Visible = True 
objExcel.Workbooks.Add 

For i = 1 to 56 
    objExcel.Cells(i, 1).Value = i 
    objExcel.Cells(i, 1).Interior.ColorIndex = i 
Next 

上一篇：去除图像或链接黑眼圈的两种方法总结

下一篇：jscript之Read an Excel Spreadsheet