Spread Architecture and Conversions

Spread Architecture and Conversions

Posted by: Vesa.Tuomala on 20 May 2020, 3:11 pm EST

• 

  Vesa.Tuomala

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 20 May 2020, 3:11 pm EST - Updated 11 January 2024, 5:40 am EST

  Because of historical reason our web client architecture at the moment is following: (see picture spread_currentstatus.jpg)

  Web UI-frontend: We are using spead.js
  
  Backend: We are using spread.net for creating workbook. Then ready-made workbook is converted from workbook to json format by using Excel I/O

  Because of using Excel I/O for conversion we have compatibility issues e.g with conditional formatting, build-In excel controls are not working, charts can’t be used.

  Our question is what would be recommended architecture.

  We have identified three options. What would you recommend ? (see picture spead_ArchitectureOptions.jpg)
  
  Are there any other options that you would recommend ?

  1. Option1: Use Grapecity documents for conversion (to json) between spread.net and spread.js.
  2. Option2: Use Grapecity documents for modifying excel workbook from backend (adding rows, copying ranges, adding formulas etc.) , convert ready-made workbook to json format for spread.js
  3. Option3: Use Spread.net for modifying excel workbook from backend((adding rows, copying ranges, adding formulas etc.). Save ready-made workbook to file. Use spread.js for reading file from web server. At this scenario, no conversion between xlsx to json format is needed.

  Thanks,
  
  Vesa

  

  902×95 7.68 KB

  

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 25 May 2020, 8:50 pm EST

  Hi Vesa,

  Sorry for the delay, for your use case, we would recommend you to use Grapecity documents on backend and SpreadJS on the front end.

  Regards
  
  Sharad

• 

  Vesa.Tuomala

  • Post Options:
  • Link
    Copy

  Posted 17 June 2020, 4:03 pm EST

  Hi Sharad,
  
  Thank you for reply.

  One additional question.

  We have workbooks with embedded pictures (jpg,svg etc) and charts.
  
  Would it be possible to modify workbook with Grapecity documents in server, convert modified workbook to json format and load converted workbook to spread.js in browser with existing pictures and charts.
  
  At the moment with Excel I/O conversion pictures and charts are not visible in browser.

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 18 June 2020, 6:11 pm EST

  Hi,
  
  Yes, you may show the Charts/Pictures in the SpreadSheet on Browser by converting the JSON from GCExcel.
  
  Please refer to the attached sample for reference.

  Regards,
  
  Manish Gupta

  GCExcel-Spread-Chart-Image.zip

• 

  petri.rasanen

  • Post Options:
  • Link
    Copy

  Posted 9 July 2020, 10:01 pm EST

  Hi,

  I tested attached sample, and I have Excel workbook saved from .NET Spread for Winforms (version 13.45.20201.0). Cell B1 should contain an image, it is not visible. Also charts are empty. Also when trying to open grouped columns, they are not opened. So either JSON conversion is not working or SpreadJS has problem.
  
  Br, Petri Charts and Image saved from desktop Client.zip

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 13 July 2020, 12:10 am EST

  Hi Petri,
  
  We are sorry for the inconvenience, we are able to replicate the issue at our end for Image and grouped columns. The chart is showing correctly with the GCExcel build 3.1.5.
  
  For both the issues, we have reported this to the concerned team with internal tracking id DOCXLS-2762.

  Regards,
  
  Manish Gupta

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 23 July 2020, 3:26 pm EST

  Hello Petri,
  
  The issue regarding the Grouped Columns is fixed by the GCExcel team and it will be included in the next hotfix release.

  Regarding Image, this is the SpreadJS limitation.

  Thanks,
  
  Manish Gupta

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 9 August 2020, 2:30 pm EST

  Hello,
  
  The hotfix containing the specified fix has been released and it can be downloaded from here:
  
  https://www.grapecity.com/documents-api-excel

  Regards,
  
  Manish Gupta