I am very close to getting this working with all the help within the forums, I appreciate all the people whom have taken the time to post!! Including the KENDO administrators!
I can read json withing my transport with no issues and even do an update with no issues BUT after the update when I requery the database sometimes the grid is not refreshed with the new data but the database and the degugging shows the correct data. I use this onclick function to requey the database and was wondering if it is correct.
var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
var sheet = spreadsheet.activeSheet();
sheet.dataSource.transport.options.read.url = "index.cfm?event=general.excel&action=load&startDate=" + $('#startDate').val() + "&endDate=" + $('#endDate').val() + "&lobID=" + $('#area').val();
} //end getData