ASP.NET Export to Excel - Lock Cells

Question

I'd like to export a table I have on my webpage to an Excel file and lock some cells in the new file. Here is my current code:

Protected Sub btnExportToExcel_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnExportToExcel.Click
    Response.Clear()
    Response.Buffer = True
    Response.ContentType = "application/vnd.ms-excel"
    Response.AddHeader("content-disposition", "attachment;filename=EpicSearchResults.xls")
    Response.Charset = ""
    Me.EnableViewState = False

    Dim sw As New System.IO.StringWriter()
    Dim htw As New System.Web.UI.HtmlTextWriter(sw)

    Session("tblResults").RenderControl(htw)

    Response.Write(sw.ToString())
    Response.End()
End Sub

This code works in generating the Excel file. I've searched for an was unable to find much for a solution to lock cells in the new file. Thanks in advance for the help!

Marcus · Accepted Answer · 2011-05-05 18:25:59Z

4

Like Leniel said, you probably need a better library. Another one you could check out is EPPlus. Works wonderfully.

The code in EPPlus to lock cells is worksheet.Cells["A1:G60"].Style.Locked = true;

answered May 5, 2011 at 18:25

Marcus

5,4873 gold badges36 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Community · Accepted Answer · 2017-05-23 12:12:02Z

2

I think you'll need a more powerful library to do what you want. This involves changing the way you currently export data to Excel.

Take a look at NPOI: http://npoi.codeplex.com/discussions/252597

References:

Create Excel (.XLS and .XLSX) file from C#

edited May 23, 2017 at 12:12

CommunityBot

11 silver badge

answered May 5, 2011 at 14:26

Leniel Maccaferri

103k48 gold badges381 silver badges495 bronze badges

Collectives™ on Stack Overflow

ASP.NET Export to Excel - Lock Cells

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related