{"id":2807,"date":"2009-02-21T09:00:00","date_gmt":"2009-02-21T01:00:00","guid":{"rendered":"http:\/\/www.neolee.net\/?p=2807"},"modified":"2025-02-13T18:01:29","modified_gmt":"2025-02-13T10:01:29","slug":"data-excel-%e7%94%a8%e7%a8%8b%e5%ba%8f%e9%ab%98%e6%95%88%e5%88%b6%e8%a1%a8%ef%bc%88%e8%a4%87%e9%9b%9c%e6%b8%ac%e7%ae%97%e5%8f%8a%e8%aa%bf%e8%a9%a6%ef%bc%89","status":"publish","type":"post","link":"https:\/\/www.neolee.net\/?p=2807","title":{"rendered":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09"},"content":{"rendered":"\r\n<p class=\"wp-block-paragraph\">\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6\u8a2d\u7f6e\uff0c\u591a\u500b\u516c\u5f0f\u5f15\u7528\uff0c\u62c9\u8868\u8a08\u7b97\u662f\u4f4e\u7d1a\u904b\u7528\uff0c\u4e14\u6613\u51fa\u932f\uff0c\u6700\u9ad8\u6548\uff0c\u6700\u5b89\u5168\u7684\u8fa6\u6cd5\u5c31\u662f\u7528\u7a0b\u5e8f\u914d\u5408\u8a08\u7b97\uff0c\u9019\u662f\u6211\u5beb\u7684excel VB\u7a0b\u5e8f\u4ee3\u78bc\uff0c\u9644\u6e90\u78bc\uff0cexcel\u6587\u4ef6\u4e0d\u63d0\u4f9b\uff0c\u611f\u8208\u8da3\u7684\u81ea\u5df1\u5617\u8a66\uff0c\u4f46\u81f3\u5c11\u8981\u6703\u4f7f\u7528excel\u7684\u5b8f\u529f\u80fd\u3002<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"330\" class=\"wp-image-2808\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData-1024x330.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData-1024x330.jpg 1024w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData-300x97.jpg 300w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData-768x248.jpg 768w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData-1536x496.jpg 1536w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData.jpg 1683w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"671\" height=\"382\" class=\"wp-image-2809\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData02.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData02.jpg 671w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData02-300x171.jpg 300w\" sizes=\"auto, (max-width: 671px) 100vw, 671px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><!--more--><\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"231\" class=\"wp-image-2810\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData03-1024x231.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData03-1024x231.jpg 1024w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData03-300x68.jpg 300w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData03-768x173.jpg 768w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData03.jpg 1399w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"977\" height=\"569\" class=\"wp-image-2811\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData04.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData04.jpg 977w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData04-300x175.jpg 300w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData04-768x447.jpg 768w\" sizes=\"auto, (max-width: 977px) 100vw, 977px\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"822\" height=\"944\" class=\"wp-image-2812\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData05.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData05.jpg 822w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData05-261x300.jpg 261w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData05-768x882.jpg 768w\" sizes=\"auto, (max-width: 822px) 100vw, 822px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><textarea style=\"margin: 2px; padding: 2px; background-color: #ffffe1; border: 1px solid; font-size: 9pt;\" cols=\"60\" name=\"\" rows=\"10\">\r\nSub direction()\r\n\r\nDim temp\r\n\r\nFor i = 4 To 195\r\n\r\ntemp = Range(&#8220;f&#8221; &amp; i)\r\n\r\nSelect Case temp\r\n\r\nCase &#8220;A1&#8221;, &#8220;F1&#8221;, &#8220;A2&#8221;, &#8220;F2&#8221;, &#8220;G1&#8221;, &#8220;G2&#8221;\r\ntemp = &#8220;\u5317&#8221;\r\n\r\nCase &#8220;C1&#8221;\r\ntemp = &#8220;\u897f&#8221;\r\n\r\nCase &#8220;B2&#8221;, &#8220;E1&#8221;\r\ntemp = &#8220;\u897f\u5357&#8221;\r\n\r\nCase &#8220;B1&#8221;, &#8220;E2&#8221;\r\ntemp = &#8220;\u4e1c\u5357&#8221;\r\n\r\nCase &#8220;C2&#8221;\r\ntemp = &#8220;\u4e1c&#8221;\r\n\r\nCase &#8220;D1&#8221;, &#8220;D2&#8221;\r\ntemp = &#8220;\u5357&#8221;\r\nEnd Select\r\n\r\n\r\n\r\nRange(&#8220;J&#8221; &amp; i) = temp\r\n\r\nRange(&#8220;M&#8221; &amp; i) = DirectionPrice(temp)\r\n\r\nNext\r\n\r\nEnd Sub\r\nSub FloorPrice()\r\nDim SFloor, EFloor, MFloor, PFloor, pricetemp\r\n\r\nMFloor = 7\r\n\r\nFor i = 4 To 195\r\n\r\nPFloor = CLng(Range(&#8220;C&#8221; &amp; i))\r\n\r\nSelect Case PFloor\r\n\r\n    Case (PFloor = MFloor)\r\n\r\n        pricetemp = 0\r\n    Case Else\r\n\r\n        pricetemp = (PFloor &#8211; MFloor) * 30\r\n\r\nEnd Select\r\n\r\nIf PFloor = 4 Then pricetemp = pricetemp &#8211; 20 &#8216;4\u697c\u8c03\u6574\u548c3\u697c\u4e00\u6837\r\n\r\nIf PFloor &gt; MFloor + 1 Then pricetemp = pricetemp + 20 &#8216;8\u697c\u4ee5\u4e0a\u4ef7\u683c\u5fae\u8c03\r\n\r\nIf PFloor = 13 Then pricetemp = pricetemp &#8211; 20 &#8216;\u9876\u697c\u4ef7\u683c\u5fae\u8c03\r\n\r\nRange(&#8220;L&#8221; &amp; i) = pricetemp\r\n\r\n\r\nNext\r\n\r\n\r\nEnd Sub\r\nSub ResidencePrice()\r\nDim pResidence, pricetemp\r\n\r\nFor i = 4 To 195\r\n\r\npResidence = Range(&#8220;F&#8221; &amp; i)\r\n\r\nSelect Case pResidence\r\n\r\n    Case &#8220;D1&#8221;, &#8220;D2&#8221;\r\n\r\n        pricetemp = 1.1\r\n    Case &#8220;C1&#8221;, &#8220;C2&#8221;\r\n        pricetemp = 0.95\r\n    Case &#8220;E1&#8221;, &#8220;E2&#8221;\r\n        pricetemp = 1.05\r\n        Case &#8220;B1&#8221;, &#8220;B2&#8221;\r\n        pricetemp = 1.025\r\n    Case Else\r\n        pricetemp = 1\r\n\r\nEnd Select\r\n\r\n\r\nRange(&#8220;K&#8221; &amp; i) = pricetemp\r\n\r\n\r\nNext\r\nEnd Sub\r\n\r\nSub JGPrice()\r\nDim pBuiding, pResidence, pricetemp\r\n\r\n\r\n\r\nFor i = 4 To 195\r\n\r\npBuiding = Range(&#8220;B&#8221; &amp; i)\r\n\r\npResidence = Range(&#8220;F&#8221; &amp; i)\r\n\r\n\r\nIf pBuiding = &#8220;A&#8221; Then\r\n\r\nSelect Case pResidence\r\n\r\n    Case &#8220;F1&#8221;, &#8220;C1&#8221;, &#8220;E1&#8221;\r\n\r\n        pricetemp = 98.85\r\n   Case &#8220;D1&#8221;\r\n   \r\n       pricetemp = 65\r\n       \r\n    Case Else\r\n\r\n        pricetemp = 0\r\n\r\nEnd Select\r\nEnd If\r\n\r\nIf pBuiding = &#8220;B&#8221; Then\r\n\r\nSelect Case pResidence\r\n\r\n    Case &#8220;F2&#8221;, &#8220;E2&#8221;, &#8220;C2&#8221;\r\n\r\n        pricetemp = 98.85\r\n        \r\n     Case &#8220;D2&#8221;\r\n   \r\n       pricetemp = 65\r\n    Case Else\r\n\r\n        pricetemp = 0\r\n\r\nEnd Select\r\nEnd If\r\n\r\n\r\nRange(&#8220;N&#8221; &amp; i) = pricetemp\r\n\r\n\r\nNext\r\nEnd Sub\r\n\r\n\r\nFunction DirectionPrice(direction)\r\n\r\nDim pricetemp\r\n\r\nSelect Case direction\r\n\r\nCase &#8220;\u5317&#8221;\r\npricetemp = 0\r\n\r\nCase &#8220;\u4e1c\u5317&#8221;, &#8220;\u897f\u5317&#8221;\r\npricetemp = 25\r\n\r\nCase &#8220;\u4e1c&#8221;, &#8220;\u897f&#8221;\r\npricetemp = 50\r\n\r\nCase &#8220;\u897f\u5357&#8221;, &#8220;\u4e1c\u5357&#8221;\r\npricetemp = 75\r\n\r\nCase &#8220;\u5357&#8221;\r\npricetemp = 100\r\n\r\nEnd Select\r\n\r\nDirectionPrice = pricetemp\r\n\r\nEnd Function\r\n\r\n\r\nSub find2()\r\nCall findcancel\r\nDim floor, rownum\r\n\r\nFor i = 4 To 195\r\nfloor = Range(&#8220;C&#8221; &amp; i)\r\nIf (floor Mod 2 = 1) Then\r\n\r\n\r\nRows(i).EntireRow.Hidden = True\r\n\r\nEnd If\r\n\r\nNext\r\nEnd Sub\r\nSub find1()\r\nCall findcancel\r\nDim floor\r\n\r\nFor i = 4 To 195\r\nfloor = Range(&#8220;C&#8221; &amp; i)\r\nIf (floor Mod 2 = 0) Then\r\n\r\n\r\nRows(i).EntireRow.Hidden = True\r\n\r\n\r\nEnd If\r\n\r\nNext\r\nEnd Sub\r\nSub findcancel()\r\n\r\nRows(&#8220;4:195&#8221;).EntireRow.Hidden = False\r\n\r\n\r\nEnd Sub\r\n\r\n\r\n\r\n<\/textarea> <br \/><br \/><textarea style=\"margin: 2px; padding: 2px; background-color: #ffffe1; border: 1px solid; font-size: 9pt;\" cols=\"60\" name=\"\" rows=\"10\">Sub Hide()\r\n&#8216;\r\n&#8216; Hide Macro\r\n&#8216; \u5b8f\u7531 ELooNG \u5f55\u5236\uff0c\u65f6\u95f4: 2009-2-21\r\n&#8216;\r\n\r\n&#8216;\r\n    Range(&#8220;AL:AL,AN:AN,AP:AP,AR:AR,AT:AT,AV:AV,AX:AX,AZ:AZ&#8221;).Select\r\n    Selection.EntireColumn.Hidden = True\r\n    Range(&#8220;aj239&#8221;).Select\r\nEnd Sub\r\n\r\nSub View()\r\n\r\n    Columns(&#8220;AJ:BA&#8221;).Select\r\n    Selection.EntireColumn.Hidden = False\r\n    Range(&#8220;aj239&#8221;).Select\r\nEnd Sub\r\n\r\n\r\n\r\n<\/textarea><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6\u8a2d\u7f6e\uff0c\u591a\u500b\u516c\u5f0f\u5f15\u7528\uff0c\u62c9\u8868\u8a08\u7b97\u662f\u4f4e\u7d1a\u904b\u7528\uff0c\u4e14\u6613\u51fa\u932f\uff0c\u6700\u9ad8\u6548\uff0c\u6700\u5b89\u5168\u7684\u8fa6\u6cd5\u5c31\u662f\u7528\u7a0b\u5e8f\u914d\u5408\u8a08\u7b97\uff0c\u9019\u662f\u6211\u5beb\u7684excel VB\u7a0b\u5e8f\u4ee3\u78bc\uff0c\u9644\u6e90\u78bc\uff0cexcel\u6587\u4ef6\u4e0d\u63d0\u4f9b\uff0c\u611f\u8208\u8da3\u7684\u81ea\u5df1\u5617\u8a66\uff0c\u4f46\u81f3\u5c11\u8981\u6703\u4f7f\u7528excel\u7684\u5b8f\u529f\u80fd\u3002<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[18,16],"tags":[],"class_list":["post-2807","post","type-post","status-publish","format-standard","hentry","category-property","category-cyberworld"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO Pro 5.0.0.1 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6 - https:\/\/www.neolee.net\/?p=2807\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"\u5955\u9f8d\u541b\"\/>\n\t<meta name=\"google-site-verification\" content=\"QrYuYqRyVtPrhT07pi0a7iw3jQ9Nco676cwZp11jx14\" \/>\n\t<link rel=\"canonical\" href=\"https:\/\/www.neolee.net\/?p=2807\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO Pro (AIOSEO) 5.0.0.1\" \/>\n\t\t<meta property=\"og:locale\" content=\"zh_HK\" \/>\n\t\t<meta property=\"og:site_name\" content=\"\u5955\u95a3 - \u4e00\u58fa\u6fc1\u9152\u559c\u76f8\u9022 www.neolee.net\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee\" \/>\n\t\t<meta property=\"og:description\" content=\"\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6 - https:\/\/www.neolee.net\/?p=2807\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.neolee.net\/?p=2807\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2023\/02\/cropped-cropped-IMG_0694-scaled-7.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2023\/02\/cropped-cropped-IMG_0694-scaled-7.jpg\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2009-02-21T01:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-02-13T10:01:29+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/facebook.com\/neoleetok\" \/>\n\t\t<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n\t\t<meta name=\"twitter:site\" content=\"@neoleetok\" \/>\n\t\t<meta name=\"twitter:title\" content=\"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6 - https:\/\/www.neolee.net\/?p=2807\" \/>\n\t\t<meta name=\"twitter:creator\" content=\"@neoleetok\" \/>\n\t\t<meta name=\"twitter:image\" content=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2023\/02\/cropped-cropped-IMG_0694-scaled-7.jpg\" \/>\n\t\t<script type=\"application\/ld+json\" class=\"aioseo-schema\">\n\t\t\t{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"BlogPosting\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807#blogposting\",\"name\":\"Excel \\u7528\\u7a0b\\u5e8f\\u9ad8\\u6548\\u5236\\u8868\\uff08\\u8907\\u96dc\\u6e2c\\u7b97\\u53ca\\u8abf\\u8a66\\uff09 - \\u5955\\u95a3 - \\u5955\\u9f8d\\u541b - neolee\",\"headline\":\"Excel \\u7528\\u7a0b\\u5e8f\\u9ad8\\u6548\\u5236\\u8868\\uff08\\u8907\\u96dc\\u6e2c\\u7b97\\u53ca\\u8abf\\u8a66\\uff09\",\"author\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"http:\\\/\\\/www.neolee.net\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/MakingPriceData-1024x330.jpg\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807\\\/#articleImage\"},\"datePublished\":\"2009-02-21T09:00:00+08:00\",\"dateModified\":\"2025-02-13T18:01:29+08:00\",\"inLanguage\":\"zh-HK\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807#webpage\"},\"articleSection\":\"\\u5730\\u7522, \\u96fb\\u8166\\u7db2\\u7d61\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807#breadcrumblist\",\"itemListElement\":[{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net#listItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.neolee.net\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?cat=2#listItem\",\"name\":\"\\u6709\\u5f08\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?cat=2#listItem\",\"position\":2,\"name\":\"\\u6709\\u5f08\",\"item\":\"https:\\\/\\\/www.neolee.net\\\/?cat=2\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?cat=16#listItem\",\"name\":\"\\u96fb\\u8166\\u7db2\\u7d61\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net#listItem\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?cat=16#listItem\",\"position\":3,\"name\":\"\\u96fb\\u8166\\u7db2\\u7d61\",\"item\":\"https:\\\/\\\/www.neolee.net\\\/?cat=16\",\"nextItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807#listItem\",\"name\":\"Excel \\u7528\\u7a0b\\u5e8f\\u9ad8\\u6548\\u5236\\u8868\\uff08\\u8907\\u96dc\\u6e2c\\u7b97\\u53ca\\u8abf\\u8a66\\uff09\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?cat=2#listItem\",\"name\":\"\\u6709\\u5f08\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807#listItem\",\"position\":4,\"name\":\"Excel \\u7528\\u7a0b\\u5e8f\\u9ad8\\u6548\\u5236\\u8868\\uff08\\u8907\\u96dc\\u6e2c\\u7b97\\u53ca\\u8abf\\u8a66\\uff09\",\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?cat=16#listItem\",\"name\":\"\\u96fb\\u8166\\u7db2\\u7d61\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/#person\",\"name\":\"\\u5955\\u9f8d\\u541b\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?author=2#author\",\"url\":\"https:\\\/\\\/www.neolee.net\\\/?author=2\",\"name\":\"\\u5955\\u9f8d\\u541b\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807#webpage\",\"url\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807\",\"name\":\"Excel \\u7528\\u7a0b\\u5e8f\\u9ad8\\u6548\\u5236\\u8868\\uff08\\u8907\\u96dc\\u6e2c\\u7b97\\u53ca\\u8abf\\u8a66\\uff09 - \\u5955\\u95a3 - \\u5955\\u9f8d\\u541b - neolee\",\"description\":\"\\u5728\\u5236\\u5b9a\\u50f9\\u8868\\uff08\\u5305\\u62ec\\u6295\\u8cc7\\u8868\\uff09\\u904e\\u7a0b\\u4e2d\\u9700\\u8981\\u8907\\u96dc\\u8a08\\u7b97\\u4ee5\\u53ca\\u4e0d\\u65b7\\u8abf\\u6574\\u8a08\\u7b97\\u7d50\\u679c\\uff0c\\u4ee5\\u671f\\u9054\\u5230\\u6700\\u4f73\\u6548\\u679c\\uff0c\\u9762\\u5c0d\\u6210\\u5343\\u4e0a\\u842c\\u500b\\u6578\\u5b57\\uff0c\\u591a\\u500b\\u689d\\u4ef6 - https:\\\/\\\/www.neolee.net\\\/?p=2807\",\"inLanguage\":\"zh-HK\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2807#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?author=2#author\"},\"datePublished\":\"2009-02-21T09:00:00+08:00\",\"dateModified\":\"2025-02-13T18:01:29+08:00\"},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/#website\",\"url\":\"https:\\\/\\\/www.neolee.net\\\/\",\"name\":\"\\u5955\\u95a3\",\"description\":\"\\u4e00\\u58fa\\u6fc1\\u9152\\u559c\\u76f8\\u9022 www.neolee.net\",\"inLanguage\":\"zh-HK\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/#person\"}}]}\n\t\t<\/script>\n\t\t<!-- All in One SEO Pro -->\r\n\t\t<title>Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee<\/title>\n\n","aioseo_head_json":{"title":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","description":"\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6 - https:\/\/www.neolee.net\/?p=2807","canonical_url":"https:\/\/www.neolee.net\/?p=2807","robots":"max-image-preview:large","keywords":"","webmasterTools":{"google-site-verification":"QrYuYqRyVtPrhT07pi0a7iw3jQ9Nco676cwZp11jx14","miscellaneous":""},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"BlogPosting","@id":"https:\/\/www.neolee.net\/?p=2807#blogposting","name":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","headline":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09","author":{"@id":"https:\/\/www.neolee.net\/?author=2#author"},"publisher":{"@id":"https:\/\/www.neolee.net\/#person"},"image":{"@type":"ImageObject","url":"http:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/MakingPriceData-1024x330.jpg","@id":"https:\/\/www.neolee.net\/?p=2807\/#articleImage"},"datePublished":"2009-02-21T09:00:00+08:00","dateModified":"2025-02-13T18:01:29+08:00","inLanguage":"zh-HK","mainEntityOfPage":{"@id":"https:\/\/www.neolee.net\/?p=2807#webpage"},"isPartOf":{"@id":"https:\/\/www.neolee.net\/?p=2807#webpage"},"articleSection":"\u5730\u7522, \u96fb\u8166\u7db2\u7d61"},{"@type":"BreadcrumbList","@id":"https:\/\/www.neolee.net\/?p=2807#breadcrumblist","itemListElement":[{"@type":"ListItem","@id":"https:\/\/www.neolee.net#listItem","position":1,"name":"Home","item":"https:\/\/www.neolee.net","nextItem":{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?cat=2#listItem","name":"\u6709\u5f08"}},{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?cat=2#listItem","position":2,"name":"\u6709\u5f08","item":"https:\/\/www.neolee.net\/?cat=2","nextItem":{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?cat=16#listItem","name":"\u96fb\u8166\u7db2\u7d61"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.neolee.net#listItem","name":"Home"}},{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?cat=16#listItem","position":3,"name":"\u96fb\u8166\u7db2\u7d61","item":"https:\/\/www.neolee.net\/?cat=16","nextItem":{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?p=2807#listItem","name":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?cat=2#listItem","name":"\u6709\u5f08"}},{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?p=2807#listItem","position":4,"name":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09","previousItem":{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?cat=16#listItem","name":"\u96fb\u8166\u7db2\u7d61"}}]},{"@type":"Person","@id":"https:\/\/www.neolee.net\/#person","name":"\u5955\u9f8d\u541b"},{"@type":"Person","@id":"https:\/\/www.neolee.net\/?author=2#author","url":"https:\/\/www.neolee.net\/?author=2","name":"\u5955\u9f8d\u541b"},{"@type":"WebPage","@id":"https:\/\/www.neolee.net\/?p=2807#webpage","url":"https:\/\/www.neolee.net\/?p=2807","name":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","description":"\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6 - https:\/\/www.neolee.net\/?p=2807","inLanguage":"zh-HK","isPartOf":{"@id":"https:\/\/www.neolee.net\/#website"},"breadcrumb":{"@id":"https:\/\/www.neolee.net\/?p=2807#breadcrumblist"},"author":{"@id":"https:\/\/www.neolee.net\/?author=2#author"},"creator":{"@id":"https:\/\/www.neolee.net\/?author=2#author"},"datePublished":"2009-02-21T09:00:00+08:00","dateModified":"2025-02-13T18:01:29+08:00"},{"@type":"WebSite","@id":"https:\/\/www.neolee.net\/#website","url":"https:\/\/www.neolee.net\/","name":"\u5955\u95a3","description":"\u4e00\u58fa\u6fc1\u9152\u559c\u76f8\u9022 www.neolee.net","inLanguage":"zh-HK","publisher":{"@id":"https:\/\/www.neolee.net\/#person"}}]},"og:locale":"zh_HK","og:site_name":"\u5955\u95a3 - \u4e00\u58fa\u6fc1\u9152\u559c\u76f8\u9022 www.neolee.net","og:type":"article","og:title":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","og:description":"\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6 - https:\/\/www.neolee.net\/?p=2807","og:url":"https:\/\/www.neolee.net\/?p=2807","og:image":"https:\/\/www.neolee.net\/wp-content\/uploads\/2023\/02\/cropped-cropped-IMG_0694-scaled-7.jpg","og:image:secure_url":"https:\/\/www.neolee.net\/wp-content\/uploads\/2023\/02\/cropped-cropped-IMG_0694-scaled-7.jpg","article:published_time":"2009-02-21T01:00:00+00:00","article:modified_time":"2025-02-13T10:01:29+00:00","article:publisher":"https:\/\/facebook.com\/neoleetok","twitter:card":"summary_large_image","twitter:site":"@neoleetok","twitter:title":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","twitter:description":"\u5728\u5236\u5b9a\u50f9\u8868\uff08\u5305\u62ec\u6295\u8cc7\u8868\uff09\u904e\u7a0b\u4e2d\u9700\u8981\u8907\u96dc\u8a08\u7b97\u4ee5\u53ca\u4e0d\u65b7\u8abf\u6574\u8a08\u7b97\u7d50\u679c\uff0c\u4ee5\u671f\u9054\u5230\u6700\u4f73\u6548\u679c\uff0c\u9762\u5c0d\u6210\u5343\u4e0a\u842c\u500b\u6578\u5b57\uff0c\u591a\u500b\u689d\u4ef6 - https:\/\/www.neolee.net\/?p=2807","twitter:creator":"@neoleetok","twitter:image":"https:\/\/www.neolee.net\/wp-content\/uploads\/2023\/02\/cropped-cropped-IMG_0694-scaled-7.jpg"},"aioseo_meta_data":{"post_id":"2807","title":null,"description":null,"keywords":null,"keyphrases":{"focus":{"keyphrase":"\u8ba1\u7b97\u673a","score":34,"analysis":{"keyphraseInTitle":{"score":3,"maxScore":9,"error":1},"keyphraseInDescription":{"score":3,"maxScore":9,"error":1},"keyphraseLength":{"score":-999,"maxScore":9,"error":1,"length":0},"keyphraseInURL":{"score":5,"maxScore":5,"error":0},"keyphraseInIntroduction":{"score":3,"maxScore":9,"error":1},"keyphraseInSubHeadings":[],"keyphraseInImageAlt":{"score":3,"maxScore":9,"error":1},"keywordDensity":{"score":0,"type":"low","maxScore":9,"error":1}}},"additional":[{"keyphrase":"\u8868\u683c","score":25,"analysis":{"keyphraseInDescription":{"score":3,"maxScore":9,"error":1},"keyphraseLength":{"score":-999,"maxScore":9,"error":1,"length":0},"keyphraseInIntroduction":{"score":3,"maxScore":9,"error":1},"keyphraseInImageAlt":{"score":3,"maxScore":9,"error":1},"keywordDensity":{"score":0,"type":"low","maxScore":9,"error":1}}},{"keyphrase":"\u5b8f","score":50,"analysis":{"keyphraseInDescription":{"score":3,"maxScore":9,"error":1},"keyphraseLength":{"score":-999,"maxScore":9,"error":1,"length":0},"keyphraseInIntroduction":{"score":3,"maxScore":9,"error":1},"keyphraseInImageAlt":{"score":3,"maxScore":9,"error":1},"keywordDensity":{"type":"best","score":9,"maxScore":9,"error":0}}},{"keyphrase":"vbscript","score":40,"analysis":{"keyphraseInDescription":{"score":3,"maxScore":9,"error":1},"keyphraseLength":{"score":9,"maxScore":9,"error":0,"length":1},"keyphraseInIntroduction":{"score":3,"maxScore":9,"error":1},"keyphraseInImageAlt":{"score":3,"maxScore":9,"error":1},"keywordDensity":{"score":0,"type":"low","maxScore":9,"error":1}}}]},"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":"","og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"BlogPosting","isEnabled":true},"graphs":[]},"schema_type":"default","schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":"-1","robots_max_videopreview":"-1","robots_max_imagepreview":"large","priority":null,"frequency":"default","local_seo":null,"seo_analyzer_scan_date":"2026-05-30 16:52:41","breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"open_ai":"{\"title\":{\"suggestions\":[],\"usage\":0},\"description\":{\"suggestions\":[],\"usage\":0}}","ai":null,"created":"2024-02-20 04:13:01","updated":"2026-05-30 16:52:41","focus_keyword":"\u8ba1\u7b97\u673a","additional_keywords":[{"word":"\u8868\u683c","score":25},{"word":"\u5b8f","score":50},{"word":"vbscript","score":40}],"truseo_locale":null},"aioseo_breadcrumb":"<div class=\"aioseo-breadcrumbs\"><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/www.neolee.net\" title=\"Home\">Home<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/www.neolee.net\/?cat=2\" title=\"\u6709\u5f08\">\u6709\u5f08<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\t<a href=\"https:\/\/www.neolee.net\/?cat=16\" title=\"\u96fb\u8166\u7db2\u7d61\">\u96fb\u8166\u7db2\u7d61<\/a>\n<\/span><span class=\"aioseo-breadcrumb-separator\">\u00bb<\/span><span class=\"aioseo-breadcrumb\">\n\tExcel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09\n<\/span><\/div>","aioseo_breadcrumb_json":[{"label":"Home","link":"https:\/\/www.neolee.net"},{"label":"\u6709\u5f08","link":"https:\/\/www.neolee.net\/?cat=2"},{"label":"\u96fb\u8166\u7db2\u7d61","link":"https:\/\/www.neolee.net\/?cat=16"},{"label":"Excel \u7528\u7a0b\u5e8f\u9ad8\u6548\u5236\u8868\uff08\u8907\u96dc\u6e2c\u7b97\u53ca\u8abf\u8a66\uff09","link":"https:\/\/www.neolee.net\/?p=2807"}],"_links":{"self":[{"href":"https:\/\/www.neolee.net\/index.php?rest_route=\/wp\/v2\/posts\/2807","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.neolee.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.neolee.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.neolee.net\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.neolee.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2807"}],"version-history":[{"count":0,"href":"https:\/\/www.neolee.net\/index.php?rest_route=\/wp\/v2\/posts\/2807\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.neolee.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2807"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.neolee.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2807"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.neolee.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2807"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}