|
Introduction
> New in Version 6.8.1
New in Version 6.8.1
- Conditional Formatting
- Use
ExcelApplication's
ConditionalFormat object to
create and apply conditional formats to workbook cells.
- Data Validation
- Define rules for validating data entered in cells with
ExcelApplication's
DataValidation
object.
- R1C1 Cell References
- Instruct Excel to use R1C1-style cell references by
setting the property
Workbook.UseRCFormulaNotation.
- Use R1C1 references in formulas in your ExcelWriter code
(e.g.
Area a = ws.CreateArea("=R1C1:R10C7");).
- Collections as Data Sources
- Use
ExcelTemplate's new data source methods
to assign collections as data sources for template
data markers. The new methods are overloads of
SetRowDataSource
and SetColumnDataSource.
- Preserve and Convert Data Marker Modifiers
- Use the Preserve modifier
to force Excel to insert a string as a string when importing a value to a template.
- Use the Convert modifier
to force Excel to try to convert a string to a number
when importing a value to a template data marker.
Copyright 2007 © SoftArtisans, Inc. All Rights Reserved.
|
