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


The Characters Object (ICharacters)

* The Characters object is not available in ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.

The Characters object represents a range of characters within a cell. The object is accessible through the property Cell.Characters.

Characters Methods and Properties

*This feature is not available in ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.

Characters Methods and Properties
Font *

Sets or returns the Font object used to format text within the specified Characters object.

Signature:


[VBScript]
Property Font As SAFont (read/write)

Examples:

[VBScript]
Set xlw = Server.CreateObject("Softartisans.excelwriter") 
...
set ws = xlw.worksheets(1) 
strHeader = "Rich Character Formatting Sample"
ws.Cells(3,3).Value = strHeader
set oCharacters = ws.Cells(3,3).Characters(1,Len(strHeader))
oCharacters.Font.Bold = True
oCharacters.Font.Size = 14
...

Top

Index *

Returns the start index (the position of the first character) of the specified Characters object.

Signature:


[VBScript]
Property Index As Long (read-only)

Top

Length *

Returns the length (number of characters and spaces) in the specified Characters object.

Signature:

[VBScript]
Property Length As Long (read-only)

Top

*This feature is not available in ExcelWriterSE, ExcelWriterLE, or ExcelWriterFree.


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


Copyright © 2005, SoftArtisans, Inc.