从Gridview Asp.net导出后设置Excel的密码 [英] Set password for Excel after exporting from Gridview Asp.net

问题描述

我将asp.net网格数据导出到excel。但我不确定是否设置了密码，任何人都可以对此有所了解。这是我的代码..



受保护的子btnPayroll_Click（ByVal sender As Object ，ByVal e As System.EventArgs）处理btnPayroll.Click

Response.Clear（）

Response.AddHeader（content-disposition，attachment; filename = Monthly Payroll .xls）

Response.Charset =

Response.ContentType =application / vnd.xls

Dim stringWrite As New System .IO.StringWriter（）

Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter（stringWrite）



Dim FilePathName As String = Request.PhysicalPath

Dim fileInfo =新IO.FileInfo（FilePathName）

fileInfo.IsReadOnly = True



GridView1.HeaderRow.Style.Add（background-color，＃99CCFF）





GridView1.RenderCon trol（htmlWrite）

Response.Write（stringWrite.ToString（））

响应。[结束]（）

结束Sub

Hi,

I am exporting asp.net grid data to excel. But I am not sure about setting password for that, Can anyone give an idea about this ., here is my code..

Protected Sub btnPayroll_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnPayroll.Click
Response.Clear()
Response.AddHeader("content-disposition", "attachment; filename=Monthly Payroll.xls")
Response.Charset = ""
Response.ContentType = "application/vnd.xls"
Dim stringWrite As New System.IO.StringWriter()
Dim htmlWrite As System.Web.UI.HtmlTextWriter = New HtmlTextWriter(stringWrite)

Dim FilePathName As String = Request.PhysicalPath
Dim fileInfo = New IO.FileInfo(FilePathName)
fileInfo.IsReadOnly = True

GridView1.HeaderRow.Style.Add("background-color", "#99CCFF")


GridView1.RenderControl(htmlWrite)
Response.Write(stringWrite.ToString())
Response.[End]()
End Sub

推荐答案

嗨会员，请参阅此链接 [ ^ ]



和这个 [ ^ ]



如果以上解决方案对您没有帮助，请在此处发布您的查询。



谢谢

Ganesh

Hi member, see this link[^]

and this [^]

if the above solutions does not helps you, please post your query here.

Thanks
Ganesh

这篇关于从Gridview Asp.net导出后设置Excel的密码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！