C#打開已經保存的 excel:
Dim sFileName As String = "測試.xls"
Dim fileStream As New FileStream(Server.MapPath(Request.ApplicationPath &
"/Excel/ARTemp/" & sFileName), FileMode.Open, FileAccess.Read)
Dim br As New BinaryReader(fileStream)
Page.Response.Clear()
Page.Response.AddHeader("content-disposition", "attachment; filename=" +
HttpUtility.UrlEncode(sFileName, System.Text.Encoding.UTF8))
Page.Response.ContentType = "mine"
Page.Response.BinaryWrite(br.ReadBytes(CType(fileStream.Length, Integer)))
Response.Flush()
Response.Close()
fileStream.Close()
br.Close()
有時候會出現打開 excel 的標題名稱亂碼問題,除了注意上述紅色字體部份外,
還需查看 ie 高級屬性,是否支持 utf-8 傳送
评论4