New Properties (by Object)
For the latest information about programming with Microsoft Excel, including product news, technical articles, downloads, and samples, visit the Microsoft Office Developer Center on the Microsoft Developer Network (MSDN) Web site.
The following table lists properties added to the Microsoft Office Excel 2003 object model (sorted by object name).
| Object |
New Properties |
|
Application
|
ArbitraryXMLSupportAvailable, DisplayDocumentActionTaskPane |
|
AutoCorrect
|
AutoExpandListRange
|
|
ErrorCheckingOptions
|
ListDataValidation
|
|
ListColumn
|
ListDataFormat, SharePointFormula, TotalsCalculation, XPath |
|
ListDataFormat
|
AllowFillIn, Choices, DecimalPlaces, DefaultValue, IsPercent, lcid, MaxCharacters, MaxNumber, MinNumber, Required |
|
ListObject
|
Active, HeaderRowRange, InsertRowRange, ListColumns, ListRows, SharePointURL, ShowAutoFilter, ShowTotals, TotalsRowRange, XmlMap |
|
ListRow
|
InvalidData
|
|
QueryTable
|
ListObject, TextFileVisualLayout |
|
Range
|
ListObject, XPath |
|
SmartTagAction
|
ActiveXControl, CheckboxState, ExpandHelp, ListSelection, PresentInPane, RadioGroupSelection, TextboxText |
|
Windows
|
SyncScrollingSideBySide
|
|
Workbook
|
DisplayInkComments, DocumentLibraryVersions, InactiveListBorderVisible, Permission, SharedWorkspace, SmartDocument, Sync, XmlMaps, XmlNamespaces |
|
Worksheet
|
ListObjects
|
|
XmlDataBinding
|
SourceUrl
|
|
XmlMap
|
AppendOnImport, DataBinding, IsExportable, PreserveColumnFilter, PreserveNumberFormatting, RootElementName, RootElementNamespace, SaveDataSourceDefinition, Schemas, ShowImportExportValidationErrors |
|
XmlNamespace
|
Prefix, Uri |
|
XmlSchema
|
Namespace
|
|
XPath
|
Map, Repeating |