Skip to main content

DeleteAttribute

Deletes an attribute from the XML node at the specified XPath.

Syntax​

expression.DeleteAttribute(xPath, name);

expression - A variable that represents an ApiCustomXmlPart class.

Parameters​

NameRequired/OptionalData typeDefaultDescription
xPathRequiredstringThe XPath of the node from which to delete the attribute.
nameRequiredstringThe name of the attribute to delete.

Returns​

boolean

Example​

Strip an attribute from an XML element stored in a spreadsheet.

// How do I remove a named property from an XML element in a spreadsheet?

// Trim unwanted metadata from an XML node and confirm the result in a spreadsheet.

const worksheet = Api.GetActiveSheet();
const xmlManager = worksheet.GetCustomXmlParts();
const xmlString = "<config version='1.0' namespace='http://example' />";
const xml = xmlManager.Add(xmlString);

xml.DeleteAttribute('/config', 'namespace');
worksheet.GetRange('A1').SetValue('XML after deletion: ' + xml.GetXml());