none
Best way to display and edit an Excel workbook on a web page. RRS feed

  • Question

  • Purpose - I want to display an excel workbook (Macro) on a web-page in Angular 2-4 project.



    In an angular application I want to allow use to see an Excel workbook (Macro) data, and user must have the ability to edit it on the web page it self.

    This Macro consists of huge data, on an average consider 50,000 (10 sheets in one workbook, each sheet containing 5000 data cells filled) cells Data.

    I have tried several 3rd party libraries like "Aspose, SpreadJS, EP Plus" to get the desired result and got succeeded too, but the time these libraries are taking to load the Excel workbook is not acceptable. It usually takes 4-5 minutes to load the workbook.



    So I just want to know if there is any tool / library which can do this in user acceptable time frame(i.e. 4-5- seconds).
    Wednesday, March 14, 2018 9:15 AM

All replies

  • Hi TarunRathore,

    Thank you for posting here.

    What is the type of your project? Using ASP.NET?

    If your question is more related to ASP.NET, you could post in ASP.NET forum for suitable support.

    Best Regards,

    Wendy


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, March 15, 2018 6:25 AM
  • This Macro consists of huge data, on an average consider 50,000 (10 sheets in one workbook, each sheet containing 5000 data cells filled) cells Data.

    I have tried several 3rd party libraries like "Aspose, SpreadJS, EP Plus" to get the desired result and got succeeded too, but the time these libraries are taking to load the Excel workbook is not acceptable. It usually takes 4-5 minutes to load the workbook.




    Aspose.Cells.GridWeb (GUI control) can display and manipulate MS Excel spreadsheets in Asp.NET applications on the fly. Well, your data set ("50,000 (10 sheets in one workbook, each sheet containing 5000 data cells filled)") is quite big. Anyways, could you provide us your template Excel file, we will check your issue soon.

    Note: I am working as support developer/ Evangelist at Aspose.


    • Edited by qam2 Thursday, March 15, 2018 6:42 PM
    Thursday, March 15, 2018 6:42 PM