I am using kendo spreadsheet and all my data is returning json values.
Question can i format the grid as far as rename headers or position my data where I want to. Not much info on how when it is dynamically coming from the server.
$("#spreadsheet").kendoSpreadsheet({
// columns: 50,
// rows: 100,
// toolbar: true,
// sheetsbar: true,
// sheets: [{
// name: "Summary",
// mergedCells: [
// // "A1:D1" // Sheet Cell Placement , "C4:G4", "O4:R4", "A13:B13", "A16:B16"
// ],
// rows: [{
// height: 30,
// cells: [{
// value: "label", background: "rgb(144,164,174)", textAlign: "center",
// color: "white", fontSize: 18
// },
// ],
// },
// {
// index: 3,
// cells: [
// { index: 2, value: "Mean Total Returns(net)", fontSize: 15, textAlign: "center"}
// ],
// },
// {
// index: 3,
// cells: [
// { index: 14, value: "Mean Asset Allocation", fontSize: 15, textAlign: "center"}
// ],
// }],
// dataSource: dataSource,
// columns: [
// { width: 100 },
// { width: 415 },
// { width: 145 },
// { width: 145 },
// { width: 145 }
// ],
// }]
// });
Select all Open in new window