Define and Apply themes within JSON schema

Define and Apply themes within JSON schema

Posted by: davide.vago on 3 August 2020, 12:38 pm EST

• 

  davide.vago

  • Post Options:
  • Link
    Copy

  Posted 3 August 2020, 12:38 pm EST

  Good morning/afternoon

  I’m currently trying to define and apply style to cells within a json object injected into the Workbook instance via the fromJSON function but I can’t find anything simple to understand within the documentation.

  Using a recent sandbox (https://codesandbox.io/s/spreadjs-workbook-import-statusbar-ph8tu?file=/src/components/WorkBookInstance.vue) I tried at line 29 and 85 to write some test but clearly is not working, could you please explain how is it possible to define and use the themes within the JSON obj?

  Thanks for your support

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 4 August 2020, 6:47 am EST

  Hi,

  We should not Modify the JSON data directly, you could manipulate the workbook with the help of SJS API and then use toJSON for serialization. Further, to apply styles to the Cells you may use Style class in SJS API and set the style to the particular Cells using setStyle method. Please refer to the following code snippet.

  var style = new GC.Spread.Sheets.Style();     
  style.backColor = 'red';     
  style.foreColor = 'green';     
  style.isVerticalText = 'true';
  
   //set style to cell.     
  sheet.setStyle(5, 5, style, GC.Spread.Sheets.SheetArea.viewport);
  

  For Defining themes, you may refer to the following Demo which demonstrates how you could define Spread Themes
  
  https://www.grapecity.com/spreadjs/demos/features/theme/spread-theme/purejs

  API References:
  
  • Style: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Style~_ctor.html
  
  • Style Demo: https://www.grapecity.com/spreadjs/demos/features/cells/basic-style#demo_source_name
  
  • setStyle: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Worksheet~setStyle.html\
  
  • toJSON: https://www.grapecity.com/spreadjs/docs/v13/online/SpreadJS~GC.Spread.Sheets.Workbook~toJSON.html

  Regards