Share
Reportwhile export report as excel format some field value need to set non editable in excel using ssrs report
*This post is locked for comments
You’re offline. This is a read only version of the page.
while export report as excel format some field value need to set non editable in excel using ssrs report
*This post is locked for comments
Hi ievgen Miroshnikov
Thanks for your response. now i got an idea on this.
You can find hundreds of blog posts in the web, it's quite a popular topic, here is one of them [View:http://patrikluca.blogspot.com/2010/04/export-to-excel-with-x-code-sequel.html]
Also you may find discussion on this forum how to protect spreadsheet via x++
Hi ievgen Miroshnikov,
Let me know custom code or any reference link for this.
Hi Ludwig Reinhard
User expected result which will not achived in PDF format. So only we go with
excel format. Please let me know if any possible in Excel format
It's not possible with ssrs report export to excel. There are two options: export to PDF or build your own custom report that generate excel and locks cells using excel feature.
Hi,
I think the answer to your question is that you cannot achieve this with Excel.
Yet, why don't you export the report as a PDF, which is read only?
Best regards,
Ludwig
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,253
Super User 2024 Season 2
#2
Martin Dráb
230,188
Most Valuable Professional
#3
nmaenpaa
101,156
All responses (
Answers (