Spread Architecture and Conversions

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

  • Posted 20 May 2020, 3:11 pm 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

  • Replied 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
  • Replied 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.
  • Replied 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
  • Replied 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
  • Replied 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
  • Replied 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
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels