An example that demonstrates how to achieve excel-like functionality for the grid is available in the code library below:
Regarding your other questions:
- read only cells (the ones with the formulas)
You can subscribing to ItemCreated event access the desired cells(with the formulas)and make the cell not editable for the customers. A similar example that shows hot to make certain cell read only is available here:
- frozen columns on the left and right
Currently RadGrid only supports frozen columns on the left side. Sorry for the inconvenience caused.
- frozen header rows
In order to make the grid headers frozen you can set ClientSettings.Scrolling.UseStaticHeaders property to True.
- excel import and export
Export to excel demo for RadGrid control is available here:
Unfortunately, RadGrid does not support importing data from Excel. Nevertheless you could check out the following project where is demonstrated a possible way to import Excel data to grid.
Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.