简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Web Front-end > JS Tutorial > body text

jscript之List Excel Color Values_javascript技巧

WBOY
Release： 2016-05-16 19:12:26
Original
1035 people have browsed it

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

Related labels：
excel
source：php.cn
Previous article：Use Word to Search for Files_javascript技巧 Next article：Open and Print a Word Document_javascript技巧
Statement of this Website
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
Latest Articles by Author
Latest Issues
HTML hover image: expand clickable area beyond image I'm relatively new to css/html. I've been browsing around this issue for a while but haven...
From 2023-09-10 16:08:26
0
1
282
python - How to regularize all Chinese characters in a string {Code...} The string is as above, the type is 'str', and the Chinese characters must be ob...
From 2017-06-22 11:51:45
0
2
781
javascript - Help Looking for a solution to the problem of npm ERR! extraneous npm list command throws error after {code...}
From 2017-05-19 10:25:48
0
1
307
redis - How to create a cache for lightweight python programs and scripts? I am a newbie in operation and maintenance. After recently doing simple processing of comp...
From 2017-05-19 10:07:54
0
1
510
gvim - Problems with undoing command line command operations and highlighting the line where the cursor is located in Vim I have the following questions about gVim in the Windows environment. I would like some Vi...
From 2017-05-16 16:36:38
0
1
729
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！