{"id":2674,"date":"2012-06-01T09:00:00","date_gmt":"2012-06-01T01:00:00","guid":{"rendered":"http:\/\/www.neolee.net\/?p=2674"},"modified":"2025-02-12T13:23:39","modified_gmt":"2025-02-12T05:23:39","slug":"data-excel%e5%a4%96%e8%aa%bf%e6%95%b8%e6%93%9a%e5%ba%ab-%e7%94%9f%e6%88%90%e9%80%8f%e8%a6%96%e8%a1%a8","status":"publish","type":"post","link":"https:\/\/www.neolee.net\/?p=2674","title":{"rendered":"Excel DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868"},"content":{"rendered":"\r\n<p class=\"wp-block-paragraph\">\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf\u7528\u6578\u64da\uff0c\u9019\u6a23\u5373\u5b89\u5168\u53c8\u65b9\u4fbf\uff0c\u65bc\u662f\u505a\u4e86\u793a\u8303\u7d66\u4ed6\u5011\u5b78\u7fd2\uff0c\u53ef\u662f\u767c\u73fe\u4f3c\u4e4e\u5c0d\u65bc\u5927\u591a\u6578\u8fa6\u516c\u4eba\u54e1\u4f86\u8aaa\u5f88\u8907\u96dc\uff0c\u6559\u7d2f\u5b78\u7d2f\uff0c\u68c4\u4e4b\uff0c\u5f80\u5f8c\u4e5f\u6c92\u6709\u6559\u4ed6\u5011\u5b78\u7fd2\u3002\u56e0\u70ba\u539f\u59cb\u6578\u64da\u76f8\u5c0d\u771f\u5be6\uff0c\u9084\u5728\u4f7f\u7528\u4e2d\uff0c\u70ba\u514d\u9ebb\u7169\uff0c\u6240\u4ee5\u5c31\u653e\u4e0a\u5716\u7247\u4e86\uff0c\u611f\u8208\u8da3\u7684\u53ef\u4ee5\u770b\u6e90\u4ee3\u78bc\u81ea\u5df1\u5beb\u4e86\u6e2c\u8a66\u3002<\/p>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"790\" height=\"483\" class=\"wp-image-2678\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest04.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest04.jpg 790w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest04-300x183.jpg 300w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest04-768x470.jpg 768w\" sizes=\"auto, (max-width: 790px) 100vw, 790px\" \/><\/figure>\r\n\r\n\r\n\r\n<div class=\"wp-block-image\">\r\n<figure class=\"aligncenter size-large\"><img loading=\"lazy\" decoding=\"async\" width=\"391\" height=\"159\" class=\"wp-image-2681\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest07-e1595296803572.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest07-e1595296803572.jpg 391w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest07-e1595296803572-300x122.jpg 300w\" sizes=\"auto, (max-width: 391px) 100vw, 391px\" \/><\/figure>\r\n<\/div>\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=\"603\" height=\"1024\" class=\"wp-image-2675\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest01-603x1024.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest01-603x1024.jpg 603w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest01-177x300.jpg 177w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest01.jpg 764w\" sizes=\"auto, (max-width: 603px) 100vw, 603px\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"450\" height=\"1024\" class=\"wp-image-2676\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest02-450x1024.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest02-450x1024.jpg 450w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest02-132x300.jpg 132w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest02.jpg 709w\" sizes=\"auto, (max-width: 450px) 100vw, 450px\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"666\" height=\"473\" class=\"wp-image-2677\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest03.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest03.jpg 666w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest03-300x213.jpg 300w\" sizes=\"auto, (max-width: 666px) 100vw, 666px\" \/><\/figure>\r\n\r\n\r\n\r\n<figure class=\"wp-block-image\"><img loading=\"lazy\" decoding=\"async\" width=\"1024\" height=\"678\" class=\"wp-image-2679\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest05-1024x678.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest05-1024x678.jpg 1024w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest05-300x199.jpg 300w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest05-768x508.jpg 768w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest05.jpg 1213w\" 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=\"1024\" height=\"404\" class=\"wp-image-2680\" src=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest06-1024x404.jpg\" alt=\"\" srcset=\"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest06-1024x404.jpg 1024w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest06-300x119.jpg 300w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest06-768x303.jpg 768w, https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest06.jpg 1324w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/figure>\r\n\r\n\r\n\r\n<p><textarea style=\"margin: 2px; padding: 2px; background-color: #ffffe1; border: 1px solid;\" cols=\"60\" name=\"\" rows=\"30\">Private Sub Workbook_Open()\r\n\r\n\r\n    Dim strCon As String, iPath As String, i As Integer, iStr As String, iFile As String    &#8216;\u5b9a\u4e49\u53d8\u91cf\r\n   &#8216; On Error Resume Next\r\n  \r\n    iPath = ThisWorkbook.Path            &#8216;\u83b7\u53d6\u8def\u5f84\r\n    iFile = iPath + &#8220;\\VIMTHData.dat&#8221;\r\n  \r\n  With ActiveWorkbook.Connections(&#8220;VIMTHDatabase ODBC&#8221;).ODBCConnection\r\n        .BackgroundQuery = True\r\n        .CommandText = Array( _\r\n        &#8220;SELECT * FROM `&#8221; + iFile + &#8220;`.`\u623f\u6e90\u603b\u8868`&#8221; _\r\n        )\r\n        .CommandType = xlCmdSql\r\n        .Connection = Array(Array( _\r\n        &#8220;ODBC;DSN=MS Access Database;DBQ=&#8221; + iFile + &#8220;;DefaultDir=&#8221; + iPath + &#8220;;&#8221; _\r\n        ), Array( _\r\n        &#8220;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;&#8221; _\r\n        ))\r\n        .RefreshOnFileOpen = False\r\n        .SavePassword = False\r\n        .SourceConnectionFile = &#8220;&#8221;\r\n        .SourceDataFile = &#8220;&#8221;\r\n        .ServerCredentialsMethod = xlCredentialsMethodIntegrated\r\n        .AlwaysUseConnectionFile = False\r\n    End With\r\n    &#8216;ActiveWorkbook.Connections(&#8220;VIMTHDatabase ODBC&#8221;).Refresh\r\n   tb = MsgBox(&#8220;Welcome to VIM ODBC DataBase!&#8221; + vbNewLine + vbNewLine + &#8221;  Ver 0.1 2012 June ELooNG &#8220;, 0 + 64, &#8220;VIM&#8221;)\r\n&#8216;Application.Visible = True\r\nEnd Sub\r\n\r\nSub StartData()\r\n    Dim strCon As String, iPath As String, i As Integer, iStr As String, iFile As String    &#8216;\u5b9a\u4e49\u53d8\u91cf\r\n   &#8216; On Error Resume Next\r\n  \r\n    iPath = ThisWorkbook.Path            &#8216;\u83b7\u53d6\u8def\u5f84\r\n    iFile = iPath + &#8220;\\VIMTHData.dat&#8221;\r\nWith ActiveSheet.ListObjects.Add(SourceType:=0, Source:=Array(Array( _\r\n        &#8220;ODBC;DSN=MS Access Database;DBQ=&#8221; + iFile + &#8220;;DefaultDir=&#8221; + iPath + &#8220;;&#8221; _\r\n        ), Array( _\r\n        &#8220;DriverId=25;FIL=MS Access;MaxBufferSize=2048;PageTimeout=5;&#8221; _\r\n        )), Destination:=Range(&#8220;$A$1&#8221;)).QueryTable\r\n        .CommandText = Array( _\r\n        &#8220;SELECT * FROM `&#8221; + iFile + &#8220;`.`\u623f\u6e90\u603b\u8868`&#8221; _\r\n        )\r\n        .RowNumbers = False\r\n        .FillAdjacentFormulas = False\r\n        .PreserveFormatting = True\r\n        .RefreshOnFileOpen = False\r\n        .BackgroundQuery = True\r\n        .RefreshStyle = xlInsertDeleteCells\r\n        .SavePassword = False\r\n        .SaveData = True\r\n        .AdjustColumnWidth = True\r\n        .RefreshPeriod = 0\r\n        .PreserveColumnInfo = True\r\n        .SourceConnectionFile = _\r\n        .ListObject.DisplayName = &#8220;\u8868_THDatabase_ODBC&#8221;\r\n        .Refresh BackgroundQuery:=False\r\n   End With\r\nEnd Sub\r\n<\/textarea> <br \/><br \/><textarea style=\"margin: 2px; padding: 2px; background-color: #ffffe1; border: 1px solid;\" cols=\"60\" name=\"\" rows=\"30\">Sub \u6309\u94ae1_Click()\r\n\r\n\r\nDim PWD\r\nPWD = CPSWD(&#8220;ViMeGa&#8221;)\r\nSheets(&#8220;Sheet1&#8221;).Visible = 2\r\nSheets(&#8220;Sheet1&#8221;).Unprotect Password:=PWD\r\n\r\n\r\n   &#8216; With Selection.ListObject.QueryTable\r\n\r\n&#8216;    End With\r\n\r\n\r\nWith ActiveWorkbook.Connections(&#8220;VIMTHDatabase ODBC&#8221;)\r\n.ODBCConnection.BackgroundQuery = False\r\n.Refresh\r\nEnd With\r\n\r\n\r\nmb = MsgBox(&#8220;VIM\u6570\u636e\u66f4\u65b0\u5b8c\u6210\uff01&#8221;, 64 + 0)\r\n\r\n\r\n\r\n&#8216;ActiveWorkbook.Connections(&#8220;VIMTHDatabase ODBC&#8221;).Refresh\r\n&#8216;ActiveWorkbook.RefreshAll\r\n\r\n\r\nSheets(&#8220;Sheet1&#8221;).Protect AllowUsingPivotTables:=True, Password:=PWD\r\n\r\nEnd Sub\r\n\r\n\r\nSub NewPivoTable()\r\n&#8216;\r\nDim SH, SN, PN\r\n&#8216;\r\n\r\nSheets.Add After:=Sheets(Sheets.Count)\r\n\r\n\r\nSN = Sheets(Sheets.Count).Name\r\nPN = &#8220;\u6570\u636e\u900f\u89c6\u8868&#8221; &amp; SN\r\nSN = SN + &#8220;!R3C2&#8221;\r\n\r\n\r\n    MsgBox (SN + PN)\r\n        \r\n    \r\n    ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _\r\n        &#8220;\u8868_VIMTHData.mdb_\u623f\u6e90\u603b\u8868&#8221;, Version:=xlPivotTableVersion12).CreatePivotTable _\r\n        TableDestination:=SN, TableName:=PN, DefaultVersion:= _\r\n        xlPivotTableVersion12\r\n   &#8216; Sheets(&#8220;Sheet&#8221; + &#8220;SheetsCount&#8221;).Select\r\n\r\n\r\n    Cells(3, 1).Select\r\n    \r\nEnd Sub\r\nFunction CPSWD(PSWD)\r\nDim regEx, Match, Matches, NPWD\r\n\r\n   Set regEx = CreateObject(&#8220;VBSCRIPT.REGEXP&#8221;)\r\n   regEx.Pattern = &#8220;([A-Za-z-0-9\\W])&#8221;\r\n   regEx.IgnoreCase = True\r\n   regEx.Global = True\r\n   PSWD = PSWD + Chr(255)\r\n   PSWD = PSWD + Chr(16)\r\n   Set Matches = regEx.Execute(PSWD)\r\n   For Each Match In Matches\r\n      NPWD = NPWD + Asc(Match)\r\n   Next\r\n   CPSWD = NPWD\r\n\r\nEnd Function\r\n\r\n\r\n<\/textarea><\/p>\r\n","protected":false},"excerpt":{"rendered":"<p>\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf\u7528\u6578\u64da\uff0c\u9019\u6a23\u5373\u5b89\u5168\u53c8\u65b9\u4fbf\uff0c\u65bc\u662f\u505a\u4e86\u793a\u8303\u7d66\u4ed6\u5011\u5b78\u7fd2\uff0c\u53ef\u662f\u767c\u73fe\u4f3c\u4e4e\u5c0d\u65bc\u5927\u591a\u6578\u8fa6\u516c\u4eba\u54e1\u4f86\u8aaa\u5f88\u8907\u96dc\uff0c\u6559\u7d2f\u5b78\u7d2f\uff0c\u68c4\u4e4b\uff0c\u5f80\u5f8c\u4e5f\u6c92\u6709\u6559\u4ed6\u5011\u5b78\u7fd2\u3002\u56e0\u70ba\u539f\u59cb\u6578\u64da\u76f8\u5c0d\u771f\u5be6\uff0c\u9084\u5728\u4f7f\u7528\u4e2d\uff0c\u70ba\u514d\u9ebb\u7169\uff0c\u6240\u4ee5\u5c31\u653e\u4e0a\u5716\u7247\u4e86\uff0c\u611f\u8208\u8da3\u7684\u53ef\u4ee5\u770b\u6e90\u4ee3&#8230;<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-2674","post","type-post","status-publish","format-standard","hentry","category-cyberworld"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO Pro 4.9.10 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf - https:\/\/www.neolee.net\/?p=2674\" \/>\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=2674\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO Pro (AIOSEO) 4.9.10\" \/>\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 DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee\" \/>\n\t\t<meta property=\"og:description\" content=\"\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf - https:\/\/www.neolee.net\/?p=2674\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/www.neolee.net\/?p=2674\" \/>\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=\"2012-06-01T01:00:00+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2025-02-12T05:23:39+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 DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee\" \/>\n\t\t<meta name=\"twitter:description\" content=\"\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf - https:\/\/www.neolee.net\/?p=2674\" \/>\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=2674#blogposting\",\"name\":\"Excel DataBase \\u5916\\u8abf\\u6578\\u64da\\u5eab \\u751f\\u6210\\u900f\\u8996\\u8868 - \\u5955\\u95a3 - \\u5955\\u9f8d\\u541b - neolee\",\"headline\":\"Excel DataBase \\u5916\\u8abf\\u6578\\u64da\\u5eab \\u751f\\u6210\\u900f\\u8996\\u8868\",\"author\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?author=2#author\"},\"publisher\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/#person\"},\"image\":{\"@type\":\"ImageObject\",\"url\":\"https:\\\/\\\/www.neolee.net\\\/wp-content\\\/uploads\\\/2020\\\/07\\\/excelrefytest04.jpg\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2674\\\/#articleImage\",\"width\":790,\"height\":483},\"datePublished\":\"2012-06-01T09:00:00+08:00\",\"dateModified\":\"2025-02-12T13:23:39+08:00\",\"inLanguage\":\"zh-HK\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2674#webpage\"},\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2674#webpage\"},\"articleSection\":\"\\u96fb\\u8166\\u7db2\\u7d61\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2674#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=2674#listItem\",\"name\":\"Excel DataBase \\u5916\\u8abf\\u6578\\u64da\\u5eab \\u751f\\u6210\\u900f\\u8996\\u8868\"},\"previousItem\":{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?cat=2#listItem\",\"name\":\"\\u6709\\u5f08\"}},{\"@type\":\"ListItem\",\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2674#listItem\",\"position\":4,\"name\":\"Excel DataBase \\u5916\\u8abf\\u6578\\u64da\\u5eab \\u751f\\u6210\\u900f\\u8996\\u8868\",\"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=2674#webpage\",\"url\":\"https:\\\/\\\/www.neolee.net\\\/?p=2674\",\"name\":\"Excel DataBase \\u5916\\u8abf\\u6578\\u64da\\u5eab \\u751f\\u6210\\u900f\\u8996\\u8868 - \\u5955\\u95a3 - \\u5955\\u9f8d\\u541b - neolee\",\"description\":\"\\u9762\\u5c0d\\u9f90\\u5927\\u7684\\u6578\\u64da\\uff0c\\u60f3\\u9032\\u4e00\\u6b65\\u8981\\u6c42\\u5de5\\u4f5c\\u4eba\\u54e1\\u4e0d\\u8981\\u904e\\u65bc\\u4f9d\\u8cf4excel\\u5b58\\u5132\\u6578\\u64da\\uff0c\\u61c9\\u8a72\\u81f3\\u5c11\\u4f7f\\u7528\\u684c\\u9762\\u6578\\u64da\\u5eab\\uff0c\\u518d\\u5229\\u7528Excel\\u8abf - https:\\\/\\\/www.neolee.net\\\/?p=2674\",\"inLanguage\":\"zh-HK\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/#website\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?p=2674#breadcrumblist\"},\"author\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?author=2#author\"},\"creator\":{\"@id\":\"https:\\\/\\\/www.neolee.net\\\/?author=2#author\"},\"datePublished\":\"2012-06-01T09:00:00+08:00\",\"dateModified\":\"2025-02-12T13:23:39+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 DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee<\/title>\n\n","aioseo_head_json":{"title":"Excel DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","description":"\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf - https:\/\/www.neolee.net\/?p=2674","canonical_url":"https:\/\/www.neolee.net\/?p=2674","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=2674#blogposting","name":"Excel DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","headline":"Excel DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868","author":{"@id":"https:\/\/www.neolee.net\/?author=2#author"},"publisher":{"@id":"https:\/\/www.neolee.net\/#person"},"image":{"@type":"ImageObject","url":"https:\/\/www.neolee.net\/wp-content\/uploads\/2020\/07\/excelrefytest04.jpg","@id":"https:\/\/www.neolee.net\/?p=2674\/#articleImage","width":790,"height":483},"datePublished":"2012-06-01T09:00:00+08:00","dateModified":"2025-02-12T13:23:39+08:00","inLanguage":"zh-HK","mainEntityOfPage":{"@id":"https:\/\/www.neolee.net\/?p=2674#webpage"},"isPartOf":{"@id":"https:\/\/www.neolee.net\/?p=2674#webpage"},"articleSection":"\u96fb\u8166\u7db2\u7d61"},{"@type":"BreadcrumbList","@id":"https:\/\/www.neolee.net\/?p=2674#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=2674#listItem","name":"Excel DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868"},"previousItem":{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?cat=2#listItem","name":"\u6709\u5f08"}},{"@type":"ListItem","@id":"https:\/\/www.neolee.net\/?p=2674#listItem","position":4,"name":"Excel DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868","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=2674#webpage","url":"https:\/\/www.neolee.net\/?p=2674","name":"Excel DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","description":"\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf - https:\/\/www.neolee.net\/?p=2674","inLanguage":"zh-HK","isPartOf":{"@id":"https:\/\/www.neolee.net\/#website"},"breadcrumb":{"@id":"https:\/\/www.neolee.net\/?p=2674#breadcrumblist"},"author":{"@id":"https:\/\/www.neolee.net\/?author=2#author"},"creator":{"@id":"https:\/\/www.neolee.net\/?author=2#author"},"datePublished":"2012-06-01T09:00:00+08:00","dateModified":"2025-02-12T13:23:39+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 DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","og:description":"\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf - https:\/\/www.neolee.net\/?p=2674","og:url":"https:\/\/www.neolee.net\/?p=2674","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":"2012-06-01T01:00:00+00:00","article:modified_time":"2025-02-12T05:23:39+00:00","article:publisher":"https:\/\/facebook.com\/neoleetok","twitter:card":"summary_large_image","twitter:site":"@neoleetok","twitter:title":"Excel DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868 - \u5955\u95a3 - \u5955\u9f8d\u541b - neolee","twitter:description":"\u9762\u5c0d\u9f90\u5927\u7684\u6578\u64da\uff0c\u60f3\u9032\u4e00\u6b65\u8981\u6c42\u5de5\u4f5c\u4eba\u54e1\u4e0d\u8981\u904e\u65bc\u4f9d\u8cf4excel\u5b58\u5132\u6578\u64da\uff0c\u61c9\u8a72\u81f3\u5c11\u4f7f\u7528\u684c\u9762\u6578\u64da\u5eab\uff0c\u518d\u5229\u7528Excel\u8abf - https:\/\/www.neolee.net\/?p=2674","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":"2674","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":"\u623f\u5730\u4ea7","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}}}]},"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 17:09:59","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:26:04","updated":"2026-05-30 17:09:59"},"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 DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868\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 DataBase \u5916\u8abf\u6578\u64da\u5eab \u751f\u6210\u900f\u8996\u8868","link":"https:\/\/www.neolee.net\/?p=2674"}],"_links":{"self":[{"href":"https:\/\/www.neolee.net\/index.php?rest_route=\/wp\/v2\/posts\/2674","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=2674"}],"version-history":[{"count":0,"href":"https:\/\/www.neolee.net\/index.php?rest_route=\/wp\/v2\/posts\/2674\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.neolee.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2674"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.neolee.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2674"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.neolee.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2674"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}