Understanding Telerik AJAX and Document Processing Library Spreadsheet Workbook and Worksheets

AUTHOR: Peter Milchev

DATE POSTED: December 17, 2018

DIFFERENCES

The assemblies from the Telerik UI for ASP.NET AJAX(later referred as AJAX) suite and Document Processing Library(later referred as DPL) both have Workbook and Worksheet classes which are different and with different capabilities. 

• AJAX Worksheet server-side API;
• AJAX Row server-side API;
• AJAX Cell server-side API; 

• DPL Worksheet Documentation;
• DPL Cells Documentation;
• DPL Rows and Columns Documentation;
• DPL Workbook API;
• DPL Worksheet API;
• DPL Sheet API;
• DPL Cells API;
• DPL CellSelection API;

CONVERTING FROM ONE TO ANOTHER

The Workbook and worksheets from the AJAX and DPL are not interchangeable. Nevertheless, the AJAX Workbook class has some methods that allow converting from one to another and vice-versa: 

• An instance method .ToDocument() that all allows any AJAX Workbook instance to be converted to a DPL Workbook;
• A static method Workbook.FromDocument() that allows any DPL Workbook to be converted to an AJAX Workbook;