欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  web前端

jscript之List Excel Color Values_javascript技巧

程序员文章站 2022-05-19 16:17:32
...
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