Microsoft Office Tutorials and References
In Depth Information
Table 26-3. Selected Properties and Methods of the
XmlMap Object (continued)
Property or Method
Description
Property
PreserveNumberFormatting
A Boolean value that, when set to True , retains any
number formatting changes when the XML map is
refreshed. The default value is False .
RootElementName
A read-only string that contains the name of the root
element of the mapped schema.
SaveDataSourceDefinition
A Boolean value that, when set to True (the default
value), causes Excel to save the data source
definition of the mapped schema with the workbook.
Schemas
A property that returns an XmlSchemas collection
that contains each schema mapped to the active
workbook.
ShowImportExportValidationErrors
A Boolean value that, when set to True , causes
Excel to display a dialog box that details any
schema-validation errors that occur when data is
imported or exported through the specified XML
schema. The default value is False .
Method
Delete
The Delete method removes the named schema
from a workbook.
Export(Url, Overwrite)
The Export method writes the contents of cells
mapped to the specified XmlMap object to an XML
data file. The Url argument is a string that contains
the full path of the file to which you want to write the
XML data. The Overwrite argument, when set to
True , replaces any existing file with the same name.
(The default value is False. ) The Export method
returns one of two constants: xlXmlExportSuccess ,
which indicates the export happened without error,
or xlXmlExportValidationFailed , which indicates the
data did not match the XmlMap schema.
ExportXml(Data)
The ExportXml method writes the contents of cells
mapped to the specified XmlMap object to the string
named in the Data argument. The method returns
one of two constants: xlXmlExportSuccess , which
indicates the export happened without error, or
xlXmlExportValidationFailed , which indicates the data
did not match the XmlMap schema.
continued
Search JabSto ::




Custom Search