workbook.ToJson() with just content?

2 posts, 0 answers
  1. B
    B avatar
    8 posts
    Member since:
    Aug 2010

    Posted 25 May 2016 Link to this post

    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.


  2. Boyan Dimitrov
    Boyan Dimitrov avatar
    1966 posts

    Posted 27 May 2016 Link to this post

    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. 

    Boyan Dimitrov
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
Back to Top