Hi Freddy,
Thanks for using Syncfusion products.
We would like to let you know that your requirement can be achieved by using “getPropertyValue” and “updateCellValue” method. We can able to get the cell value by using “getPropertyValue” method with argument rowIndex and colIndex. And we can able to update the cell value by using “updateCellValue” with argument rowIndex, colIndex and value. Please refer the below code snippets.
[.html file]
|
<script>
$(function () {
$("#Spreadsheet").ejSpreadsheet({
---------
loadComplete: "loadComplete",
---------
});
});
function loadComplete(args) {
--------
// [this] is Spreadsheet Object
//Get cell value using this method
var value = this.XLEdit.getPropertyValue(2, 3) // To Pass the rowIndex ,colIndex
//To get range of data using this method.
var rangeData = this.getRangeData("C2:D7")
//To Update the cell value using this method
this.XLEdit.updateCellValue({ rowIndex: 1, colIndex: 1 }, "Update Cell Value");
}
</script>
|
Please refer the below link for API document for JS Spreadsheet.
Link: http://help.syncfusion.com/js/api/ejspreadsheet
We have created a simple sample with read and update the data code snippets in JS Playground. Please refer the below sample link.
JS Playground Sample Link: http://jsplayground.syncfusion.com/ylrswe1t
Please let us know if you need any further assistance.
Regards,
Mohankumar R
