{"id":1806,"date":"2022-06-28T16:04:19","date_gmt":"2022-06-28T08:04:19","guid":{"rendered":"https:\/\/www.citerp.com.tw\/citwp2\/?p=1806"},"modified":"2022-10-13T15:40:01","modified_gmt":"2022-10-13T07:40:01","slug":"delphi-excel-1","status":"publish","type":"post","link":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/","title":{"rendered":"Delphi Excel \u64cd\u63a7\u65b9\u6cd5"},"content":{"rendered":"\n<p>Excel\u662f\u5f88\u591a\u4eba\u559c\u6b61\u4f7f\u7528\u7684\u6587\u66f8\u8655\u7406\u5de5\u5177\u3002\u5b78\u6703<strong>Delphi<\/strong>\u5c0d<strong>Excel<\/strong>\u7684\u64cd\u63a7\u65b9\u6cd5\uff0c\u8b93\u7cfb\u7d71\u5728\u505a\u8cc7\u6599\u7684\u532f\u5165\u3001\u532f\u51fa\u66f4\u70ba\u5f97\u5fc3\u61c9\u624b\u3002<\/p>\n\n\n\n<script async=\"\" src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js\"><\/script>\n\t<ins class=\"adsbygoogle\" style=\"display:block\" data-ad-client=\"ca-pub-7536970353732438\" data-ad-slot=\"2906002114\" data-ad-format=\"auto\" data-full-width-responsive=\"true\"><\/ins>\n<script>\n\t(adsbygoogle = window.adsbygoogle || []).push({});\n<\/script>\n\n\n\n<pre class=\"wp-block-code\"><code>\ud83d\udc47<strong>\u9078\u53d6\u5132\u5b58\u683c<\/strong>\nExcelApp.ActiveSheet.Cells.EntireColumn            \/\/\u6240\u6709\u6b04\nExcelApp.ActiveSheet.Cells.EntireRow               \/\/\u6240\u6709\u5217\nExcelApp.ActiveSheet.Cells                         \/\/\u6240\u6709\u5132\u5b58\u683c\nExcelApp.ActiveSheet.Columns&#91;1]                    \/\/\u7b2c\u4e00\u6b04\nExcelApp.ActiveSheet.Rows&#91;1]                       \/\/\u7b2c\u4e00\u5217\nExcelApp.ActiveSheet.Cells&#91;r,c]                    \/\/\u7b2cr\u5217\u7b2cc\u6b04\nExcelApp.ActiveSheet.Range&#91;\u8d77,\u8fc4]                  \/\/\u5340\u9593\u9078\u64c7(\u8d77\u8a16\u53ef\u4ee5\u662f\u6b04\u3001\u5217\u3001\u683c)\n\n\ud83d\udc47<strong>\u8a2d\u5b9a\u5132\u5b58\u683c<\/strong>\nExcelApp.ActiveSheet.Columns&#91;1].ColumnsWidth := 5;  \/\/\u8a2d\u7f6e\u7b2c\u4e00\u6b04\u6b04\u5bec\u72325(5\u5b57\u7b26\u500b\u6578\u5bec)\nExcelApp.ActiveSheet.Rows&#91;2].RowHeight := 16        \/\/\u8a2d\u7f6e\u7b2c\u4e8c\u5217\u5217\u9ad8\u723216\n\nExcelApp.ActiveSheet.Rows&#91;1].NumberFormatLocal:='@';\/\/\u5c07\u5132\u5b58\u683c\u6539\u6210\u6587\u5b57\u683c\u5f0f\nExcelApp.Selection.NumberFormatLocal:='@';          \/\/\u5c07\u5132\u5b58\u683c\u6539\u6210\u6587\u5b57\u683c\u5f0f\nExcelApp.ActiveSheet.Range&#91;'A1:C3'].Merge;          \/\/\u5408\u4f75\u5132\u5b58\u683c\nExcelApp.ActiveSheet.Cells.EntireColumn.AutoFit;    \/\/\u6700\u9069\u6b04\u5bec\nExcelApp.ActiveSheet.Cells.EntireRow.AutoFit;       \/\/\u6700\u9069\u5217\u9ad8\nExcelApp.ActiveSheet.Rows&#91;1].HorizontalAlignment := -4108;\/\/\u6c34\u5e73\u7f6e\u4e2d\n                                                          \/\/(\u9760\u5de6:-4131\uff1b\u9760\u53f3:-4152)\nExcelApp.ActiveSheet.Rows&#91;1].VerticalAlignment := -4108;  \/\/\u5782\u76f4\u7f6e\u4e2d\nExcelApp.ActiveSheet.Rows&#91;1].WrapText  := True;           \/\/\u81ea\u52d5\u63db\u5217\nExcelApp.ActiveSheet.Columns&#91;1].Hidden := True;           \/\/\u96b1\u85cf\nExcelApp.ActiveSheet.Columns&#91;1].NumberFormatLocal := '0.00%'; \/\/\u8a2d\u5b9a\u6b04\u4f4d\u683c\u5f0f&#91;\u767e\u5206\u6bd4]\nExcelApp.ActiveSheet.Cells&#91;1,1].Interior.ColorIndex := 38; \/\/\u8a2d\u5b9a\u5e95\u8272\u70ba\u73ab\u7470\u8272\n\n\n\ud83d\udc47<strong>\u8a2d\u5b9a\u908a\u6846\u7dda<\/strong>\nExcelApp.ActiveSheet.Range&#91; 'B3:D4' ].Borders&#91;2].Weight := 3; \/\/\u6307\u5b9a\u53f3\u908a\u6846\u7dda\u5bec\u5ea63\n\n.Borders&#91;2]       \/\/1-\u5de6 2-\u53f3 3-\u9802 4-\u5e95 5-\u659c( \\ ) 6-\u659c( \/ )\n.LineStyle := 1;  \/\/\u6307\u5b9a\u908a\u6846\u7dda\u7684style 1:\u5be6\u7dda, 2:\u865b\u7dda\n.Weight := 3;     \/\/\u6307\u5b9a\u908a\u6846\u7dda\u7684 Weight (1~4)\n.ColorIndex := 1; \/\/\u6307\u5b9a\u908a\u6846\u7684 ColorIndex (0~56) \n                  \/\/1:\u9ed1\u8272 2:\u767d\u8272 3:\u7d05\u8272 4:\u7da0\u8272 5:\u85cd\u8272 6:\u9ec3\u8272 7:\u7d2b\u8272 8:\u9752\u85cd\u8272 9:\u68d5\u8272..\n\n\ud83d\udc47<strong>\u586b\u503c<\/strong>\nExcelApp.ActiveSheet.Cells&#91;2,4].Value := '\u9019\u662f\u7b2c\u4e8c\u884c\u7b2c\u56db\u5217'; \/\/\u586b\u503c\nExcelApp.ActiveSheet.Cells&#91;1,1].Formula:= '\u516c\u5f0f';           \/\/\u586b\u5165\u516c\u5f0f\nExcelApp.ActiveSheet.Cells&#91;1,4].ClearContents;              \/\/\u6e05\u9664\u516c\u5f0f\nExcelApp.ActiveSheet.Cells&#91;1,1].HasFormula                  \/\/\u5132\u5b58\u683c\u662f\u5426\u6709\u516c\u5f0f\n\n\ud83d\udc47<strong>\u5b57\u9ad4\u5c6c\u6027<\/strong>\nExcelApp.ActiveSheet.Rows&#91;1].Font.Name := '\u96b8\u66f8';\nExcelApp.ActiveSheet.Rows&#91;1].Font.Color := clBlue;\nExcelApp.ActiveSheet.Rows&#91;1].Font.Bold := True;\nExcelApp.ActiveSheet.Rows&#91;1].Font.UnderLine := True;\nExcelApp.ActiveSheet.Rows&#91;1].Font.Size:= 12;\n\n\ud83d\udc47<strong>\u7248\u9762\u8a2d\u5b9a<\/strong>\nExcelApp.ActiveSheet.PageSetup.PrintTitleRows := '$1:$1';        \/\/\u5217\u5370\u6a19\u984c\u5217\nExcelApp.ActiveSheet.PageSetup.CenterHeader := '\u8868\u982d';           \/\/\u4e2d\u9801\u9996\nExcelApp.ActiveSheet.PageSetup.LeftHeader   := '\u9801\u6b21: &amp;P \/ &amp;N';  \/\/\u5de6\u9801\u9996\nExcelApp.ActiveSheet.PageSetup.RightHeader  := '\u88fd\u8868\u4eba';         \/\/\u53f3\u9801\u9996\nExcelApp.ActiveSheet.PageSetup.CenterFooter := '&amp;\u3000&amp;P \/ &amp;N';     \/\/\u4e2d\u9801\u5c3e\nExcelApp.ActiveSheet.PageSetup.LeftFooter   := '\u9801\u6b21: &amp;P \/ &amp;N';  \/\/\u5de6\u9801\u5c3e\nExcelApp.ActiveSheet.PageSetup.RightFooter  := '\u88fd\u8868\u4eba';         \/\/\u53f3\u9801\u5c3e\n\nxcelApp.ActiveSheet.PageSetup.PrintArea := '$B$1:$N$150';  \/\/\u8a2d\u5b9a\u5217\u5370\u7bc4\u570d\nExcelApp.ActiveSheet.PageSetup.Orientation := 2;    \/\/1.\u76f4\u5370 2.\u6a6b\u5370\nExcelApp.ActiveSheet.PageSetup.Zoom := 65;          \/\/\u5217\u5370\u6642\u7e2e\u5c0f\u621065%\nExcelApp.ActiveSheet.PageSetup.Zoom := True;        \/\/\u4f7f\u7528\u9801\u6b21\u7e2e\u653e\u529f\u80fd\nExcelApp.ActiveSheet.PageSetup.FitToPagesWide := 1; \/\/\u7e2e\u653e\u6210\u4e00\u9801\u5bec(\u9700\u914d\u5408Zoom=True)\nExcelApp.ActiveSheet.PageSetup.FitToPagesTall := 1; \/\/\u7e2e\u653e\u6210\u4e00\u9801\u9ad8(\u9700\u914d\u5408Zoom=True)\nExcelApp.ActiveSheet.PageSetup.PaperSize := 8;      \/\/\u8a2d\u5b9a\u7d19\u5f35\u5927\u5c0f 8:A3\u30019:A4\n\nExcelApp.ActiveSheet.PageSetup.HeaderMargin := 2\/0.035; \/\/\u9801\u9996\u9802\u908a\u8ddd\nExcelApp.ActiveSheet.PageSetup.FooterMargin := 3\/0.035; \/\/\u9801\u5c3e\u5e95\u908a\u8ddd\nExcelApp.ActiveSheet.PageSetup.TopMargin := 2\/0.035;    \/\/\u9802\u908a\u8ddd2cm\nExcelApp.ActiveSheet.PageSetup.BottomMargin := 2\/0.035; \/\/\u5e95\u908a\u8ddd2cm\nExcelApp.ActiveSheet.PageSetup.LeftMargin := 2\/0.035;   \/\/\u5de6\u908a\u8ddd2cm\nExcelApp.ActiveSheet.PageSetup.RightMargin := 2\/0.035;  \/\/\u53f3\u908a\u8ddd2cm\nExcelApp.ActiveSheet.PageSetup.CenterHorizontally := True;  \/\/\u9801\u9762\u6c34\u5e73\u5c45\u4e2d\nExcelApp.ActiveSheet.PageSetup.CenterVertically := True;    \/\/\u9801\u9762\u5782\u76f4\u5c45\u4e2d\nExcelApp.ActiveSheet.PageSetup.PrintGridLines := True;      \/\/\u683c\u7db2\u7dda\n\n\ud83d\udc47<strong>\u51cd\u7d50\u7a97\u683c<\/strong>\nExcelApp.ActiveSheet.Cells&#91;3,3].Select;\nExcelApp.ActiveWindow.FreezePanes := True;\n\n\ud83d\udc47<strong>\u62f7\u8c9d\u64cd\u4f5c<\/strong>\nExcelApp.ActiveSheet.Used.Range.Copy;              \/\/\u62f7\u8c9d\u6574\u500b\u5de5\u4f5c\u8868\nExcelApp.ActiveSheet.Range&#91; 'A1:E2' ].Copy;        \/\/\u62f7\u8c9d\u6307\u5b9a\u5340\u57df\nExcelApp.ActiveSheet.Range.&#91; 'A1' ].PasteSpecial;  \/\/\u5f9eA1\u4f4d\u7f6e\u958b\u59cb\u7c98\u8cbc\nExcelApp.ActiveSheet.Range.PasteSpecial;           \/\/\u5f9e\u6587\u4ef6\u5c3e\u90e8\u958b\u59cb\u7c98\u8cbc\nExcelApp.ActiveSheet.Rows&#91;2].Insert;               \/\/\u63d2\u5165\u4e00\u5217\nExcelApp.ActiveSheet.Columns&#91;1].Insert;            \/\/\u63d2\u5165\u4e00\u6b04\nExcelApp.ActiveSheet.Rows&#91;2].Delete;               \/\/\u522a\u9664\u4e00\u5217\nExcelApp.ActiveSheet.Columns&#91;1].Delete;            \/\/\u522a\u9664\u4e00\u6b04\n<\/code><\/pre>\n\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<p>\ud83d\udc49<strong><span style=\"color:#ff0080\" class=\"has-inline-color\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/\" target=\"_blank\" rel=\"noreferrer noopener\">Delphi Excel \u64cd\u63a7\u65b9\u6cd5<\/a><\/span><\/strong><\/p>\n\n\n\n<p>\ud83d\udc49<strong><span style=\"color:#ff0080\" class=\"has-inline-color\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-1\/\" target=\"_blank\" rel=\"noreferrer noopener\">Delphi\u9650\u5236Edit\u53ea\u80fd\u8f38\u5165\u6578\u5b57<\/a><\/span><\/strong><\/p>\n\n\n\n<p>\ud83d\udc49<strong><span style=\"color:#ff0080\" class=\"has-inline-color\"><a href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-2\/\" target=\"_blank\" rel=\"noreferrer noopener\">Delphi \u9375\u503cASCII\u5c0d\u7167\u5927\u5168 (\u5305\u62ec\u6ed1\u9f20\u53ca\u9375\u76e4)<\/a><\/span><\/strong><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel\u662f\u5f88\u591a\u4eba\u559c\u6b61\u4f7f\u7528\u7684\u6587\u66f8\u8655\u7406\u5de5\u5177\u3002\u5b78\u6703Delphi\u5c0dExcel\u7684\u64cd\u63a7\u65b9\u6cd5\uff0c\u8b93\u7cfb\u7d71\u5728\u505a\u8cc7\u6599\u7684\u532f\u5165\u3001\u532f\u51fa\u66f4 &#8230; <a title=\"Delphi Excel \u64cd\u63a7\u65b9\u6cd5\" class=\"read-more\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/\" aria-label=\"\u66f4\u591a\u95dc\u65bc Delphi Excel \u64cd\u63a7\u65b9\u6cd5\">\u95b1\u8b80\u66f4\u591a<\/a><\/p>\n","protected":false},"author":1,"featured_media":1815,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"qubely_global_settings":"","qubely_interactions":"","footnotes":""},"categories":[9],"tags":[36],"class_list":["post-1806","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-program","tag-delphi"],"qubely_featured_image_url":{"full":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"landscape":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"portraits":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"thumbnail":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"medium":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"medium_large":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"large":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"1536x1536":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"2048x2048":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"qubely_landscape":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"qubely_portrait":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png",128,128,false],"qubely_thumbnail":["https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1-128x100.png",128,100,true]},"qubely_author":{"display_name":"\u5927\u53d4","author_link":"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/"},"qubely_comment":0,"qubely_category":"<a href=\"https:\/\/www.citerp.com.tw\/citwp2\/category\/program\/\" rel=\"category tag\">\u7a0b\u5f0f\u8a9e\u8a00<\/a>","qubely_excerpt":"Excel\u662f\u5f88\u591a\u4eba\u559c\u6b61\u4f7f\u7528\u7684\u6587\u66f8\u8655\u7406\u5de5\u5177\u3002\u5b78\u6703Delphi\u5c0dExcel\u7684\u64cd\u63a7\u65b9\u6cd5\uff0c\u8b93\u7cfb\u7d71\u5728\u505a\u8cc7\u6599\u7684\u532f\u5165\u3001\u532f\u51fa\u66f4...","yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v17.8 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Delphi Excel \u64cd\u63a7\u65b9\u6cd5 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/\" \/>\n<meta property=\"og:locale\" content=\"zh_TW\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Delphi Excel \u64cd\u63a7\u65b9\u6cd5 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4\" \/>\n<meta property=\"og:description\" content=\"Excel\u662f\u5f88\u591a\u4eba\u559c\u6b61\u4f7f\u7528\u7684\u6587\u66f8\u8655\u7406\u5de5\u5177\u3002\u5b78\u6703Delphi\u5c0dExcel\u7684\u64cd\u63a7\u65b9\u6cd5\uff0c\u8b93\u7cfb\u7d71\u5728\u505a\u8cc7\u6599\u7684\u532f\u5165\u3001\u532f\u51fa\u66f4 ... \u95b1\u8b80\u66f4\u591a\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/\" \/>\n<meta property=\"og:site_name\" content=\"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4\" \/>\n<meta property=\"article:published_time\" content=\"2022-06-28T08:04:19+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-10-13T07:40:01+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"128\" \/>\n\t<meta property=\"og:image:height\" content=\"128\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"\u5927\u53d4\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 \u5206\u9418\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#website\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/\",\"name\":\"\\u514d\\u8cbb\\u8cc7\\u6e90\\u793e\\u7fa4\",\"description\":\"\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u3000\\u5584\\u7528\\u7db2\\u8def\\u8cc7\\u6e90\\u627e\\u5230\\u66f4\\u7f8e\\u597d\\u7684\\u751f\\u6d3b..\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.citerp.com.tw\/citwp2\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"zh-TW\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#primaryimage\",\"inLanguage\":\"zh-TW\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png\",\"contentUrl\":\"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png\",\"width\":128,\"height\":128},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#webpage\",\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/\",\"name\":\"Delphi Excel \\u64cd\\u63a7\\u65b9\\u6cd5 - \\u514d\\u8cbb\\u8cc7\\u6e90\\u793e\\u7fa4\",\"isPartOf\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#primaryimage\"},\"datePublished\":\"2022-06-28T08:04:19+00:00\",\"dateModified\":\"2022-10-13T07:40:01+00:00\",\"author\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#breadcrumb\"},\"inLanguage\":\"zh-TW\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"\\u9996\\u9801\",\"item\":\"https:\/\/www.citerp.com.tw\/citwp2\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Delphi Excel \\u64cd\\u63a7\\u65b9\\u6cd5\"}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007\",\"name\":\"\\u5927\\u53d4\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/www.citerp.com.tw\/citwp2\/#personlogo\",\"inLanguage\":\"zh-TW\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g\",\"caption\":\"\\u5927\\u53d4\"},\"sameAs\":[\"http:\/\/localhost\/wp2\"],\"url\":\"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Delphi Excel \u64cd\u63a7\u65b9\u6cd5 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/","og_locale":"zh_TW","og_type":"article","og_title":"Delphi Excel \u64cd\u63a7\u65b9\u6cd5 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","og_description":"Excel\u662f\u5f88\u591a\u4eba\u559c\u6b61\u4f7f\u7528\u7684\u6587\u66f8\u8655\u7406\u5de5\u5177\u3002\u5b78\u6703Delphi\u5c0dExcel\u7684\u64cd\u63a7\u65b9\u6cd5\uff0c\u8b93\u7cfb\u7d71\u5728\u505a\u8cc7\u6599\u7684\u532f\u5165\u3001\u532f\u51fa\u66f4 ... \u95b1\u8b80\u66f4\u591a","og_url":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/","og_site_name":"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","article_published_time":"2022-06-28T08:04:19+00:00","article_modified_time":"2022-10-13T07:40:01+00:00","og_image":[{"width":128,"height":128,"url":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png","type":"image\/png"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"\u5927\u53d4","Est. reading time":"2 \u5206\u9418"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebSite","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#website","url":"https:\/\/www.citerp.com.tw\/citwp2\/","name":"\u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","description":"\u3000\u3000\u3000\u3000\u3000\u3000\u3000\u5584\u7528\u7db2\u8def\u8cc7\u6e90\u627e\u5230\u66f4\u7f8e\u597d\u7684\u751f\u6d3b..","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.citerp.com.tw\/citwp2\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"zh-TW"},{"@type":"ImageObject","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#primaryimage","inLanguage":"zh-TW","url":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png","contentUrl":"https:\/\/www.citerp.com.tw\/citwp2\/wp-content\/uploads\/2022\/06\/delphi-excel-1-1-1.png","width":128,"height":128},{"@type":"WebPage","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#webpage","url":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/","name":"Delphi Excel \u64cd\u63a7\u65b9\u6cd5 - \u514d\u8cbb\u8cc7\u6e90\u793e\u7fa4","isPartOf":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#primaryimage"},"datePublished":"2022-06-28T08:04:19+00:00","dateModified":"2022-10-13T07:40:01+00:00","author":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007"},"breadcrumb":{"@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#breadcrumb"},"inLanguage":"zh-TW","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.citerp.com.tw\/citwp2\/2022\/06\/28\/delphi-excel-1\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"\u9996\u9801","item":"https:\/\/www.citerp.com.tw\/citwp2\/"},{"@type":"ListItem","position":2,"name":"Delphi Excel \u64cd\u63a7\u65b9\u6cd5"}]},{"@type":"Person","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#\/schema\/person\/0aa923c8012bd2d1265f8dc51bc19007","name":"\u5927\u53d4","image":{"@type":"ImageObject","@id":"https:\/\/www.citerp.com.tw\/citwp2\/#personlogo","inLanguage":"zh-TW","url":"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/26ac9fa540152f6a281d4515791706a2351cb504d50b3a9442e77693e6329617?s=96&d=mm&r=g","caption":"\u5927\u53d4"},"sameAs":["http:\/\/localhost\/wp2"],"url":"https:\/\/www.citerp.com.tw\/citwp2\/author\/citadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/1806","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/comments?post=1806"}],"version-history":[{"count":8,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/1806\/revisions"}],"predecessor-version":[{"id":2719,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/posts\/1806\/revisions\/2719"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/media\/1815"}],"wp:attachment":[{"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/media?parent=1806"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/categories?post=1806"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.citerp.com.tw\/citwp2\/wp-json\/wp\/v2\/tags?post=1806"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}