workbook.ToJson() with just content?

[B]

Is it possible to retrieve just the cell contents (not formatting, etc) for a specific worksheet?  

We're looking at a use case where we want to use a spreadsheet for loading a mongodb collection and don't care about all the formatting / metadata that seems to be there when you use ToJson.

Thanks!

[Boyan Dimitrov]

Hello B,

There is no predefined method to extract just the content of the cell without the options. My suggestion is to iterate through the cells for each row in the sheet ( in the object returned by toJSON method) and remove formatting and etc options. 

Regards,
Boyan Dimitrov
Telerik

 

 

[RPI Bumper to Bumper Auto Parts]

Could you please show an example of the row, cell iteration.

[Dimitar]

Hello,

The results from the toJSON() method could be iterated as follows:

var spreadsheet = $("#spreadsheet").data("kendoSpreadsheet");
var sheet = spreadsheet.activeSheet();
var data = sheet.toJSON();

var formattedRows = [];
for (var i = 0; i < data.rows.length; i += 1) {
  var rowCells = data.rows[i].cells;
  var formattedCells = [];

  for (var j = 0; j < rowCells.length; j += 1) {
    formattedCells.push({  index: rowCells[j].index, value: rowCells[j].value });
  }

  formattedRows.push({ index: data.rows[i].index, cells: formattedCells });
}

console.log(formattedRows);

Here is a Dojo example where the above approach is demonstrated.

Regards,
Dimitar
Progress Telerik