Optimizing ssjson files

Optimizing ssjson files

Posted by: brian.ploe on 5 August 2021, 3:15 pm EST

• 

  brian.ploe

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 August 2021, 3:15 pm EST

  I converted an xlsx file to ssjson and it is considerably bigger as an ssjson. Is there a tool or some best practices on optimizing ssjon to get rid of unused styles, cells, or whatever is causing it to be so much bigger? This is for a web site so I need to optimize file sizes when possible.

  Here are the file sizes:
  
  ssjson: 5.1 MB
  
  xlsx: 292 KB
  
  xlsx unzipped: 2.1 MB

  Thanks!

• 

  avinash.pathak

  

  • Post Options:
  • Link
    Copy

  Posted 6 August 2021, 7:50 am EST

  Hi Brian,

  This is a known issue and we are currently working to improve the behavior, however, it is not a simple one and requires many changes and a lots of testing to introduce a new file format.(Internal tracking IDs: SJS-5772, SJS-7264).

  Further, You may compress the ssjson file that will reduce the file size drastically.

  Regards
  
  Avinash

• 

  mohd.shibyan

  • Post Options:
  • Link
    Copy

  Posted 1 August 2023, 6:17 am EST

  Hi,

  Just wanted to know if is there any solution implemented for the same so that we can save styles only and make JSON size less for speed and efficiency purposes.

  Regards,
  
  Shibyan

• 

  ankit.kumar

  

  • Post Options:
  • Link
    Copy

  Posted 2 August 2023, 5:06 am EST

  Hi Shibyan,

  Currently, exporting the json will be an issue for large files. Instead of the json, you could use the “.sjs” file that is comparatively small in size as compared to json. You could easily import and export the “.sjs” file.

  Kindly refer to the following Demo on the new File Format: https://www.grapecity.com/spreadjs/demos/features/spreadjs-file-format/overview/purejs

  SpreadJS File Format Docs: https://www.grapecity.com/spreadjs/docs/features/spreadjs-file-format

  Regards,

  Ankit