Click here to Skip to main content
15,896,526 members

Comments by amitdhemar (Top 1 by date)

amitdhemar 29-Apr-13 2:58am View    
I have used App for Office JS API to do the work but when I am trying to Update 20 rows from App Excel by dragging single row and make change to next 20 rows, these 20 rows are updated in Front end but when I am trying to retrieve these updated rows using JS API it gives me the Old values only though in front end it shows updated one.......

I am trying to get new values on SelectionChange and OnDataChange but both of these methods returns me old values

Office.select("bindings#amitamit").getDataAsync({ coercionType: 'table', startRow: varCurrentRow, startCol: varCurrentColumn, rowCount: 1, colCount: 1 },
function (result) {
if (result.status == 'succeeded') {
// write("Image to find: " + result.value.rows[0][varCurrentColumn]);
//varCurrentValue = result.value.rows[0][varCurrentColumn];
document.getElementById('divNewValue').innerText = result.value.rows[0][varCurrentColumn];

if (result.value.rows[0][0].length <= 0)
varUpdatedMasterIDs += "¶-1";
else
varUpdatedMasterIDs += "¶" + result.value.rows[0][0];
document.getElementById('divMasterIDs').innerText = varUpdatedMasterIDs;

}
else
write(result.error.message);

});