Change the font and cell color in an Excel document
来源:互联网 发布:三菱fx 2n编程手册 编辑:程序博客网 时间:2024/06/05 20:58
This solution applies to external Excel files, not to the QuickTest Professional data table.
You can use the Excel object model to automate setting the font and cell color in an Excel worksheet.
Example:
' Create the Excel object
Set ExcelObj = CreateObject("Excel.Application")
ExcelObj.Visible = true
' Open up the Excel file which has the rows or columns to be hidden.
ExcelObj.Workbooks.Open "C:\temp\Book1.xls"
' Get the first sheet
Set NewSheet = ExcelObj.Sheets.Item(1)
' Loop through the first 3 rows
for i = 1 to 3
' Capture the value in the cell
value = NewSheet.Cells(i,1)
msgbox value
' Change the font color
NewSheet.Cells(i,1).Font.Color = RGB(0, 255, 0) 'Font color
' Change the cell color
NewSheet.Cells(i,1).Interior.Color = RGB(0, 0, 0) 'Background color
Next
' Save the Excel file
ExcelObj.ActiveWorkbook.Save
' Close the application and clear the object reference
ExcelObj.Quit
Set ExcelObj = Nothing
0 0
- Change the font and cell color in an Excel document
- Add formatting to the cell in an Excel document
- MATLAB R2016b Change the default font size in the command window and .m files
- How to change the menu item font color individually
- change the color scheme in vim
- Set font size and color in GUI.Label
- How to change the font size in legend of matlab
- Set the color and font of a GtkLabel
- 怎样控制Qt标题栏(How can I handle events in the titlebar and change its color etc ? )
- 怎样控制Qt标题栏(How can I handle events in the titlebar and change its color etc ? )
- change backgroud color of the windows in ubuntu
- Identity and change in the Network Society
- how can i change the back color on mouse out to the color specified in gridview
- Putty Change the Terminal Font
- 转载:how to automate Microsoft Excel and return the values from a multi-cell range to an array
- Hide/display columns or rows in an Excel document
- change dir color in terminal
- change background color in chrome
- 对话框的OnPaint()和OnEraseBkgnd()消息的理解
- HTML5版模拟交通灯
- 字节对齐
- android ScreenLockReceiver 锁屏监听
- 黑马程序员-我的第十二篇学习日记:OC中空指针,野指针,僵尸对象,retain和release基本使用
- Change the font and cell color in an Excel document
- 爱不是逃避是努力
- 关于排序法的c++实例(一)
- 常用一些Java基础算法积累
- Add formatting to the cell in an Excel document
- PHP通过面向对象实现数据库备份
- Java封装自己的Api
- Word Search
- LED 流水灯闪烁