Create Workbook and Display

[Bernie]

I'm just getting started with the spreadsheet features. I need to create a blank workbook, make some modifications to it, and then display it in the spreadsheet control.

I've gotten this far

theWorkBook = new Telerik.Windows.Documents.Spreadsheet.Model.Workbook();

Telerik.Windows.Documents.Spreadsheet.Model.Worksheet theWorkSheet = theWorkBook.Worksheets.Add();         

theWorkSheet.Cells[0, 0].SetValue("1");

 

RadSpreadsheet1.Provider = ???????theWorkBook);

So I've created the book and added a sheet, modified a cell, and now I want to display it in the grid. What is the syntax to display my sheet in the RadSpreadSheet?

 

Thanks!

 

[Peter Milchev]

Hello Bernie,

I am sharing the solution from the support thread for convenience and better visibility from the community:

You can convert the DPL workbook to an AJAX one and then just pass the sheets from the workbook to the Spreadsheet, without the need for any Provider. For more information about that, check the following articles:

• https://www.telerik.com/support/kb/aspnet-ajax/spreadsheet/details/understanding-telerik-ajax-and-document-processing-library-spreadsheet-workbook-and-worksheets

RadSpreadsheet1.Sheets.AddRange(Telerik.Web.Spreadsheet.Workbook.FromDocument(theWorkBook).Sheets);

Regards,
Peter Milchev
Progress Telerik