locked
Using spreadsheet Light or similar to create excel application RRS feed

  • Question

  • I need to create excel application in WPF. User should be able to use this application like Excel without the disadvantages of excel when using large data and merging large data tables and slow performance. Did any one used spreadsheet light or any other open source excel applications and customized it for the WPF? I am looking for steps to include these in wpf application. Some source code on how to include these in wpf application will be helpful. 

    Wednesday, August 3, 2016 4:08 AM

Answers

  • >>User should be able to use this application like Excel without the disadvantages of excel when using large data and merging large data tables and slow performance.

    If you are trying to build your own better version of MS Excel I wish you the best of luck. You will probably need it because this won't be an easy task :)

    If your users want Excel like functionality, then they should probably use Excel and not a custom WPF application.

    >>Did any one used spreadsheet light or any other open source excel applications and customized it for the WPF?

    Please don't ask question about third-party software in these forums as they are intended for Microsoft's products and technologies only.

    You could check out ComponentOne's Excel library: https://www.componentone.com/Studio/Reporting-Documents/ExcelWPF

    Or their FlexGrid control: https://www.componentone.com/Studio/Data-Management/FlexGridWPF

    Or Telerik's RadSpreadProcessing: http://www.telerik.com/products/wpf/spreadsheet-processing.aspx

    SyncFusion also has one: https://www.syncfusion.com/products/wpf/grid-control

    And ReoGrid is a free option: https://reogrid.net/

    But please ask any questions you may have about these third-party products in the respective vendor's own communities.

    Hope that helps and good luck.

    Please remember to close your threads by marking helpful posts as answer and then start a new thread if you have a new question. Please don't ask several questions in the same thread.

    • Edited by Magnus (MM8)MVP Wednesday, August 3, 2016 8:46 PM
    • Proposed as answer by DotNet Wang Saturday, August 13, 2016 2:39 AM
    • Marked as answer by DotNet Wang Wednesday, August 17, 2016 2:35 AM
    Wednesday, August 3, 2016 8:44 PM