导出Excel中文名乱码解决办法

最新推荐文章于 2025-05-18 23:15:29 发布

转载最新推荐文章于 2025-05-18 23:15:29 发布 · 395 阅读

本文介绍了一种在ASP.NET中实现文件流送至客户端并提示用户进行“另存为”的方法。通过设置HttpResponse对象的相关属性，可以将指定内容以.xls格式文件的形式发送到客户端，并允许用户下载保存。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

        /// <summary>
        /// 文本流送到客户端,关显示为另存为
        /// </summary>
        /// <param name="response">页面response类</param>
        /// <param name="fileName">另存为的文件名</param>
        public void FileWebSaveAs(HttpResponseBase response, string fileName)
        {
            response.Clear();
            response.ClearHeaders();
            response.Buffer = false;
            response.AddHeader("Content-Disposition", "attachment; filename=" + System.Web.HttpUtility.UrlEncode(fileName, System.Text.Encoding.UTF8) + ".xls");
            response.ContentType = "application/ms-excel";
            response.ContentEncoding = System.Text.Encoding.UTF8;

            //response.Write(DataTableToExcelStr(_dt));
            System.IO.MemoryStream ms;
            string strExcel = ListToExcelStr(_listItem);
            int Step = 1024000;
            int startIndex = 0;
            int excelLength = strExcel.Length - Step;
            while (startIndex < excelLength)
            {
                ms = new System.IO.MemoryStream(System.Text.Encoding.UTF8.GetBytes(strExcel.Substring(startIndex, Step)));
                response.BinaryWrite(ms.ToArray());
                startIndex += Step;
            }
            response.BinaryWrite(System.Text.Encoding.UTF8.GetBytes(strExcel.Substring(startIndex, strExcel.Length - startIndex)));
            response.Flush();
            response.End();
        }