Skip to content

Instantly share code, notes, and snippets.

@Zlatkovsky

Zlatkovsky/Get OOXML.WORD.yaml

Created August 3, 2019 15:43
Show Gist options
  • Save Zlatkovsky/300f8be8182d12673e7a1b3a23933d5b to your computer and use it in GitHub Desktop.
Save Zlatkovsky/300f8be8182d12673e7a1b3a23933d5b to your computer and use it in GitHub Desktop.
Download ZIP
Raw
Get OOXML.WORD.yaml
name: Get OOXML
description: ''
host: WORD
api_set: {}
script:
content: |
$("#run").click(() => tryCatch(run));
async function run() {
// Gets the current selection and changes the font color to red.
await Word.run(async (context) => {
const range = context.document.getSelection();
let xml = range.getOoxml();
await context.sync();
console.log(vkbeautify.xml(xml.value));
});
}
/** Default helper for invoking an action and handling errors. */
async function tryCatch(callback) {
try {
await callback();
} catch (error) {
// Note: In a production add-in, you'd want to notify the user through your add-in's UI.
console.error(error);
}
}
///////////////////////
declare module vkbeautify {
function xml(text: string): string;
}
/**
* vkBeautify - javascript plugin to pretty-print or minify text in XML, JSON, CSS and SQL formats.
*
* Version - 0.99.00.beta
* Copyright (c) 2012 Vadim Kiryukhin
* vkiryukhin @ gmail.com
* http://www.eslinstructor.net/vkbeautify/
*
* Dual licensed under the MIT and GPL licenses:
* http://www.opensource.org/licenses/mit-license.php
* http://www.gnu.org/licenses/gpl.html
*
* Pretty print
*
* vkbeautify.xml(text [,indent_pattern]);
* vkbeautify.json(text [,indent_pattern]);
* vkbeautify.css(text [,indent_pattern]);
* vkbeautify.sql(text [,indent_pattern]);
*
* @text - String; text to beatufy;
* @indent_pattern - Integer | String;
* Integer: number of white spaces;
* String: character string to visualize indentation ( can also be a set of white spaces )
* Minify
*
* vkbeautify.xmlmin(text [,preserve_comments]);
* vkbeautify.jsonmin(text);
* vkbeautify.cssmin(text [,preserve_comments]);
* vkbeautify.sqlmin(text);
*
* @text - String; text to minify;
* @preserve_comments - Bool; [optional];
* Set this flag to true to prevent removing comments from @text ( minxml and mincss functions only. )
*
* Examples:
* vkbeautify.xml(text); // pretty print XML
* vkbeautify.json(text, 4 ); // pretty print JSON
* vkbeautify.css(text, '. . . .'); // pretty print CSS
* vkbeautify.sql(text, '----'); // pretty print SQL
*
* vkbeautify.xmlmin(text, true);// minify XML, preserve comments
* vkbeautify.jsonmin(text);// minify JSON
* vkbeautify.cssmin(text);// minify CSS, remove comments ( default )
* vkbeautify.sqlmin(text);// minify SQL
*
*/
(function() {
function createShiftArr(step) {
var space = " ";
if (isNaN(parseInt(step))) {
// argument is string
space = step;
} else {
// argument is integer
switch (step) {
case 1:
space = " ";
break;
case 2:
space = " ";
break;
case 3:
space = " ";
break;
case 4:
space = " ";
break;
case 5:
space = " ";
break;
case 6:
space = " ";
break;
case 7:
space = " ";
break;
case 8:
space = " ";
break;
case 9:
space = " ";
break;
case 10:
space = " ";
break;
case 11:
space = " ";
break;
case 12:
space = " ";
break;
}
}
var shift = ["\n"]; // array of shifts
for (ix = 0; ix < 100; ix++) {
shift.push(shift[ix] + space);
}
return shift;
}
function vkbeautify() {
this.step = " "; // 4 spaces
this.shift = createShiftArr(this.step);
}
vkbeautify.prototype.xml = function(text, step) {
var ar = text
.replace(/>\s{0,}</g, "><")
.replace(/</g, "~::~<")
.replace(/\s*xmlns\:/g, "~::~xmlns:")
.replace(/\s*xmlns\=/g, "~::~xmlns=")
.split("~::~"),
len = ar.length,
inComment = false,
deep = 0,
str = "",
ix = 0,
shift = step ? createShiftArr(step) : this.shift;
for (ix = 0; ix < len; ix++) {
// start comment or <![CDATA[...]]> or <!DOCTYPE //
if (ar[ix].search(/<!/) > -1) {
str += shift[deep] + ar[ix];
inComment = true;
// end comment or <![CDATA[...]]> //
if (ar[ix].search(/-->/) > -1 || ar[ix].search(/\]>/) > -1 || ar[ix].search(/!DOCTYPE/) > -1) {
inComment = false;
}
}
// end comment or <![CDATA[...]]> //
else if (ar[ix].search(/-->/) > -1 || ar[ix].search(/\]>/) > -1) {
str += ar[ix];
inComment = false;
}
// <elm></elm> //
else if (
/^<\w/.exec(ar[ix - 1]) &&
/^<\/\w/.exec(ar[ix]) &&
/^<[\w:\-\.\,]+/.exec(ar[ix - 1]) == /^<\/[\w:\-\.\,]+/.exec(ar[ix])[0].replace("/", "")
) {
str += ar[ix];
if (!inComment) deep--;
}
// <elm> //
else if (ar[ix].search(/<\w/) > -1 && ar[ix].search(/<\//) == -1 && ar[ix].search(/\/>/) == -1) {
str = !inComment ? (str += shift[deep++] + ar[ix]) : (str += ar[ix]);
}
// <elm>...</elm> //
else if (ar[ix].search(/<\w/) > -1 && ar[ix].search(/<\//) > -1) {
str = !inComment ? (str += shift[deep] + ar[ix]) : (str += ar[ix]);
}
// </elm> //
else if (ar[ix].search(/<\//) > -1) {
str = !inComment ? (str += shift[--deep] + ar[ix]) : (str += ar[ix]);
}
// <elm/> //
else if (ar[ix].search(/\/>/) > -1) {
str = !inComment ? (str += shift[deep] + ar[ix]) : (str += ar[ix]);
}
// <? xml ... ?> //
else if (ar[ix].search(/<\?/) > -1) {
str += shift[deep] + ar[ix];
}
// xmlns //
else if (ar[ix].search(/xmlns\:/) > -1 || ar[ix].search(/xmlns\=/) > -1) {
str += shift[deep] + ar[ix];
} else {
str += ar[ix];
}
}
return str[0] == "\n" ? str.slice(1) : str;
};
vkbeautify.prototype.json = function(text, step) {
var step = step ? step : this.step;
if (typeof JSON === "undefined") return text;
if (typeof text === "string") return JSON.stringify(JSON.parse(text), null, step);
if (typeof text === "object") return JSON.stringify(text, null, step);
return text; // text is not string nor object
};
vkbeautify.prototype.css = function(text, step) {
var ar = text
.replace(/\s{1,}/g, " ")
.replace(/\{/g, "{~::~")
.replace(/\}/g, "~::~}~::~")
.replace(/\;/g, ";~::~")
.replace(/\/\*/g, "~::~/*")
.replace(/\*\//g, "*/~::~")
.replace(/~::~\s{0,}~::~/g, "~::~")
.split("~::~"),
len = ar.length,
deep = 0,
str = "",
ix = 0,
shift = step ? createShiftArr(step) : this.shift;
for (ix = 0; ix < len; ix++) {
if (/\{/.exec(ar[ix])) {
str += shift[deep++] + ar[ix];
} else if (/\}/.exec(ar[ix])) {
str += shift[--deep] + ar[ix];
} else if (/\*\\/.exec(ar[ix])) {
str += shift[deep] + ar[ix];
} else {
str += shift[deep] + ar[ix];
}
}
return str.replace(/^\n{1,}/, "");
};
//----------------------------------------------------------------------------
function isSubquery(str, parenthesisLevel) {
return parenthesisLevel - (str.replace(/\(/g, "").length - str.replace(/\)/g, "").length);
}
function split_sql(str, tab) {
return (
str
.replace(/\s{1,}/g, " ")
.replace(/ AND /gi, "~::~" + tab + tab + "AND ")
.replace(/ BETWEEN /gi, "~::~" + tab + "BETWEEN ")
.replace(/ CASE /gi, "~::~" + tab + "CASE ")
.replace(/ ELSE /gi, "~::~" + tab + "ELSE ")
.replace(/ END /gi, "~::~" + tab + "END ")
.replace(/ FROM /gi, "~::~FROM ")
.replace(/ GROUP\s{1,}BY/gi, "~::~GROUP BY ")
.replace(/ HAVING /gi, "~::~HAVING ")
//.replace(/ SET /ig," SET~::~")
.replace(/ IN /gi, " IN ")
.replace(/ JOIN /gi, "~::~JOIN ")
.replace(/ CROSS~::~{1,}JOIN /gi, "~::~CROSS JOIN ")
.replace(/ INNER~::~{1,}JOIN /gi, "~::~INNER JOIN ")
.replace(/ LEFT~::~{1,}JOIN /gi, "~::~LEFT JOIN ")
.replace(/ RIGHT~::~{1,}JOIN /gi, "~::~RIGHT JOIN ")
.replace(/ ON /gi, "~::~" + tab + "ON ")
.replace(/ OR /gi, "~::~" + tab + tab + "OR ")
.replace(/ ORDER\s{1,}BY/gi, "~::~ORDER BY ")
.replace(/ OVER /gi, "~::~" + tab + "OVER ")
.replace(/\(\s{0,}SELECT /gi, "~::~(SELECT ")
.replace(/\)\s{0,}SELECT /gi, ")~::~SELECT ")
.replace(/ THEN /gi, " THEN~::~" + tab + "")
.replace(/ UNION /gi, "~::~UNION~::~")
.replace(/ USING /gi, "~::~USING ")
.replace(/ WHEN /gi, "~::~" + tab + "WHEN ")
.replace(/ WHERE /gi, "~::~WHERE ")
.replace(/ WITH /gi, "~::~WITH ")
//.replace(/\,\s{0,}\(/ig,",~::~( ")
//.replace(/\,/ig,",~::~"+tab+tab+"")
.replace(/ ALL /gi, " ALL ")
.replace(/ AS /gi, " AS ")
.replace(/ ASC /gi, " ASC ")
.replace(/ DESC /gi, " DESC ")
.replace(/ DISTINCT /gi, " DISTINCT ")
.replace(/ EXISTS /gi, " EXISTS ")
.replace(/ NOT /gi, " NOT ")
.replace(/ NULL /gi, " NULL ")
.replace(/ LIKE /gi, " LIKE ")
.replace(/\s{0,}SELECT /gi, "SELECT ")
.replace(/\s{0,}UPDATE /gi, "UPDATE ")
.replace(/ SET /gi, " SET ")
.replace(/~::~{1,}/g, "~::~")
.split("~::~")
);
}
vkbeautify.prototype.sql = function(text, step) {
var ar_by_quote = text
.replace(/\s{1,}/g, " ")
.replace(/\'/gi, "~::~'")
.split("~::~"),
len = ar_by_quote.length,
ar = [],
deep = 0,
tab = this.step, //+this.step,
inComment = true,
inQuote = false,
parenthesisLevel = 0,
str = "",
ix = 0,
shift = step ? createShiftArr(step) : this.shift;
for (ix = 0; ix < len; ix++) {
if (ix % 2) {
ar = ar.concat(ar_by_quote[ix]);
} else {
ar = ar.concat(split_sql(ar_by_quote[ix], tab));
}
}
len = ar.length;
for (ix = 0; ix < len; ix++) {
parenthesisLevel = isSubquery(ar[ix], parenthesisLevel);
if (/\s{0,}\s{0,}SELECT\s{0,}/.exec(ar[ix])) {
ar[ix] = ar[ix].replace(/\,/g, ",\n" + tab + tab + "");
}
if (/\s{0,}\s{0,}SET\s{0,}/.exec(ar[ix])) {
ar[ix] = ar[ix].replace(/\,/g, ",\n" + tab + tab + "");
}
if (/\s{0,}\(\s{0,}SELECT\s{0,}/.exec(ar[ix])) {
deep++;
str += shift[deep] + ar[ix];
} else if (/\'/.exec(ar[ix])) {
if (parenthesisLevel < 1 && deep) {
deep--;
}
str += ar[ix];
} else {
str += shift[deep] + ar[ix];
if (parenthesisLevel < 1 && deep) {
deep--;
}
}
var junk = 0;
}
str = str.replace(/^\n{1,}/, "").replace(/\n{1,}/g, "\n");
return str;
};
vkbeautify.prototype.xmlmin = function(text, preserveComments) {
var str = preserveComments
? text
: text
.replace(/\<![ \r\n\t]*(--([^\-]|[\r\n]|-[^\-])*--[ \r\n\t]*)\>/g, "")
.replace(/[ \r\n\t]{1,}xmlns/g, " xmlns");
return str.replace(/>\s{0,}</g, "><");
};
vkbeautify.prototype.jsonmin = function(text) {
if (typeof JSON === "undefined") return text;
return JSON.stringify(JSON.parse(text), null, 0);
};
vkbeautify.prototype.cssmin = function(text, preserveComments) {
var str = preserveComments ? text : text.replace(/\/\*([^*]|[\r\n]|(\*+([^*/]|[\r\n])))*\*+\//g, "");
return str
.replace(/\s{1,}/g, " ")
.replace(/\{\s{1,}/g, "{")
.replace(/\}\s{1,}/g, "}")
.replace(/\;\s{1,}/g, ";")
.replace(/\/\*\s{1,}/g, "/*")
.replace(/\*\/\s{1,}/g, "*/");
};
vkbeautify.prototype.sqlmin = function(text) {
return text
.replace(/\s{1,}/g, " ")
.replace(/\s{1,}\(/, "(")
.replace(/\s{1,}\)/, ")");
};
window.vkbeautify = new vkbeautify();
})();
language: typescript
template:
content: |-
<button id="run" class="ms-Button">
<span class="ms-Button-label">Get OOXML</span>
</button>
language: html
style:
content: |-
section.samples {
margin-top: 20px;
}
section.samples .ms-Button, section.setup .ms-Button {
display: block;
margin-bottom: 5px;
margin-left: 20px;
min-width: 80px;
}
language: css
libraries: |
https://appsforoffice.microsoft.com/lib/1/hosted/office.js
@types/office-js
xml-formatter@1.1.0/browser/xml-formatter.js
office-ui-fabric-js@1.4.0/dist/css/fabric.min.css
office-ui-fabric-js@1.4.0/dist/css/fabric.components.min.css
core-js@2.4.1/client/core.min.js
@types/core-js
jquery@3.1.1
@types/jquery@3.3.1
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment