Show code in...     

  

 

Object Model ExcelApplication Worksheets Worksheet Cells Cell Range
Charts Chart SeriesCollection Series 3DProperties Axis ChartFrame Line Area
PivotField PivotFields PivotTable PivotTables
Style Characters Font Pictures Picture DocumentProperties PageSetup


ExcelApplication Object Reference

Style Property


Syntax:
[VBScript]
Property Style(StyleName As String) As SAStyle (read-only)
Description:

Returns a built-in style. Use Style to assign one of ExcelWriter's built-in styles to a cell. ExcelWriter includes the following styles:

  • "Normal"
  • "Comma"
  • "Comma0"
  • "Currency"
  • "Currency0"
  • "Percent"
  • "Time"
  • "Date"
  • "DateTime"
  • "Float"
  • "Hyperlink"
Example:
[VBScript]
Set Cells = ws.Cells
Cells.AddHyperlink 7,1,2,2,"http://www.softartisans.com"
Cells(7,1).Value = "SoftArtisans"
Cells(7,1).Style = xlw.style("Hyperlink")

Top


Copyright © 2005, SoftArtisans, Inc.