所见即所得的导出到excel的方法

 

因为Excel可以打开html文件，所以我们可以把html文件的内容输出到一个xls文件里，这样就实现了所见即所得的输出。

 

       public void outputExcel()

       {

            string printUrl = "要输出的报表文件.aspx”;  // 此文件就是一个输出数据表格的网页，可以是html也可以是aspx

 

            string printText = GetterUtil.GetUrlContent(printUrl);

 

            Response.ContentEncoding = Encoding.UTF8;

            Response.AddHeader("Content-Disposition", "attachment; filename=输出文件名.xls");

            Response.Write(printText);

            Response.End();

        }

 

        public static string GetUrlContent(string printUrl)

        {

            HttpWebRequest req = (HttpWebRequest)WebRequest.Create(printUrl);

 

            HttpWebResponse resp = (HttpWebResponse)req.GetResponse();

            StreamReader sr = new StreamReader(resp.GetResponseStream(), Encoding.UTF8);

            StringBuilder ret = new StringBuilder();

            int bufferLengh = 8 * 1024;  // 16K

            char[] buf = new char[bufferLengh];

            int len = sr.Read(buf, 0, bufferLengh);

            while (len > 0)

            {

                ret.Append(new string(buf, 0, len));

                len = sr.Read(buf, 0, bufferLengh);

            }

            return ret.ToString();

        }