Click here to Skip to main content
15,878,945 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Please help me out i stuck in this problem..

I have selected 1 row and updated other 20 rows by dragging that row, but while trying to get updated rows i m not able to those rows, it gives me old values, Please help me out.....?
Posted
Updated 28-Apr-13 20:50pm
v2
Comments
Maciej Los 29-Apr-13 2:51am    
Please, be more specific and provide more details. We can't read in your mind...
amitdhemar 29-Apr-13 2:58am    
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);

});

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900