Populate 10 worksheets of Spreadsheet control on Form_Load

[Brian]

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,

[Dimitar]

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

[Brian]

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,

 

[Dimitar]

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