How to lock a cell in an Excel export?

[Tyler]

I am exporting a report in Excel format and I was curious if there is a way to lock a particular column in the spreadsheet so that it is not editable.

[Steve]

Hello,

There is no support for such functionality in the Excel rendering extension.

Regards,
Steve
the Telerik team

[Izak Joubert]

Hello,

I am using Reporting Q1 2013. I have the same requirement as the original poster.
I need to lock certain columns during Excel Export.
Is it possible?

Thanks You.

[IvanY]

Hi Tyler,

As stated in the previous post this functionality is not supported since it is specific to Excel. Perhaps you can write a macro or use another library to further process your exported reports.

Kind regards,
IvanY
the Telerik team

[Gary]

Private Sub lockColumn()
    ActiveWorkbook.ActiveSheet.Cells.Locked = False
    ActiveWorkbook.ActiveSheet.Columns(2).Locked = True
    ActiveWorkbook.ActiveSheet.Protect
End Sub

This is a simple macro to lock a column.

First you need to remove the locked status from the worksheet cells (it's on by default)

Then set it back on for the columns you want locked.

Then enable protection.

[Pinaki]

I am using Angular JS to create my UI and want to export the grid into excel with selected columns locked. Can this be done? 

[Katia]

Hi Pinaki,

Reports are exported to Excel formats according to Design Considerations for Excel Rendering. Locking of the columns is not supported. 
Freezing of cells is possible only if they are in the Page sections - check Page Headers and Footers section in the linked article.


Regards,
Katia
Progress Telerik

[Shubham]

I am also have a same requirement. I want to lock specific columns before exporting the excel so that user can not modify them after exporting. 

Please help me if there is any other way to achieve this. 

Note- I am using angular and typescript for development. Any solution supporting this two will be helpful

[Todor]

Hi Shubham,

You may use a third-party tool or macro to lock the required cells after the report has been exported to Excel. We do not support locking cells outside the Page sections of the report.

Regards,
Todor
Progress Telerik