第十二篇 C# 將HTML 直接轉成Excel

最後更新：2014-12-28 來源：互聯網

上載者：User

創建阿里雲帳戶，並獲得超過 40 款產品的免費試用版；而企業帳戶則可以享有總值 $1200 的免費試用版。立即註冊！

標籤：

前些天寫項目的時候，客戶要求用HTML表格把資訊展示出來，後面還要用展示的內容要匯出Excel。本來想想在後台操作的話估計是要做死了，但是經過細想，Excel能夠發布成HTML,一定也可以由HTML轉成Excel。經過幾次搜尋，算是把問題完善解決了代碼如下（不能用Ajax調用來完成，因為Ajax不會重新整理頁面）:

            Response.ContentType = "application/force-download";            Response.AddHeader("content-disposition",                "attachment; filename=" + DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls");            Response.Write("<html xmlns:x=\"urn:schemas-microsoft-com:office:excel\">");            Response.Write("<head>");            Response.Write("<META http-equiv=\"Content-Type\" content=\"text/html; charset=utf-8\">");            #region 樣式的讀取            string fileCss = Server.MapPath("~/Content/CalCSS/tableCss.css");            string cssText = string.Empty;            StreamReader sr = new StreamReader(fileCss);            var line = string.Empty;            while ((line = sr.ReadLine()) != null)            {                cssText += line;            }            sr.Close();            Response.Write("<style>" + cssText + "</style>");            #endregion            Response.Write("<!--[if gte mso 9]><xml>");            Response.Write("<x:ExcelWorkbook>");            Response.Write("<x:ExcelWorksheets>");            Response.Write("<x:ExcelWorksheet>");            Response.Write("<x:Name>Report Data</x:Name>");            Response.Write("<x:WorksheetOptions>");            Response.Write("<x:Print>");            Response.Write("<x:ValidPrinterInfo/>");            Response.Write("</x:Print>");            Response.Write("</x:WorksheetOptions>");            Response.Write("</x:ExcelWorksheet>");            Response.Write("</x:ExcelWorksheets>");            Response.Write("</x:ExcelWorkbook>");            Response.Write("</xml>");            Response.Write("<![endif]--> ");            Response.Write(strHtml1);//這裡是前台頁面的HTML            Response.Flush();            Response.End();

經過測試能夠完全的展示頁面的樣式和規格：

前台HTML:

下載後的Excel:

第十二篇 C# 將HTML 直接轉成Excel

本文章原先以中文撰寫並發佈於 aliyun.com，亦設英文版本，僅作資訊用途。本網站不對文章的準確性，完整性或可靠性或其任何翻譯作出任何明示或暗示的陳述或保證。如對該文章有任何疑慮或投訴，請傳送電郵至 info-contact@alibabacloud.com 並提供相關疑慮或投訴的詳細說明。職員會於 5 個工作天內與您聯絡，一經驗證之後，即會刪除該侵權內容。

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

Get Started for Free

Sales Support

1 on 1 presale consultation

Chat Contact Sales
After-Sales Support

24/7 Technical Support 6 Free Tickets per Quarter Faster Response

Open a Ticket
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.

Learn More