Forum Discussion
1 Reply
Sort By
- murugans1011Regular ContributorHi
to work with excel files see
Working with Excel via COM for
more details
To work with fonts and colors in excel refer following links
[url= http://msdn.microsoft.com/en-us/library/cc296089%28v=office.12%29.aspx] http://msdn.microsoft.com/en-us/library/cc296089%28v=office.12%29.aspx[/url]
Sample to set font color
Set app = Sys.OleObject("Excel.Application")
app.DisplayAlerts = False
Set book = app.Workbooks.Open(filepath)
Set sheet1 = book.Sheets(sheetname)
Sheet1.Cells(Row, Column)).Font.ColorIndex=1
book.Save
app.Workbooks.Close
app.Quit
Related Content
- 2 years ago
- 9 years ago
- 2 years ago
- 12 years ago