Hi
Bradley,
An example that demonstrates how to achieve excel-like functionality for the grid is available in the code library below:
http://www.telerik.com/support/code-library/excel-look-and-feel-for-radgrid
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:
http://www.telerik.com/help/aspnet-ajax/grid-read-only-mode-for-individual-cells.html
- 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:
http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/exporting/excel-export/defaultcs.aspx
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.
Regards,
Pavlina
Telerik
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items