XML Namespace test

See if namespace get inserted when adding childs

by Dirk Drijkoningen

HTML

<script src="https://code.jquery.com/jquery-1.12.4.min.js"></script>
<div>
  Viewer window below
</div>
<div id="viewer">
  replaced by js
</div>

CSS

#viewer {
  border: 1px solid #000;
  font-family: verdana;
  border-radius: 6px;
  padding:6px;
}

JavaScript

var srcXML = '<?xml version="1.0" encoding="UTF-8" standalone="yes"?><worksheet><cols><col min="1" max="1"/></cols><sheetData><row r="1"/></sheetData></worksheet>';
var parser = new DOMParser();
var xmlDoc = parser.parseFromString(srcXML, 'text/xml');
var xlsxFilter = xmlDoc.createElement('autoFilter');
var filterAttr = xmlDoc.createAttribute('ref');
filterAttr.value = 'A1:Z1';
xlsxFilter.setAttributeNode(filterAttr);
xmlDoc.getElementsByTagName('worksheet')[0].appendChild(xlsxFilter);
var serializer = new XMLSerializer();
var xmlString = serializer.serializeToString(xmlDoc);
$('#viewer').text(xmlString);