Working with object in Tags

Working with object in Tags

Posted by: lpagliaro on 21 July 2021, 5:49 am EST

• 

  lpagliaro

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 21 July 2021, 5:49 am EST

  Hi! We have a tag set to a sheet done using SpreadJs, we assign an object as tag. When loading the workbook on Docs4Excel, we need to modify some values of this object in the tag and then save it again. Would you please help us out to achieve this?

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 21 July 2021, 6:30 pm EST

  Hello,

  There is no direct way to edit the tag value. But you can find the property in the GcExcel API and update it as per your need.
  
  https://www.grapecity.com/documents-api-excel-java/docs/online/overview.html

  If there is any specific value that you want to update and not finding it, then please let us know.

  Regards,
  
  Prabhat Sharma.

• 

  lpagliaro

  • Post Options:
  • Link
    Copy

  Posted 26 July 2021, 2:35 am EST

  We managed to solve it. We did this:

  var sheetTag = (JsonConvert.DeserializeObject(worksheet.Tag.ToString()) as Newtonsoft.Json.Linq.JObject).ToObject<YourTagObjectClass>();
  
  ...[update sheetTag]...
  
  var jsonSheetTag = JObject.FromObject(sheetTag, new Newtonsoft.Json.JsonSerializer {
                      ContractResolver = new Newtonsoft.Json.Serialization.CamelCasePropertyNamesContractResolver(),
                      NullValueHandling = NullValueHandling.Ignore,
                  });
  
  worksheet.Tag = new StringBuilder(jsonSheetTag.ToString());
  
  

  The key was using the JObject.FromObject after serializing and StringBuilder when reassigning the tag to the worksheet.