html 导出excel小体表,html table导出Excel后样式消失。

为什么样式写在

标签中导出的Excel才能有样式,如何解决css自动加载

xmlns:x="urn:schemas-microsoft-com:office:excel"

xmlns="http://www.w3.org/TR/REC-html40">

tr

{mso-height-source:auto;

mso-ruby-visibility:none;}

col

{mso-width-source:auto;

mso-ruby-visibility:none;}

br

{mso-data-placement:same-cell;}

ruby

{ruby-align:left;}

.style0

{mso-number-format:General;

text-align:general;

vertical-align:bottom;

white-space:nowrap;

mso-rotate:0;

mso-background-source:auto;

mso-pattern:auto;

color:black;

font-size:11.0pt;

font-weight:400;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;

border:none;

mso-protection:locked visible;

mso-style-name:常规;

mso-style-id:0;}

.font18

{color:black;

font-size:11.0pt;

font-weight:700;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;}

.font19

{color:red;

font-size:11.0pt;

font-weight:700;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;}

.font20

{color:red;

font-size:11.0pt;

font-weight:400;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;}

.font21

{color:black;

font-size:11.0pt;

font-weight:400;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;}

.font22

{color:black;

font-size:9.0pt;

font-weight:700;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;}

td

{mso-style-parent:style0;

padding:0px;

mso-ignore:padding;

color:black;

font-size:11.0pt;

font-weight:400;

font-style:normal;

text-decoration:none;

font-family:宋体;

mso-generic-font-family:auto;

mso-font-charset:134;

mso-number-format:General;

text-align:general;

vertical-align:bottom;

border:none;

mso-background-source:auto;

mso-pattern:auto;

mso-protection:locked visible;

white-space:nowrap;

mso-rotate:0;}

.xl65

{mso-style-parent:style0;

vertical-align:middle;}

.xl66

{mso-style-parent:style0;

font-size:10.0pt;

vertical-align:middle;}

.xl67

{mso-style-parent:style0;

font-size:10.0pt;

vertical-align:middle;

white-space:normal;}

.xl68

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border:1.0pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl69

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:none;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl70

{mso-style-parent:style0;

vertical-align:middle;

border-top:none;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl71

{mso-style-parent:style0;

vertical-align:middle;

border-top:none;

border-right:none;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl72

{mso-style-parent:style0;

vertical-align:middle;

border:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl73

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:none;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl74

{mso-style-parent:style0;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl75

{mso-style-parent:style0;

color:red;

vertical-align:middle;

border:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl76

{mso-style-parent:style0;

font-weight:700;

vertical-align:middle;

border:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl77

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl78

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:none;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl79

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:none;

background:#B7DEE8;

mso-pattern:black none;}

.xl80

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl81

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;

white-space:normal;}

.xl82

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:none;

background:#E4DFEC;

mso-pattern:black none;}

.xl83

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:none;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:none;

background:#B7DEE8;

mso-pattern:black none;}

.xl84

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:none;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl85

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:none;

border-right:1.0pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;

white-space:normal;}

.xl86

{mso-style-parent:style0;

vertical-align:middle;

border-top:none;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl87

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:none;

background:#B7DEE8;

mso-pattern:black none;}

.xl88

{mso-style-parent:style0;

vertical-align:middle;

border:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl89

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;

white-space:normal;}

.xl90

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl91

{mso-style-parent:style0;

color:red;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;

white-space:normal;}

.xl92

{mso-style-parent:style0;

color:red;

vertical-align:middle;

border:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl93

{mso-style-parent:style0;

color:red;

vertical-align:middle;

border:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;

white-space:normal;}

.xl94

{mso-style-parent:style0;

color:windowtext;

vertical-align:middle;

border:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl95

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl96

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:none;

background:#B7DEE8;

mso-pattern:black none;}

.xl97

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl98

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;

white-space:normal;}

.xl99

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:1.0pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl100

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:none;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:1.0pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl101

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl102

{mso-style-parent:style0;

font-weight:700;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl103

{mso-style-parent:style0;

color:red;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl104

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl105

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl106

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:1.0pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl107

{mso-style-parent:style0;

font-weight:700;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl108

{mso-style-parent:style0;

font-weight:700;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl109

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl110

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;

white-space:normal;}

.xl111

{mso-style-parent:style0;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl112

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;}

.xl113

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;}

.xl114

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;}

.xl115

{mso-style-parent:style0;

font-size:16.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;}

.xl116

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border:.5pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl117

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border:.5pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl118

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border:.5pt solid windowtext;

background:#CCC0DA;

mso-pattern:black none;}

.xl119

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border:.5pt solid windowtext;}

.xl120

{mso-style-parent:style0;

font-size:10.0pt;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;}

.xl121

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl122

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border:.5pt solid windowtext;

background:#E6B8B7;

mso-pattern:black none;}

.xl123

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border:.5pt solid windowtext;

background:#8DB4E2;

mso-pattern:black none;}

.xl124

{mso-style-parent:style0;

text-align:center;}

.xl125

{mso-style-parent:style0;

font-size:12.0pt;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border:.5pt solid windowtext;}

.xl126

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl127

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E6B8B7;

mso-pattern:black none;}

.xl128

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#8DB4E2;

mso-pattern:black none;}

.xl129

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#8DB4E2;

mso-pattern:black none;}

.xl130

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl131

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#8DB4E2;

mso-pattern:black none;}

.xl132

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;}

.xl133

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl134

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:1.0pt solid windowtext;}

.xl135

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl136

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl137

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl138

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border:.5pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl139

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl140

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border:.5pt solid windowtext;

background:#E6B8B7;

mso-pattern:black none;}

.xl141

{mso-style-parent:style0;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E6B8B7;

mso-pattern:black none;}

.xl142

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;}

.xl143

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border:.5pt solid windowtext;}

.xl144

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl145

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:1.0pt solid windowtext;}

.xl146

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl147

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl148

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl149

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E6B8B7;

mso-pattern:black none;}

.xl150

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E6B8B7;

mso-pattern:black none;}

.xl151

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#E6B8B7;

mso-pattern:black none;}

.xl152

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:none;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl153

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:none;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl154

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#8DB4E2;

mso-pattern:black none;}

.xl155

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:none;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl156

{mso-style-parent:style0;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:.5pt solid windowtext;

border-right:none;

border-bottom:1.0pt solid windowtext;

border-left:.5pt solid windowtext;}

.xl157

{mso-style-parent:style0;

font-size:14.0pt;

font-weight:700;

text-align:center;

vertical-align:middle;}

.xl158

{mso-style-parent:style0;

font-size:16.0pt;

font-weight:700;

text-align:center;

vertical-align:middle;}

.xl159

{mso-style-parent:style0;

font-size:12.0pt;

text-align:center;

vertical-align:middle;}

.xl160

{mso-style-parent:style0;

text-align:center;

vertical-align:middle;}

.xl161

{mso-style-parent:style0;

font-size:12.0pt;

text-align:right;

vertical-align:middle;}

.xl162

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl163

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl164

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl165

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#FCD5B4;

mso-pattern:black none;}

.xl166

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:.5pt solid windowtext;

border-left:.5pt solid windowtext;

background:#CCC0DA;

mso-pattern:black none;}

.xl167

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:.5pt solid windowtext;

border-left:none;

background:#CCC0DA;

mso-pattern:black none;}

.xl168

{mso-style-parent:style0;

font-size:12.0pt;

font-weight:700;

font-family:微软雅黑, sans-serif;

mso-font-charset:134;

text-align:center;

border-top:1.0pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:none;

background:#CCC0DA;

mso-pattern:black none;}

.xl169

{mso-style-parent:style0;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:1.0pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl170

{mso-style-parent:style0;

text-align:center;

vertical-align:middle;

border-top:.5pt solid windowtext;

border-right:.5pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl171

{mso-style-parent:style0;

color:red;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:none;

border-left:1.0pt solid windowtext;

mso-diagonal-down:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl172

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:none;

border-left:none;

mso-diagonal-down:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl173

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:none;

border-right:none;

border-bottom:1.0pt solid windowtext;

border-left:1.0pt solid windowtext;

mso-diagonal-down:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl174

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:none;

border-right:1.0pt solid windowtext;

border-bottom:1.0pt solid windowtext;

border-left:none;

mso-diagonal-down:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl175

{mso-style-parent:style0;

font-size:14.0pt;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:none;

border-left:1.0pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl176

{mso-style-parent:style0;

font-size:14.0pt;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:none;

border-left:none;

background:#E4DFEC;

mso-pattern:black none;}

.xl177

{mso-style-parent:style0;

font-size:14.0pt;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:none;

border-left:none;

background:#E4DFEC;

mso-pattern:black none;}

.xl178

{mso-style-parent:style0;

font-size:14.0pt;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:none;

border-left:1.0pt solid windowtext;

background:#B7DEE8;

mso-pattern:black none;}

.xl179

{mso-style-parent:style0;

font-size:14.0pt;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:none;

border-left:none;

background:#B7DEE8;

mso-pattern:black none;}

.xl180

{mso-style-parent:style0;

font-size:14.0pt;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:none;

border-left:none;

background:#B7DEE8;

mso-pattern:black none;}

.xl181

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:none;

border-left:none;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl182

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:1.0pt solid windowtext;

border-bottom:none;

border-left:none;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl183

{mso-style-parent:style0;

text-align:center;

vertical-align:middle;

border-top:none;

border-right:.5pt solid windowtext;

border-bottom:none;

border-left:1.0pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl184

{mso-style-parent:style0;

text-align:center;

vertical-align:middle;

border-top:none;

border-right:.5pt solid windowtext;

border-bottom:.5pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;}

.xl185

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:none;

border-left:1.0pt solid windowtext;

mso-diagonal-down:.5pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl186

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:1.0pt solid windowtext;

border-left:1.0pt solid windowtext;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

.xl187

{mso-style-parent:style0;

font-weight:700;

text-align:center;

vertical-align:middle;

border-top:1.0pt solid windowtext;

border-right:none;

border-bottom:1.0pt solid windowtext;

border-left:none;

background:#E4DFEC;

mso-pattern:black none;

white-space:normal;}

var tableToExcel = (function() {

var uri = 'data:application/vnd.ms-excel;base64,'

, template = '

'

, base64 = function(s) { return window.btoa(unescape(encodeURIComponent(s))) }

, format = function(s, c) { return s.replace(/{(\w+)}/g, function(m, p) { return c[p]; }) }

return function(table, name) {

if (!table.nodeType) table = document.getElementById(table)

var ctx = {worksheet: name || 'Worksheet', table: table.innerHTML}

window.location.href = uri + base64(format(template, ctx))

}

})()

机会费用管理报表
报表单位:
报表年月:单位:元
机会信息简况当月人工成本本年人工成本机会累计人工成本当月日常开支本年日常开支项目累计日常费用
机会名称客户名称项目发起方机会类型创建人人工成本小计人工成本小计人工成本小计日常开支小计日常开支小计日常开支小计
机会          
  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
导出Excel 表格样式可以通过修改导出HTML 表格的 CSS 样式来实现,具体步骤如下: 1. 在 Vue 组件中导出 Excel 表格时,将表格数据渲染为 HTML 表格,并将其放在一个隐藏的 div 中。 ```javascript exportExcel() { const table = document.getElementById('table') const html = table.outerHTML const blob = new Blob([html], { type: 'application/vnd.ms-excel' }) const link = document.createElement('a') link.download = 'data.xls' link.href = URL.createObjectURL(blob) link.click() } ``` 2. 在导出 Excel 表格的方法中,获取到表格元素并将其转换为 HTML 字符串。 3. 在导出HTML 字符串中,找到表格元素所在的位置,即 `<table>` 标签。 4. 在 `<head>` 标签中添加样式表,并根据需要添加自定义样式。例如,可以设置表格的背景色、字体和边框等。 ```javascript exportExcel() { const table = document.getElementById('table') const html = table.outerHTML const style = ` <style> table { background-color: #f9f9f9; font-family: Arial, sans-serif; border-collapse: collapse; width: 100%; } th, td { border: 1px solid #ddd; padding: 8px; text-align: left; } th { background-color: #4CAF50; color: white; } </style> ` const blob = new Blob([`${style}${html}`], { type: 'application/vnd.ms-excel' }) const link = document.createElement('a') link.download = 'data.xls' link.href = URL.createObjectURL(blob) link.click() } ``` 5. 将样式表添加到 HTML 字符串中,并将其与表格 HTML 字符串合并为一个字符串。 6. 通过 Blob 对象将 HTML 字符串转换为 Excel 文件,并通过 a 标签的 click 事件触发下载。 这样就可以在导出 Excel 表格时添加自定义样式

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值