Populate 10 worksheets of Spreadsheet control on Form_Load

4 posts, 1 answers
  1. Brian
    Brian avatar
    37 posts
    Member since:
    Jul 2010

    Posted 17 Nov 2017 Link to this post

    How would I create and populate 10 Worksheets with SQL queries for each one, when form loads or other event using a Spreadsheet control with Ribbon?

     

    Thanks,

  2. Dimitar
    Admin
    Dimitar avatar
    2726 posts

    Posted 20 Nov 2017 Link to this post

    Hello Brian,

    You need to create the workbooks in code and then you will be able to display them in RadSpredsheet. RadSpreadsheet operates with a rich document model that is completely decoupled from UI. Once you create a document with RadSpreadProcessing you will be easily able to show it in RadSpredsheet.

    I hope this will be useful. Let me know if you have additional questions.  

    Regards,
    Dimitar
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Brian
    Brian avatar
    37 posts
    Member since:
    Jul 2010

    Posted 20 Nov 2017 in reply to Dimitar Link to this post

    Hi Dimitar, thanks for responding.

    Do you have a sample of RadSpreadProcessing using SQL as the source? I do not see one in the demos, nor in the documentation.

     

    Thanks,

     

  4. Answer
    Dimitar
    Admin
    Dimitar avatar
    2726 posts

    Posted 21 Nov 2017 Link to this post

    Hello Brian,

    We do not have exact such example. However, all you need to do is iterate and set the value of the cells. The example in the following blog shows this: Getting Started with RadSpreadProcessing Volume1.

    Do not hesitate to contact us if you have other questions.

    Regards,
    Dimitar
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top