{"id":504,"date":"2026-04-02T11:08:31","date_gmt":"2026-04-02T03:08:31","guid":{"rendered":"http:\/\/47.100.88.125\/?page_id=504"},"modified":"2026-04-08T13:51:13","modified_gmt":"2026-04-08T05:51:13","slug":"excel-%e5%85%ac%e5%bc%8f%e6%9f%a5%e8%af%a2","status":"publish","type":"page","link":"https:\/\/www.05621997.xyz\/index.php\/tools\/excel-%e5%85%ac%e5%bc%8f%e6%9f%a5%e8%af%a2\/","title":{"rendered":"Excel \u516c\u5f0f\u67e5\u8be2"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-page\" data-elementor-id=\"504\" class=\"elementor elementor-504\" data-elementor-post-type=\"page\">\n\t\t\t\t<div class=\"elementor-element elementor-element-57c076b e-con-full e-flex e-con e-parent\" data-id=\"57c076b\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-564b103 elementor-widget elementor-widget-heading\" data-id=\"564b103\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">Excel \u516c\u5f0f\u67e5\u8be2<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-4daa562 e-con-full e-flex e-con e-parent\" data-id=\"4daa562\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-5967e9b elementor-widget elementor-widget-heading\" data-id=\"5967e9b\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t\t<h6 class=\"elementor-heading-title elementor-size-default\">\u6536\u96c6\u4e86\u4e00\u4e9b\u5e38\u7528\u7684\u516c\u5f0f<\/h6>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-bb1c83c e-con-full e-flex e-con e-parent\" data-id=\"bb1c83c\" data-element_type=\"container\" data-e-type=\"container\">\n\t\t\t\t<div class=\"elementor-element elementor-element-98ecd1c elementor-widget elementor-widget-html\" data-id=\"98ecd1c\" data-element_type=\"widget\" data-e-type=\"widget\" data-widget_type=\"html.default\">\n\t\t\t\t\t<style>\r\n\r\n.excel_tb_wrap{\r\n    width: 100%;\r\n    max-width: 1100px;\r\n    margin: 10px auto;\r\n    padding: 0 15px;\r\n    box-sizing: border-box;\r\n}\r\n.excel_tb_search{\r\n    width: 100%;\r\n    padding: 10px;\r\n    margin-bottom: 15px;\r\n    border:1px solid #ddd;\r\n    border-radius:4px;\r\n    box-sizing:border-box;\r\n}\r\n\r\n.excel_table_scroll {\r\n    width: 100%;\r\n    overflow-x: auto;\r\n    -webkit-overflow-scrolling: touch; \r\n}\r\n.excel_tb{\r\n    width: 100%;\r\n    min-width: 600px; \r\n    border-collapse:collapse;\r\n    background:#fff;\r\n}\r\n.excel_tb th,.excel_tb td{\r\n    border:1px solid #eee;\r\n    padding: 8px; \r\n    text-align:left;\r\n    font-size:13px; \r\n    white-space: nowrap; \r\n}\r\n.excel_tb th{\r\n    background:#f5f5f5;\r\n    font-weight:bold;\r\n}\r\n.excel_copy_btn{\r\n    padding:5px 8px;\r\n    background:#0073aa;\r\n    color:#fff;\r\n    border:none;\r\n    border-radius:3px;\r\n    cursor:pointer;\r\n    font-size:12px;\r\n    white-space: nowrap;\r\n}\r\n.excel_copy_tip{\r\n    position:fixed;\r\n    bottom:20px;\r\n    left:50%;\r\n    transform:translateX(-50%);\r\n    background:#28a745;\r\n    color:#fff;\r\n    padding:8px 16px;\r\n    border-radius:4px;\r\n    display:none;\r\n    z-index:999;\r\n}\r\n<\/style>\r\n\r\n<div class=\"excel_tb_wrap\">\r\n    <input type=\"text\" class=\"excel_tb_search\" id=\"excelSearch\" placeholder=\"\u641c\u7d22\u516c\u5f0f\u540d\u79f0\/\u8bed\u6cd5\/\u7528\u9014\">\r\n    <div class=\"excel_table_scroll\">\r\n        <table class=\"excel_tb\" id=\"excelTable\">\r\n            <thead>\r\n                <tr>\r\n                    <th>\u516c\u5f0f\u540d\u79f0<\/th>\r\n                    <th>\u516c\u5f0f\u8bed\u6cd5<\/th>\r\n                    <th>\u529f\u80fd\u8bf4\u660e<\/th>\r\n                    <th>\u64cd\u4f5c<\/th>\r\n                <\/tr>\r\n            <\/thead>\r\n            <tbody id=\"excelBody\"><\/tbody>\r\n        <\/table>\r\n    <\/div>\r\n    <div class=\"excel_copy_tip\" id=\"excelTip\">\u590d\u5236\u6210\u529f<\/div>\r\n<\/div>\r\n\r\n<script>\r\nvar excelData = [\r\n    {name:\"SUM \u6c42\u548c\", syntax:\"=SUM(\u6570\u5b571,\u6570\u5b572,...)\", desc:\"\u8ba1\u7b97\u6570\u503c\u6216\u5355\u5143\u683c\u533a\u57df\u603b\u548c\"},\r\n    {name:\"AVERAGE \u5e73\u5747\u503c\", syntax:\"=AVERAGE(\u533a\u57df)\", desc:\"\u8ba1\u7b97\u4e00\u7ec4\u6570\u503c\u7684\u7b97\u672f\u5e73\u5747\u503c\"},\r\n    {name:\"VLOOKUP \u5782\u76f4\u67e5\u627e\", syntax:\"=VLOOKUP(\u67e5\u627e\u503c,\u533a\u57df,\u5217\u53f7,\u5339\u914d\u7c7b\u578b)\", desc:\"\u6309\u5217\u5782\u76f4\u67e5\u627e\u6570\u636e\"},\r\n    {name:\"HLOOKUP \u6c34\u5e73\u67e5\u627e\", syntax:\"=HLOOKUP(\u67e5\u627e\u503c,\u533a\u57df,\u884c\u53f7,\u5339\u914d\u7c7b\u578b)\", desc:\"\u6309\u884c\u6c34\u5e73\u67e5\u627e\u6570\u636e\"},\r\n    {name:\"XLOOKUP \u9ad8\u7ea7\u67e5\u627e\", syntax:\"=XLOOKUP(\u67e5\u627e\u503c,\u67e5\u627e\u5217,\u8fd4\u56de\u5217)\", desc:\"Excel365\u65b0\u7248\u67e5\u627e\u51fd\u6570\"},\r\n    {name:\"IF \u6761\u4ef6\u5224\u65ad\", syntax:\"=IF(\u6761\u4ef6,\u6210\u7acb\u503c,\u4e0d\u6210\u7acb\u503c)\", desc:\"\u6839\u636e\u6761\u4ef6\u8fd4\u56de\u5bf9\u5e94\u7ed3\u679c\"},\r\n    {name:\"IFERROR \u9519\u8bef\u5904\u7406\", syntax:\"=IFERROR(\u516c\u5f0f,\u9519\u8bef\u8fd4\u56de\u503c)\", desc:\"\u5c4f\u853d\u516c\u5f0f\u9519\u8bef\u63d0\u793a\"},\r\n    {name:\"COUNT \u6570\u5b57\u8ba1\u6570\", syntax:\"=COUNT(\u533a\u57df)\", desc:\"\u7edf\u8ba1\u5305\u542b\u6570\u5b57\u7684\u5355\u5143\u683c\u6570\u91cf\"},\r\n    {name:\"COUNTA \u975e\u7a7a\u8ba1\u6570\", syntax:\"=COUNTA(\u533a\u57df)\", desc:\"\u7edf\u8ba1\u533a\u57df\u5185\u975e\u7a7a\u5355\u5143\u683c\u603b\u6570\"},\r\n    {name:\"COUNTIF \u5355\u6761\u4ef6\u8ba1\u6570\", syntax:\"=COUNTIF(\u533a\u57df,\u6761\u4ef6)\", desc:\"\u6309\u5355\u4e2a\u6761\u4ef6\u7edf\u8ba1\u6570\u91cf\"},\r\n    {name:\"COUNTIFS \u591a\u6761\u4ef6\u8ba1\u6570\", syntax:\"=COUNTIFS(\u533a1,\u67611,\u533a2,\u67612)\", desc:\"\u6309\u591a\u4e2a\u6761\u4ef6\u7edf\u8ba1\"},\r\n    {name:\"SUMIF \u5355\u6761\u4ef6\u6c42\u548c\", syntax:\"=SUMIF(\u6761\u4ef6\u533a,\u6761\u4ef6,\u6c42\u548c\u533a)\", desc:\"\u6309\u5355\u4e2a\u6761\u4ef6\u6c42\u548c\"},\r\n    {name:\"SUMIFS \u591a\u6761\u4ef6\u6c42\u548c\", syntax:\"=SUMIFS(\u6c42\u548c\u533a,\u533a1,\u67611,\u533a2,\u67612)\", desc:\"\u6309\u591a\u4e2a\u6761\u4ef6\u6c42\u548c\"},\r\n    {name:\"MAX \u6700\u5927\u503c\", syntax:\"=MAX(\u533a\u57df)\", desc:\"\u8fd4\u56de\u6570\u503c\u533a\u57df\u4e2d\u7684\u6700\u5927\u503c\"},\r\n    {name:\"MIN \u6700\u5c0f\u503c\", syntax:\"=MIN(\u533a\u57df)\", desc:\"\u8fd4\u56de\u6570\u503c\u533a\u57df\u4e2d\u7684\u6700\u5c0f\u503c\"},\r\n    {name:\"ROUND \u56db\u820d\u4e94\u5165\", syntax:\"=ROUND(\u6570\u5b57,\u5c0f\u6570\u4f4d\u6570)\", desc:\"\u6570\u5b57\u6309\u6307\u5b9a\u4f4d\u6570\u56db\u820d\u4e94\u5165\"},\r\n    {name:\"INT \u53d6\u6574\", syntax:\"=INT(\u6570\u5b57)\", desc:\"\u5c06\u6570\u5b57\u5411\u4e0b\u53d6\u6574\u4e3a\u6574\u6570\"},\r\n    {name:\"MOD \u53d6\u4f59\u6570\", syntax:\"=MOD(\u88ab\u9664\u6570,\u9664\u6570)\", desc:\"\u8fd4\u56de\u4e24\u6570\u76f8\u9664\u7684\u4f59\u6570\"},\r\n    {name:\"TRIM \u53bb\u9664\u7a7a\u683c\", syntax:\"=TRIM(\u6587\u672c)\", desc:\"\u5220\u9664\u6587\u672c\u9996\u5c3e\u591a\u4f59\u7a7a\u683c\"},\r\n    {name:\"LEN \u5b57\u7b26\u957f\u5ea6\", syntax:\"=LEN(\u6587\u672c)\", desc:\"\u8ba1\u7b97\u6587\u672c\u5b57\u7b26\u4e32\u7684\u5b57\u7b26\u4e2a\u6570\"},\r\n    {name:\"LEFT \u5de6\u622a\u53d6\", syntax:\"=LEFT(\u6587\u672c,\u622a\u53d6\u957f\u5ea6)\", desc:\"\u4ece\u6587\u672c\u5de6\u4fa7\u622a\u53d6\u5b57\u7b26\"},\r\n    {name:\"RIGHT \u53f3\u622a\u53d6\", syntax:\"=RIGHT(\u6587\u672c,\u622a\u53d6\u957f\u5ea6)\", desc:\"\u4ece\u6587\u672c\u53f3\u4fa7\u622a\u53d6\u5b57\u7b26\"},\r\n    {name:\"MID \u4e2d\u95f4\u622a\u53d6\", syntax:\"=MID(\u6587\u672c,\u8d77\u59cb\u4f4d,\u957f\u5ea6)\", desc:\"\u4ece\u6587\u672c\u4e2d\u95f4\u622a\u53d6\u5b57\u7b26\"},\r\n    {name:\"CONCAT \u6587\u672c\u62fc\u63a5\", syntax:\"=CONCAT(\u6587\u672c1,\u6587\u672c2)\", desc:\"\u62fc\u63a5\u591a\u4e2a\u6587\u672c\u6216\u5355\u5143\u683c\"},\r\n    {name:\"TEXTJOIN \u5206\u9694\u62fc\u63a5\", syntax:\"=TEXTJOIN(\u5206\u9694\u7b26,\u5ffd\u7565\u7a7a\u503c,\u5185\u5bb9)\", desc:\"\u5e26\u5206\u9694\u7b26\u5408\u5e76\u6587\u672c\"},\r\n    {name:\"UPPER \u8f6c\u5927\u5199\", syntax:\"=UPPER(\u6587\u672c)\", desc:\"\u5c06\u6587\u672c\u5168\u90e8\u8f6c\u6362\u4e3a\u5927\u5199\u5b57\u6bcd\"},\r\n    {name:\"LOWER \u8f6c\u5c0f\u5199\", syntax:\"=LOWER(\u6587\u672c)\", desc:\"\u5c06\u6587\u672c\u5168\u90e8\u8f6c\u6362\u4e3a\u5c0f\u5199\u5b57\u6bcd\"},\r\n    {name:\"PROPER \u9996\u5b57\u6bcd\u5927\u5199\", syntax:\"=PROPER(\u6587\u672c)\", desc:\"\u5355\u8bcd\u9996\u5b57\u6bcd\u5927\u5199\u5176\u4f59\u5c0f\u5199\"},\r\n    {name:\"TODAY \u5f53\u524d\u65e5\u671f\", syntax:\"=TODAY()\", desc:\"\u8fd4\u56de\u7cfb\u7edf\u5f53\u524d\u65e5\u671f\"},\r\n    {name:\"NOW \u5f53\u524d\u65f6\u95f4\", syntax:\"=NOW()\", desc:\"\u8fd4\u56de\u7cfb\u7edf\u5f53\u524d\u65e5\u671f\u548c\u65f6\u95f4\"},\r\n    {name:\"YEAR \u63d0\u53d6\u5e74\u4efd\", syntax:\"=YEAR(\u65e5\u671f)\", desc:\"\u4ece\u65e5\u671f\u4e2d\u63d0\u53d6\u5e74\u4efd\u6570\u5b57\"},\r\n    {name:\"MONTH \u63d0\u53d6\u6708\u4efd\", syntax:\"=MONTH(\u65e5\u671f)\", desc:\"\u4ece\u65e5\u671f\u4e2d\u63d0\u53d6\u6708\u4efd\u6570\u5b57\"},\r\n    {name:\"DAY \u63d0\u53d6\u65e5\u671f\", syntax:\"=DAY(\u65e5\u671f)\", desc:\"\u4ece\u65e5\u671f\u4e2d\u63d0\u53d6\u5929\u6570\u6570\u5b57\"},\r\n    {name:\"DATEDIF \u65e5\u671f\u5dee\", syntax:\"=DATEDIF(\u5f00\u59cb\u65e5,\u7ed3\u675f\u65e5,\u5355\u4f4d)\", desc:\"\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\u7684\u5dee\u503c\"},\r\n    {name:\"INDEX \u7d22\u5f15\u53d6\u503c\", syntax:\"=INDEX(\u533a\u57df,\u884c\u53f7,\u5217\u53f7)\", desc:\"\u6309\u4f4d\u7f6e\u8fd4\u56de\u5355\u5143\u683c\u503c\"},\r\n    {name:\"MATCH \u67e5\u627e\u4f4d\u7f6e\", syntax:\"=MATCH(\u67e5\u627e\u503c,\u533a\u57df,\u7c7b\u578b)\", desc:\"\u8fd4\u56de\u6570\u636e\u5728\u533a\u57df\u4e2d\u7684\u4f4d\u7f6e\"},\r\n    {name:\"OFFSET \u504f\u79fb\u5f15\u7528\", syntax:\"=OFFSET(\u8d77\u70b9,\u884c\u504f,\u5217\u504f,\u9ad8,\u5bbd)\", desc:\"\u504f\u79fb\u540e\u5f15\u7528\u5355\u5143\u683c\u533a\u57df\"},\r\n    {name:\"AND \u903b\u8f91\u4e0e\", syntax:\"=AND(\u6761\u4ef61,\u6761\u4ef62)\", desc:\"\u6240\u6709\u6761\u4ef6\u6210\u7acb\u8fd4\u56deTRUE\"},\r\n    {name:\"OR \u903b\u8f91\u6216\", syntax:\"=OR(\u6761\u4ef61,\u6761\u4ef62)\", desc:\"\u4efb\u4e00\u6761\u4ef6\u6210\u7acb\u8fd4\u56deTRUE\"},\r\n    {name:\"NOT \u903b\u8f91\u975e\", syntax:\"=NOT(\u6761\u4ef6)\", desc:\"\u53cd\u8f6c\u6761\u4ef6\u7684\u903b\u8f91\u7ed3\u679c\"},\r\n    {name:\"ISBLANK \u7a7a\u503c\u5224\u65ad\", syntax:\"=ISBLANK(\u5355\u5143\u683c)\", desc:\"\u5224\u65ad\u5355\u5143\u683c\u662f\u5426\u4e3a\u7a7a\"},\r\n    {name:\"RAND \u968f\u673a\u5c0f\u6570\", syntax:\"=RAND()\", desc:\"\u751f\u62100-1\u4e4b\u95f4\u7684\u968f\u673a\u5c0f\u6570\"},\r\n    {name:\"RANDBETWEEN \u968f\u673a\u6574\u6570\", syntax:\"=RANDBETWEEN(\u6700\u5c0f,\u6700\u5927)\", desc:\"\u751f\u6210\u6307\u5b9a\u8303\u56f4\u968f\u673a\u6574\u6570\"},\r\n    {name:\"RANK \u6392\u540d\", syntax:\"=RANK(\u6570\u5b57,\u533a\u57df,\u6392\u5e8f\u65b9\u5f0f)\", desc:\"\u8fd4\u56de\u6570\u5b57\u5728\u533a\u57df\u4e2d\u7684\u6392\u540d\"},\r\n    {name:\"SUBTOTAL \u7b5b\u9009\u6c47\u603b\", syntax:\"=SUBTOTAL(\u529f\u80fd\u7801,\u533a\u57df)\", desc:\"\u4ec5\u8ba1\u7b97\u53ef\u89c1\u5355\u5143\u683c\u6c47\u603b\"},\r\n    {name:\"HYPERLINK \u8d85\u94fe\u63a5\", syntax:\"=HYPERLINK(\u5730\u5740,\u663e\u793a\u6587\u672c)\", desc:\"\u521b\u5efa\u53ef\u70b9\u51fb\u8d85\u94fe\u63a5\"},\r\n    {name:\"WEEKDAY \u661f\u671f\", syntax:\"=WEEKDAY(\u65e5\u671f,\u7c7b\u578b)\", desc:\"\u8fd4\u56de\u65e5\u671f\u5bf9\u5e94\u7684\u661f\u671f\u6570\"},\r\n    {name:\"HOUR \u63d0\u53d6\u5c0f\u65f6\", syntax:\"=HOUR(\u65f6\u95f4)\", desc:\"\u4ece\u65f6\u95f4\u4e2d\u63d0\u53d6\u5c0f\u65f6\u6570\"},\r\n    {name:\"MINUTE \u63d0\u53d6\u5206\u949f\", syntax:\"=MINUTE(\u65f6\u95f4)\", desc:\"\u4ece\u65f6\u95f4\u4e2d\u63d0\u53d6\u5206\u949f\u6570\"},\r\n    {name:\"SECOND \u63d0\u53d6\u79d2\u6570\", syntax:\"=SECOND(\u65f6\u95f4)\", desc:\"\u4ece\u65f6\u95f4\u4e2d\u63d0\u53d6\u79d2\u6570\"},\r\n    {name:\"ROUNDUP \u5411\u4e0a\u53d6\u6574\", syntax:\"=ROUNDUP(\u6570\u5b57,\u5c0f\u6570\u4f4d\u6570)\", desc:\"\u5411\u4e0a\u820d\u5165\u6570\u5b57\u5230\u6307\u5b9a\u4f4d\u6570\uff0c\u4e0d\u56db\u820d\u4e94\u5165\"},\r\n{name:\"ROUNDDOWN \u5411\u4e0b\u53d6\u6574\", syntax:\"=ROUNDDOWN(\u6570\u5b57,\u5c0f\u6570\u4f4d\u6570)\", desc:\"\u5411\u4e0b\u820d\u5165\u6570\u5b57\u5230\u6307\u5b9a\u4f4d\u6570\uff0c\u4e0d\u56db\u820d\u4e94\u5165\"},\r\n{name:\"CEILING \u5411\u4e0a\u820d\u5165\", syntax:\"=CEILING(\u6570\u5b57,\u57fa\u6570)\", desc:\"\u6309\u6307\u5b9a\u57fa\u6570\u5411\u4e0a\u820d\u5165\u6570\u5b57\"},\r\n{name:\"FLOOR \u5411\u4e0b\u820d\u5165\", syntax:\"=FLOOR(\u6570\u5b57,\u57fa\u6570)\", desc:\"\u6309\u6307\u5b9a\u57fa\u6570\u5411\u4e0b\u820d\u5165\u6570\u5b57\"},\r\n{name:\"POWER \u4e58\u5e42\u8fd0\u7b97\", syntax:\"=POWER(\u6570\u5b57,\u5e42\u6b21)\", desc:\"\u8ba1\u7b97\u6570\u5b57\u7684\u6307\u5b9a\u5e42\u6b21\u65b9\"},\r\n{name:\"SQRT \u5e73\u65b9\u6839\", syntax:\"=SQRT(\u6570\u5b57)\", desc:\"\u8ba1\u7b97\u6570\u5b57\u7684\u7b97\u672f\u5e73\u65b9\u6839\"},\r\n{name:\"ABS \u7edd\u5bf9\u503c\", syntax:\"=ABS(\u6570\u5b57)\", desc:\"\u8fd4\u56de\u6570\u5b57\u7684\u7edd\u5bf9\u503c\uff0c\u53bb\u9664\u8d1f\u53f7\"},\r\n{name:\"SIGN \u7b26\u53f7\u5224\u65ad\", syntax:\"=SIGN(\u6570\u5b57)\", desc:\"\u6b63\u6570\u8fd4\u56de1\uff0c\u8d1f\u6570\u8fd4\u56de-1\uff0c\u96f6\u8fd4\u56de0\"},\r\n{name:\"EVEN \u5076\u6570\u53d6\u6574\", syntax:\"=EVEN(\u6570\u5b57)\", desc:\"\u5c06\u6570\u5b57\u5411\u4e0a\u53d6\u6574\u4e3a\u6700\u63a5\u8fd1\u7684\u5076\u6570\"},\r\n{name:\"ODD \u5947\u6570\u53d6\u6574\", syntax:\"=ODD(\u6570\u5b57)\", desc:\"\u5c06\u6570\u5b57\u5411\u4e0a\u53d6\u6574\u4e3a\u6700\u63a5\u8fd1\u7684\u5947\u6570\"},\r\n{name:\"ISNUMBER \u5224\u65ad\u6570\u5b57\", syntax:\"=ISNUMBER(\u503c)\", desc:\"\u5224\u65ad\u5355\u5143\u683c\u5185\u5bb9\u662f\u5426\u4e3a\u6570\u5b57\uff0c\u8fd4\u56deTRUE\/FALSE\"},\r\n{name:\"ISTEXT \u5224\u65ad\u6587\u672c\", syntax:\"=ISTEXT(\u503c)\", desc:\"\u5224\u65ad\u5355\u5143\u683c\u5185\u5bb9\u662f\u5426\u4e3a\u6587\u672c\uff0c\u8fd4\u56deTRUE\/FALSE\"},\r\n{name:\"ISNONTEXT \u5224\u65ad\u975e\u6587\u672c\", syntax:\"=ISNONTEXT(\u503c)\", desc:\"\u5224\u65ad\u5355\u5143\u683c\u5185\u5bb9\u662f\u5426\u4e3a\u975e\u6587\u672c\uff0c\u8fd4\u56deTRUE\/FALSE\"},\r\n{name:\"ISERROR \u5224\u65ad\u9519\u8bef\", syntax:\"=ISERROR(\u503c)\", desc:\"\u5224\u65ad\u662f\u5426\u4e3a\u4efb\u610f\u9519\u8bef\u503c\uff0c\u8fd4\u56deTRUE\/FALSE\"},\r\n{name:\"ISNA \u5224\u65ad#N\/A\", syntax:\"=ISNA(\u503c)\", desc:\"\u4ec5\u5224\u65ad\u662f\u5426\u4e3a#N\/A\u9519\u8bef\u503c\uff0c\u8fd4\u56deTRUE\/FALSE\"},\r\n{name:\"NA \u9519\u8bef\u503c\", syntax:\"=NA()\", desc:\"\u76f4\u63a5\u751f\u6210#N\/A\u9519\u8bef\u503c\uff0c\u7528\u4e8e\u6807\u8bb0\u65e0\u6548\u6570\u636e\"},\r\n{name:\"VALUE \u6587\u672c\u8f6c\u6570\u5b57\", syntax:\"=VALUE(\u6587\u672c)\", desc:\"\u5c06\u6570\u5b57\u683c\u5f0f\u7684\u6587\u672c\u8f6c\u6362\u4e3a\u6570\u503c\u7c7b\u578b\"},\r\n{name:\"FIXED \u6570\u5b57\u683c\u5f0f\u5316\", syntax:\"=FIXED(\u6570\u5b57,\u5c0f\u6570\u4f4d\u6570)\", desc:\"\u5c06\u6570\u5b57\u683c\u5f0f\u5316\u4e3a\u5e26\u5c0f\u6570\u7684\u6587\u672c\u683c\u5f0f\"},\r\n{name:\"REPLACE \u66ff\u6362\u6587\u672c\", syntax:\"=REPLACE(\u6587\u672c,\u8d77\u59cb\u4f4d,\u957f\u5ea6,\u65b0\u6587\u672c)\", desc:\"\u6309\u4f4d\u7f6e\u66ff\u6362\u6307\u5b9a\u957f\u5ea6\u7684\u6587\u672c\"},\r\n{name:\"SUBSTITUTE \u6279\u91cf\u66ff\u6362\", syntax:\"=SUBSTITUTE(\u6587\u672c,\u65e7\u6587\u672c,\u65b0\u6587\u672c)\", desc:\"\u6279\u91cf\u66ff\u6362\u6587\u672c\u4e2d\u6307\u5b9a\u5185\u5bb9\"},\r\n{name:\"REPT \u91cd\u590d\u6587\u672c\", syntax:\"=REPT(\u6587\u672c,\u91cd\u590d\u6b21\u6570)\", desc:\"\u5c06\u6587\u672c\u91cd\u590d\u6307\u5b9a\u6b21\u6570\u751f\u6210\u65b0\u6587\u672c\"},\r\n{name:\"FIND \u67e5\u627e\u4f4d\u7f6e\", syntax:\"=FIND(\u67e5\u627e\u6587\u672c,\u6e90\u6587\u672c)\", desc:\"\u533a\u5206\u5927\u5c0f\u5199\u67e5\u627e\u5b57\u7b26\u4f4d\u7f6e\"},\r\n{name:\"SEARCH \u6a21\u7cca\u67e5\u627e\", syntax:\"=SEARCH(\u67e5\u627e\u6587\u672c,\u6e90Text)\", desc:\"\u4e0d\u533a\u5206\u5927\u5c0f\u5199\u67e5\u627e\u5b57\u7b26\u4f4d\u7f6e\"},\r\n{name:\"CHAR \u7f16\u7801\u8f6c\u5b57\u7b26\", syntax:\"=CHAR(\u6570\u5b57\u7f16\u7801)\", desc:\"\u6839\u636e\u5b57\u7b26\u7f16\u7801\u8fd4\u56de\u5bf9\u5e94\u6587\u672c\u5b57\u7b26\"},\r\n{name:\"CODE \u5b57\u7b26\u8f6c\u7f16\u7801\", syntax:\"=CODE(\u6587\u672c\u5b57\u7b26)\", desc:\"\u8fd4\u56de\u6587\u672c\u5b57\u7b26\u5bf9\u5e94\u7684\u6570\u5b57\u7f16\u7801\"},\r\n{name:\"EDATE \u6708\u4efd\u504f\u79fb\", syntax:\"=EDATE(\u65e5\u671f,\u6708\u4efd\u6570)\", desc:\"\u8fd4\u56de\u6307\u5b9a\u6708\u4efd\u504f\u79fb\u540e\u7684\u65e5\u671f\"},\r\n{name:\"EOMONTH \u6708\u672b\u65e5\u671f\", syntax:\"=EOMONTH(\u65e5\u671f,\u6708\u4efd\u6570)\", desc:\"\u8fd4\u56de\u6307\u5b9a\u6708\u4efd\u540e\u7684\u6700\u540e\u4e00\u5929\u65e5\u671f\"},\r\n{name:\"WORKDAY \u5de5\u4f5c\u65e5\", syntax:\"=WORKDAY(\u65e5\u671f,\u5929\u6570)\", desc:\"\u8ba1\u7b97\u6307\u5b9a\u5de5\u4f5c\u65e5\u540e\u7684\u65e5\u671f\"},\r\n{name:\"NETWORKDAYS \u5de5\u4f5c\u65e5\u5929\u6570\", syntax:\"=NETWORKDAYS(\u5f00\u59cb\u65e5,\u7ed3\u675f\u65e5)\", desc:\"\u8ba1\u7b97\u4e24\u4e2a\u65e5\u671f\u4e4b\u95f4\u7684\u5de5\u4f5c\u65e5\u6570\u91cf\"},\r\n{name:\"WEEKNUM \u5468\u6570\", syntax:\"=WEEKNUM(\u65e5\u671f)\", desc:\"\u8ba1\u7b97\u65e5\u671f\u5728\u4e00\u5e74\u4e2d\u7684\u5468\u6570\"},\r\n{name:\"ISOWEEKNUM ISO\u5468\u6570\", syntax:\"=ISOWEEKNUM(\u65e5\u671f)\", desc:\"\u6309ISO\u6807\u51c6\u8ba1\u7b97\u65e5\u671f\u7684\u5468\u6570\"},\r\n{name:\"TIME \u6784\u9020\u65f6\u95f4\", syntax:\"=TIME(\u5c0f\u65f6,\u5206\u949f,\u79d2)\", desc:\"\u6839\u636e\u65f6\u5206\u79d2\u751f\u6210\u65f6\u95f4\u503c\"},\r\n{name:\"TIMEVALUE \u6587\u672c\u8f6c\u65f6\u95f4\", syntax:\"=TIMEVALUE(\u65f6\u95f4\u6587\u672c)\", desc:\"\u5c06\u65f6\u95f4\u683c\u5f0f\u6587\u672c\u8f6c\u4e3a\u65f6\u95f4\u503c\"},\r\n{name:\"DATEVALUE \u6587\u672c\u8f6c\u65e5\u671f\", syntax:\"=DATEVALUE(\u65e5\u671f\u6587\u672c)\", desc:\"\u5c06\u65e5\u671f\u683c\u5f0f\u6587\u672c\u8f6c\u4e3a\u65e5\u671f\u503c\"}\r\n];\r\n\r\nfunction renderTable(list){\r\n    var html = '';\r\n    for(var i=0;i<list.length;i++){\r\n        html += '<tr>'+\r\n            '<td>'+list[i].name+'<\/td>'+\r\n            '<td>'+list[i].syntax+'<\/td>'+\r\n            '<td>'+list[i].desc+'<\/td>'+\r\n            '<td><button class=\"excel_copy_btn\" onclick=\"copySyntax(\\''+list[i].syntax+'\\')\">\u590d\u5236<\/button><\/td>'+\r\n        '<\/tr>';\r\n    }\r\n    document.getElementById('excelBody').innerHTML = html;\r\n}\r\n\r\nfunction copySyntax(str){\r\n    var input = document.createElement('input');\r\n    input.value = str;\r\n    document.body.appendChild(input);\r\n    input.select();\r\n    document.execCommand('copy');\r\n    document.body.removeChild(input);\r\n    var tip = document.getElementById('excelTip');\r\n    tip.style.display = 'block';\r\n    setTimeout(function(){tip.style.display='none';},1500);\r\n}\r\n\r\ndocument.getElementById('excelSearch').oninput = function(){\r\n    var key = this.value.toLowerCase();\r\n    var filterList = excelData.filter(function(item){\r\n        return item.name.toLowerCase().includes(key) || \r\n               item.syntax.toLowerCase().includes(key) || \r\n               item.desc.toLowerCase().includes(key);\r\n    });\r\n    renderTable(filterList);\r\n};\r\n\r\nrenderTable(excelData);\r\n<\/script>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Excel \u516c\u5f0f\u67e5\u8be2 \u6536\u96c6\u4e86\u4e00\u4e9b\u5e38\u7528\u7684\u516c\u5f0f \u516c\u5f0f\u540d\u79f0 \u516c\u5f0f\u8bed\u6cd5 \u529f\u80fd\u8bf4\u660e \u64cd\u4f5c \u590d\u5236\u6210\u529f<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":19,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"class_list":["post-504","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/pages\/504","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/comments?post=504"}],"version-history":[{"count":21,"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/pages\/504\/revisions"}],"predecessor-version":[{"id":690,"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/pages\/504\/revisions\/690"}],"up":[{"embeddable":true,"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/pages\/19"}],"wp:attachment":[{"href":"https:\/\/www.05621997.xyz\/index.php\/wp-json\/wp\/v2\/media?parent=504"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}