使用HTML,CSS快速导出数据到Excel

最新推荐文章于 2024-11-15 16:31:12 发布

fret444

最新推荐文章于 2024-11-15 16:31:12 发布

阅读量753

点赞数

分类专栏： web开发文章标签： css html excel class date random

本文链接：https://blog.csdn.net/fret444/article/details/5974075

版权

web开发专栏收录该内容

4 篇文章 0 订阅

订阅专栏

在head中加入css定义

<style type="text/css">
.spercent
{
background-color:#ffff99;
mso-number-format:0.00%;
}
</style>
在css中加入：mso-number-format定义数据格式，格式可以在excel中查看自定义格式，具体可以参考一下：
mso-number-format:"0" NO Decimals
mso-number-format:"0/.000" 3 Decimals
mso-number-format:"/#/,/#/#0/.000" Comma with 3 dec
mso-number-format:"mm//dd//yy" Date7
mso-number-format:"mmmm/ d/,/ yyyy" Date9
mso-number-format:"m//d//yy/ h/:mm/ AM//PM" D -T AMPM
mso-number-format:"Short Date" 01/03/1998
mso-number-format:"Medium Date" 01-mar-98
mso-number-format:"d/-mmm/-yyyy" 01-mar-1998
mso-number-format:"Short Time" 5:16
mso-number-format:"Medium Time" 5:16 am
mso-number-format:"Long Time" 5:16:21:00
mso-number-format:"Percent" Percent - two decimals
mso-number-format:"0%" Percent - no decimals
mso-number-format:"0/.E+00" Scientific Notation
mso-number-format:"/@" Text
mso-number-format:"/#/ ???//???" Fractions - up to 3 digits (312/943)

导出的excel可以直接通过excel打开，效果如下:

完整代码：

ALL Code
class Program
    {
        protected const string HEADER = "<html xmlns:x=/"urn:schemas-microsoft-com:office:excel/">" +
                                          "<meta http-equiv=Content-Type content=/"text/html; charset=/"gb2312/">" +
                                          "<head>" +
                                          "" ;

        const string STYLE="<style type=/"text/css/">" +
                                       ".spercent" +
                                       " {" +
                                       "   background-color:#ffff99;" +
                                       "   mso-number-format:0.00%;" +
                                       " }" +
                                        ".sId" http://msnpiki.msnfanatic.com/index.php/Main_Page-->
0;">+
                                       " {" +
                                       "   background-color:#ff6633;" +
                                       "   mso-number-format:0;" +
                                       " }" +
                                        ".sName" +
                                       " {" +
                                       "     color:red;" +
                                       " }" +
                                        ".sValue" +
                                       " {" +
                                       "   color:blue;" +
                                       "   mso-number-format:0;" +
                                       " }" +
                                       "</style>";

        static void Main(string[] args)
        {
            using (StreamWriter writer = new StreamWriter(@"C:/1.xls", true, System.Text.Encoding.GetEncoding("gb2312"
style="color: #000000;">), 512))
            {
                writer.WriteLine(HEADER);
                writer.WriteLine(STYLE);
                writer.WriteLine("</head><body><table border=/"1/" style=/"font-size:9pt/"><tr>");
                writer.WriteLine ("<th>ID</th>");
                writer.WriteLine ("<th>Name</th>");
                writer.WriteLine ("<th>Value</th>");
                writer.WriteLine ("<th>Percent</th>");

                for (int row = 1; row < 50; row++)
                {
                    writer.WriteLine("<tr>");
                    writer.WriteLine("<td class=/"sId/">{0}</td", row);
                    writer.WriteLine("<td class=/"sName/">{0}</td", Guid.NewGuid ().ToString ());
                    writer.WriteLine("<td class=/"sValue/">{0}</td", new Random().Next());
                    writer.WriteLine("<td class=/"spercent/">{0}</td", new Random().NextDouble());
                    writer.WriteLine("</tr>");
                }

                writer.WriteLine("</table></body>");
            }

        }
    }

http://www.diybl.com/course/4_webprogram/asp.net/netjs/20091019/179435.html