Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
var myTable;
// The initialize function is required for all apps.
Office.initialize = function (reason) {
$(document).ready(function () {
myTable = new Office.TableData();
myTable.headers = ["First Name", "Last Name", "Grade"];
myTable.rows = [["Brittney", "Booker", "A"], ["Sanjit", "Pandit", "C"], ["Naomi", "Peacock", "B"]];
try {
Office.context.document.bindings.addFromNamedItemAsync('TheTable',
Office.BindingType.Text, { id: 'tbl' },
function (result) {
if (result.status === Office.AsyncResultStatus.Succeeded) {
trace('Control bound. Binding.id: ' + result.value.id + ' Binding.type: ' + result.value.type);
} else {
trace('Error:', result.error.message);
}
});
} catch (e) { trace("Exception: " + e.message); }
});
}
function insertAtSelection() {
try {
Office.context.document.setSelectedDataAsync(myTable, { coercionType: Office.CoercionType.Table },
function (result) {
var error = result.error
if (result.status === Office.AsyncResultStatus.Failed) {
trace(error.name + ": " + error.message);
} else { trace("Success calling addRowsAtSelection"); }
});
} catch (e) { trace("Exception: " + e.message); }
}
function trace(msg) {
$("#trace").append(msg + "<br />");
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.