{ "version": "https://jsonfeed.org/version/1.1", "user_comment": "This feed allows you to read the posts from this site in any feed reader that supports the JSON Feed format. To add this feed to your reader, copy the following URL -- https://www.6erp.cn/tag/excel%e8%a1%a8%e6%a0%bc%e4%b8%80%e9%94%ae%e7%be%8e%e5%8c%96/feed/json -- and add it your reader.", "next_url": "https://www.6erp.cn/tag/excel%e8%a1%a8%e6%a0%bc%e4%b8%80%e9%94%ae%e7%be%8e%e5%8c%96/feed/json?paged=2", "home_page_url": "https://www.6erp.cn/tag/excel%e8%a1%a8%e6%a0%bc%e4%b8%80%e9%94%ae%e7%be%8e%e5%8c%96", "feed_url": "https://www.6erp.cn/tag/excel%e8%a1%a8%e6%a0%bc%e4%b8%80%e9%94%ae%e7%be%8e%e5%8c%96/feed/json", "language": "zh-Hans", "title": "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316 – \u901a\u5546\u8f6f\u4ef6", "description": "ERP,MES,\u8fdb\u9500\u5b58,\u529e\u516c\u534f\u4f5c,MoreExcel\u63d2\u4ef6", "icon": "https://www.6erp.cn/wp-content/uploads/2015/02/2014-06-16_1114_afms1.png", "items": [ { "id": "https://www.6erp.cn/?p=78951", "url": "https://www.6erp.cn/article_78951.html", "title": "\u79bb\u7ebf\u73af\u5883\u4e0b\u5982\u4f55\u8fdb\u884cExcel\u4e0b\u8f7d\u4e0e\u6fc0\u6d3b\uff1f", "content_html": "\u5728\u5982\u4eca\u7684\u5de5\u4f5c\u548c\u751f\u6d3b\u4e2d\uff0cMicrosoft Excel\u4f5c\u4e3a\u4e00\u6b3e\u529f\u80fd\u5f3a\u5927\u7684\u7535\u5b50\u8868\u683c\u8f6f\u4ef6\uff0c\u5df2\u7ecf\u6210\u4e3a\u4e86\u51e0\u4e4e\u6bcf\u4e2a\u529e\u516c\u73af\u5883 […]", "content_text": "\u5728\u5982\u4eca\u7684\u5de5\u4f5c\u548c\u751f\u6d3b\u4e2d\uff0cMicrosoft Excel\u4f5c\u4e3a\u4e00\u6b3e\u529f\u80fd\u5f3a\u5927\u7684\u7535\u5b50\u8868\u683c\u8f6f\u4ef6\uff0c\u5df2\u7ecf\u6210\u4e3a\u4e86\u51e0\u4e4e\u6bcf\u4e2a\u529e\u516c\u73af\u5883 […]", "date_published": "2025-07-03T12:10:37+08:00", "date_modified": "2025-07-03T12:10:37+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u4e0b\u79fb\u4e00\u884c", "Excel\u8868\u683c\u4e0d\u80fd\u7b5b\u9009", "Excel\u8868\u683c\u5168\u90e8\u4e58\u4ee5\u4e00\u4e2a\u6570\u600e\u4e48\u505a", "Excel\u8868\u683c\u5236\u4f5c\u81ea\u52a8\u8ba1\u7b97\u516c\u5f0f", "Excel\u8868\u683c\u600e\u4e48\u52a0\u5bc6", "Excel\u8868\u683c\u6253\u5370\u9884\u89c8\u5728\u54ea\u91cc", "Excel\u8868\u683c\u6253\u5f00\u4e24\u4e2a\u8868 \u53ea\u663e\u793a\u4e00\u4e2a", "excel\u8868\u683c\u7535\u5b50\u7248", "Excel\u8868\u683c\u91cc\u9762\u7684\u5185\u5bb9\u600e\u4e48\u6362\u884c", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=78883", "url": "https://www.6erp.cn/article_78883.html", "title": "Excel\u6253\u5370\u65f6\u5206\u9875\u9519\u4e71\u600e\u4e48\u8c03\u6574\uff1f", "content_html": "\u5728\u4f7f\u7528Excel\u65f6\uff0c\u8bb8\u591a\u4eba\u4f1a\u9047\u5230\u6253\u5370\u65f6\u5206\u9875\u9519\u4e71\u7684\u95ee\u9898\u3002\u8fd9\u4e0d\u4ec5\u5f71\u54cd\u6253\u5370\u6548\u679c\uff0c\u4e5f\u53ef\u80fd\u5bfc\u81f4\u6570\u636e\u7684\u4e22\u5931\u6216\u8005\u9519\u8bef\u5c55\u793a\u3002\u4e3a […]", "content_text": "\u5728\u4f7f\u7528Excel\u65f6\uff0c\u8bb8\u591a\u4eba\u4f1a\u9047\u5230\u6253\u5370\u65f6\u5206\u9875\u9519\u4e71\u7684\u95ee\u9898\u3002\u8fd9\u4e0d\u4ec5\u5f71\u54cd\u6253\u5370\u6548\u679c\uff0c\u4e5f\u53ef\u80fd\u5bfc\u81f4\u6570\u636e\u7684\u4e22\u5931\u6216\u8005\u9519\u8bef\u5c55\u793a\u3002\u4e3a […]", "date_published": "2025-07-03T11:52:32+08:00", "date_modified": "2025-07-03T11:52:32+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "10\u76846\u6b21\u65b9\u600e\u4e48\u8f93\u5165", "excel\u600e\u4e48\u628aa\u5217\u548cb\u5217\u4e92\u6362", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u5355\u4ef7\u600e\u4e48\u7b97", "Excel\u8868\u683c\u5355\u5143\u683c\u62c6\u5206", "excel\u8868\u683c\u600e\u4e48\u8bfb", "Excel\u8868\u683c\u65e5\u671f\u52a0\u51cf\u81ea\u52a8\u8ba1\u7b97", "excel\u8868\u683c\u7a7a\u767d\u533a\u57df\u5448\u73b0\u7070\u8272\u600e\u4e48\u5f04\u7684", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78833", "url": "https://www.6erp.cn/article_78833.html", "title": "\u201cWord Excel\u5236\u4f5c\u201d\u9ad8\u7ea7\uff1aExcel\u900f\u89c6\u8868\u5d4c\u5165Word\u5e94\u7528", "content_html": "Excel\u900f\u89c6\u8868\u5d4c\u5165Word\u7684\u9ad8\u7ea7\u5e94\u7528\u6280\u5de7 \u5728\u65e5\u5e38\u5de5\u4f5c\u548c\u6570\u636e\u5206\u6790\u4e2d\uff0cExcel\u900f\u89c6\u8868\u4f5c\u4e3a\u4e00\u79cd\u9ad8\u6548\u7684\u6570\u636e\u5206\u6790\u5de5\u5177 […]", "content_text": "Excel\u900f\u89c6\u8868\u5d4c\u5165Word\u7684\u9ad8\u7ea7\u5e94\u7528\u6280\u5de7 \u5728\u65e5\u5e38\u5de5\u4f5c\u548c\u6570\u636e\u5206\u6790\u4e2d\uff0cExcel\u900f\u89c6\u8868\u4f5c\u4e3a\u4e00\u79cd\u9ad8\u6548\u7684\u6570\u636e\u5206\u6790\u5de5\u5177 […]", "date_published": "2025-07-02T10:08:59+08:00", "date_modified": "2025-07-02T10:08:59+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "excel\u6eda\u8f6e\u5e45\u5ea6\u592a\u5927 \u8df3\u8fc7\u5f88\u591a\u884c", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u4e58\u79ef\u51fd\u6570", "Excel\u8868\u683c\u5355\u4ef7\u600e\u4e48\u7b97", "Excel\u8868\u683c\u600e\u4e48\u5f04\u9009\u62e9\u9879", "excel\u8868\u683c\u600e\u4e48\u770b\u6709\u591a\u5c11\u4e2a\u5b57", "Excel\u8868\u683c\u600e\u4e48\u81ea\u52a8\u751f\u6210\u65e5\u671f", "Excel\u8868\u683c\u600e\u4e48\u8bbe\u7f6e\u884c\u95f4\u8ddd", "Excel\u8868\u683c\u7684\u6c42\u548c\u516c\u5f0f", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78799", "url": "https://www.6erp.cn/article_78799.html", "title": "lookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\u914d\u5408offset\u5b9e\u73b0\u6ed1\u52a8\u7a97\u53e3\u67e5\u627e", "content_html": "\u5728\u73b0\u4ee3\u7535\u5b50\u8868\u683c\u8f6f\u4ef6\u4e2d\uff0c\u67e5\u627e\u548c\u5f15\u7528\u6570\u636e\u662f\u5e38\u89c1\u7684\u4efb\u52a1\u4e4b\u4e00\uff0c\u5c24\u5176\u662f\u5f53\u4f60\u5904\u7406\u5927\u91cf\u6570\u636e\u65f6\uff0c\u80fd\u591f\u9ad8\u6548\u5730\u5b9a\u4f4d\u548c\u63d0\u53d6\u6570\u636e\u53d8\u5f97\u81f3 […]", "content_text": "\u5728\u73b0\u4ee3\u7535\u5b50\u8868\u683c\u8f6f\u4ef6\u4e2d\uff0c\u67e5\u627e\u548c\u5f15\u7528\u6570\u636e\u662f\u5e38\u89c1\u7684\u4efb\u52a1\u4e4b\u4e00\uff0c\u5c24\u5176\u662f\u5f53\u4f60\u5904\u7406\u5927\u91cf\u6570\u636e\u65f6\uff0c\u80fd\u591f\u9ad8\u6548\u5730\u5b9a\u4f4d\u548c\u63d0\u53d6\u6570\u636e\u53d8\u5f97\u81f3 […]", "date_published": "2025-07-02T09:59:31+08:00", "date_modified": "2025-07-02T09:59:31+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "1\u4e002\u4e00201\u5728\u8868\u683c\u600e\u4e48\u8f93\u5165", "Excel\u8868\u683cln\u516c\u5f0f\u600e\u4e48\u7528", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u4e0d\u80fd\u7b5b\u9009", "excel\u8868\u683c\u5982\u4f55\u663e\u793a\u516c\u5f0f", "Excel\u8868\u683c\u67e5\u8be2\u600e\u4e48\u67e5", "Excel\u8868\u683c\u6c47\u603b\u600e\u4e48\u64cd\u4f5c", "Excel\u8868\u683c\u884c\u95f4\u8ddd", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78703", "url": "https://www.6erp.cn/article_78703.html", "title": "Excel\u6253\u5370\u65f6\u8868\u683c\u6a2a\u5411\u592a\u957f\u5982\u4f55\u81ea\u52a8\u7f29\u653e\uff1f", "content_html": "\u5728\u4f7f\u7528Excel\u5904\u7406\u6570\u636e\u65f6\uff0c\u5f88\u591a\u65f6\u5019\u4f1a\u9762\u4e34\u8868\u683c\u8fc7\u957f\u6216\u8fc7\u5bbd\u7684\u95ee\u9898\u3002\u5c24\u5176\u5728\u6253\u5370\u8868\u683c\u65f6\uff0c\u8d85\u51fa\u9875\u9762\u7684\u5185\u5bb9\u4f1a\u88ab\u622a\u65ad\uff0c\u5bfc\u81f4 […]", "content_text": "\u5728\u4f7f\u7528Excel\u5904\u7406\u6570\u636e\u65f6\uff0c\u5f88\u591a\u65f6\u5019\u4f1a\u9762\u4e34\u8868\u683c\u8fc7\u957f\u6216\u8fc7\u5bbd\u7684\u95ee\u9898\u3002\u5c24\u5176\u5728\u6253\u5370\u8868\u683c\u65f6\uff0c\u8d85\u51fa\u9875\u9762\u7684\u5185\u5bb9\u4f1a\u88ab\u622a\u65ad\uff0c\u5bfc\u81f4 […]", "date_published": "2025-07-01T09:33:08+08:00", "date_modified": "2025-07-01T09:33:08+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c4\u820d5\u5165", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u4e0d\u591f\u7528\u4e86", "excel\u8868\u683c\u600e\u4e48\u6362\u884c", "Excel\u8868\u683c\u62a4\u773c\u5728\u54ea\u91cc\u8bbe\u7f6e", "Excel\u8868\u683c\u6846\u7ebf\u7c97\u7ec6\u600e\u4e48\u8bbe\u7f6e", "Excel\u8868\u683c\u8de8\u9875\u65ad\u5f00\u600e\u4e48\u89e3\u51b3", "Excel\u8868\u683c\u8fdb\u9500\u5b58\u81ea\u52a8\u751f\u6210", "\u600e\u4e48\u589e\u52a0\u5355\u5143\u683c", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78689", "url": "https://www.6erp.cn/article_78689.html", "title": "xlookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\u4e0e\u5b8f\u5f55\u5236\u81ea\u52a8\u5316\u67e5\u8be2", "content_html": "XLOOKUP\u51fd\u6570\u7b80\u4ecb\u53ca\u5e94\u7528 \u5728Excel\u4e2d\uff0c\u67e5\u627e\u548c\u5f15\u7528\u6570\u636e\u662f\u6211\u4eec\u65e5\u5e38\u4f7f\u7528\u4e2d\u7684\u57fa\u7840\u529f\u80fd\u4e4b\u4e00\uff0c\u7279\u522b\u662f\u9700\u8981\u5728\u4e0d\u540c\u8868 […]", "content_text": "XLOOKUP\u51fd\u6570\u7b80\u4ecb\u53ca\u5e94\u7528 \u5728Excel\u4e2d\uff0c\u67e5\u627e\u548c\u5f15\u7528\u6570\u636e\u662f\u6211\u4eec\u65e5\u5e38\u4f7f\u7528\u4e2d\u7684\u57fa\u7840\u529f\u80fd\u4e4b\u4e00\uff0c\u7279\u522b\u662f\u9700\u8981\u5728\u4e0d\u540c\u8868 […]", "date_published": "2025-07-01T09:29:26+08:00", "date_modified": "2025-07-01T09:29:26+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u4e3a0\u663e\u793a\u4e3a\u7a7a", "Excel\u8868\u683c\u4e58\u79ef\u516c\u5f0f", "Excel\u8868\u683c\u5206\u9875\u9884\u89c8\u600e\u4e48\u589e\u52a0\u9875", "excel\u8868\u683c\u56de\u8f66\u952e\u65e0\u6cd5\u6362\u884c", "Excel\u8868\u683c\u5b8f\u88ab\u7981\u7528\u600e\u4e48\u6253\u5f00", "Excel\u8868\u683c\u600e\u4e48\u53bb\u9664\u91cd\u590d\u7684\u6570\u636e", "Excel\u8868\u683c\u600e\u4e48\u7b5b\u9009\u6570\u636e", "Excel\u8868\u683c\u753b\u659c\u7ebf", "Excel\u8868\u683c\u968f\u673a\u751f\u6210\u533a\u95f4\u6570\u503c", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78513", "url": "https://www.6erp.cn/article_78513.html", "title": "\u8868\u683c\u5236\u4f5cExcel\uff1a\u600e\u6837\u5229\u7528FILTER\u51fd\u6570\u7b5b\u9009\uff1f", "content_html": "\u5982\u4f55\u4f7f\u7528Excel\u4e2d\u7684FILTER\u51fd\u6570\u8fdb\u884c\u7b5b\u9009\u64cd\u4f5c \u5728\u5904\u7406\u5927\u91cf\u6570\u636e\u65f6\uff0cExcel\u88ab\u5e7f\u6cdb\u5e94\u7528\u4e8e\u5404\u4e2a\u9886\u57df\uff0c\u5e2e\u52a9\u4eba\u4eec […]", "content_text": "\u5982\u4f55\u4f7f\u7528Excel\u4e2d\u7684FILTER\u51fd\u6570\u8fdb\u884c\u7b5b\u9009\u64cd\u4f5c \u5728\u5904\u7406\u5927\u91cf\u6570\u636e\u65f6\uff0cExcel\u88ab\u5e7f\u6cdb\u5e94\u7528\u4e8e\u5404\u4e2a\u9886\u57df\uff0c\u5e2e\u52a9\u4eba\u4eec […]", "date_published": "2025-06-30T10:32:05+08:00", "date_modified": "2025-06-30T10:32:05+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683ce+17", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u4e0d\u80fd\u7b5b\u9009\u662f\u4ec0\u4e48\u539f\u56e0", "Excel\u8868\u683c\u51fd\u6570\u600e\u4e48\u53d8\u6210\u6570\u5b57", "Excel\u8868\u683c\u5b8f\u88ab\u7981\u7528\u600e\u4e48\u6253\u5f00", "excel\u8868\u683c\u600e\u4e48\u6362\u884c", "Excel\u8868\u683c\u600e\u6837\u81ea\u52a8\u6392\u5e8f\u53f7", "Excel\u8868\u683c\u65e5\u671f\u52a0\u51cf\u81ea\u52a8\u8ba1\u7b97", "Excel\u8868\u683c\u7b26\u53f7\u5728\u54ea\u91cc\u627e", "Excel\u8868\u683c\u9ed1\u7ebf\u600e\u4e48\u5f04", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78472", "url": "https://www.6erp.cn/article_78472.html", "title": "xlookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\u4e0e\u6761\u4ef6\u683c\u5f0f\u9ad8\u4eae\u7ed3\u5408\u6848\u4f8b", "content_html": "\u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\uff0c\u6211\u4eec\u5e38\u5e38\u9700\u8981\u5bf9\u5927\u91cf\u7684\u6570\u636e\u8fdb\u884c\u5feb\u901f\u67e5\u627e\u548c\u5bf9\u6bd4\uff0c\u5c24\u5176\u662f\u4f7f\u7528Excel\u8fd9\u7c7b\u5de5\u5177\u65f6\uff0c\u67e5\u627e\u3001\u5bf9\u6bd4\u548c\u7a81\u51fa\u663e\u793a […]", "content_text": "\u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\uff0c\u6211\u4eec\u5e38\u5e38\u9700\u8981\u5bf9\u5927\u91cf\u7684\u6570\u636e\u8fdb\u884c\u5feb\u901f\u67e5\u627e\u548c\u5bf9\u6bd4\uff0c\u5c24\u5176\u662f\u4f7f\u7528Excel\u8fd9\u7c7b\u5de5\u5177\u65f6\uff0c\u67e5\u627e\u3001\u5bf9\u6bd4\u548c\u7a81\u51fa\u663e\u793a […]", "date_published": "2025-06-27T11:08:31+08:00", "date_modified": "2025-06-27T11:08:31+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u628a\u4e24\u4e2a\u8868\u683c\u5185\u5bb9\u5408\u5e76\u5230\u4e00\u8d77", "Excel\u8868\u683c4\u820d5\u5165", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u600e\u4e48\u51bb\u7ed3\u591a\u884c\u591a\u5217", "excel\u8868\u683c\u600e\u4e48\u770b\u6709\u591a\u5c11\u4e2a\u5b57", "Excel\u8868\u683c\u65b9\u6846\u600e\u4e48\u6253\u51fa\u6765", "Excel\u8868\u683c\u65f6\u95f4\u5dee\u8ba1\u7b97\u516c\u5f0f", "Excel\u8868\u683c\u67e5\u91cd\u590d", "Excel\u8868\u683c\u8fb9\u6846\u7ebf\u4e0d\u663e\u793a\u600e\u4e48\u64cd\u4f5c", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=78370", "url": "https://www.6erp.cn/article_78370.html", "title": "\u65b0\u624b\u5165\u95e8\uff1avlookup\u51fd\u6570\u7684\u57fa\u672c\u7528\u6cd5\u8be6\u89e3", "content_html": "VLOOKUP\u51fd\u6570\u7684\u57fa\u672c\u7528\u6cd5\u8be6\u89e3 \u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\uff0c\u5c24\u5176\u662f\u5728\u6570\u636e\u5206\u6790\u3001\u62a5\u8868\u751f\u6210\u4ee5\u53ca\u5404\u7c7b\u4e1a\u52a1\u6570\u636e\u7ba1\u7406\u8fc7\u7a0b\u4e2d\uff0cExce […]", "content_text": "VLOOKUP\u51fd\u6570\u7684\u57fa\u672c\u7528\u6cd5\u8be6\u89e3 \u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\uff0c\u5c24\u5176\u662f\u5728\u6570\u636e\u5206\u6790\u3001\u62a5\u8868\u751f\u6210\u4ee5\u53ca\u5404\u7c7b\u4e1a\u52a1\u6570\u636e\u7ba1\u7406\u8fc7\u7a0b\u4e2d\uff0cExce […]", "date_published": "2025-06-27T10:37:54+08:00", "date_modified": "2025-06-27T10:37:54+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u4e58\u79ef\u516c\u5f0f", "Excel\u8868\u683c\u51fa\u73b0\u6c49\u5b57\u4e71\u7801", "Excel\u8868\u683c\u5206\u9875\u9884\u89c8\u600e\u4e48\u53d6\u6d88", "Excel\u8868\u683c\u540e\u9762\u7684\u7a7a\u767d\u9875\u600e\u4e48\u5220\u9664\u4e0d\u4e86", "Excel\u8868\u683c\u600e\u4e48\u81ea\u52a8\u751f\u6210\u65e5\u671f", "Excel\u8868\u683c\u600e\u4e48\u8c03\u6574\u8868\u683c\u5927\u5c0f", "excel\u8868\u683c\u6362\u884c\u600e\u4e48\u64cd\u4f5c", "Excel\u8868\u683c\u65e5\u671f\u52a0\u51cf\u81ea\u52a8\u8ba1\u7b97", "excel\u8868\u683c\u8fb9\u6846\u989c\u8272\u600e\u4e48\u6539", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78326", "url": "https://www.6erp.cn/article_78326.html", "title": "vlookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\uff1a\u8bbe\u7f6e\u8fd1\u4f3c\u5339\u914d\u4e0e\u7cbe\u786e\u5339\u914d\u7684\u65b9\u6cd5", "content_html": "\u5728\u73b0\u4ee3\u529e\u516c\u73af\u5883\u4e2d\uff0cExcel\u4f5c\u4e3a\u4e00\u79cd\u5f3a\u5927\u7684\u6570\u636e\u5904\u7406\u5de5\u5177\uff0c\u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\u53d1\u6325\u7740\u91cd\u8981\u4f5c\u7528\u3002\u5176\u4e2d\uff0cVLOOKUP\u51fd\u6570\u662f […]", "content_text": "\u5728\u73b0\u4ee3\u529e\u516c\u73af\u5883\u4e2d\uff0cExcel\u4f5c\u4e3a\u4e00\u79cd\u5f3a\u5927\u7684\u6570\u636e\u5904\u7406\u5de5\u5177\uff0c\u5728\u65e5\u5e38\u5de5\u4f5c\u4e2d\u53d1\u6325\u7740\u91cd\u8981\u4f5c\u7528\u3002\u5176\u4e2d\uff0cVLOOKUP\u51fd\u6570\u662f […]", "date_published": "2025-06-26T10:56:09+08:00", "date_modified": "2025-06-26T10:56:09+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "cad\u4e2d\u5982\u4f55\u5bfc\u5165Excel\u8868\u683c", "Excel \u8868\u683c\u5982\u4f55\u53d6\u6d88\u5b8f", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u5206\u7c7b\u600e\u4e48\u64cd\u4f5c\u6b65\u9aa4", "Excel\u8868\u683c\u600e\u4e48\u6bd4\u8f83\u4e24\u4e2a\u8868\u683c\u7684\u4e0d\u540c\u4e4b\u5904", "Excel\u8868\u683c\u600e\u4e48\u81ea\u52a8\u751f\u6210\u65e5\u671f", "Excel\u8868\u683c\u6253\u5370\u600e\u4e48\u8bbe\u7f6e\u6210\u4e00\u5f20\u7eb8", "Excel\u8868\u683c\u7684\u6c42\u548c\u516c\u5f0f", "Excel\u8868\u683c\u7a7a\u767d\u9875\u6570\u592a\u591a\u600e\u6837\u5220\u9664", "Excel\u8868\u683c\u91cc\u6253\u52fe", "Excel\u6848\u4f8b" ] }, { "id": "https://www.6erp.cn/?p=78154", "url": "https://www.6erp.cn/article_78154.html", "title": "Excel\u6c42\u548c \u7528 TEXTJOIN + EVALUATE \u6784\u5efa\u516c\u5f0f", "content_html": "\u5728\u65e5\u5e38\u4f7f\u7528Excel\u65f6\uff0c\u6c42\u548c\u662f\u4e00\u4e2a\u6700\u57fa\u7840\u4e5f\u6700\u5e38\u89c1\u7684\u64cd\u4f5c\uff0c\u800c\u5728\u590d\u6742\u7684\u6570\u636e\u5904\u7406\u6216\u516c\u5f0f\u4e2d\uff0c\u5982\u4f55\u66f4\u52a0\u7075\u6d3b\u3001\u7cbe\u786e\u5730\u8fdb\u884c\u6c42 […]", "content_text": "\u5728\u65e5\u5e38\u4f7f\u7528Excel\u65f6\uff0c\u6c42\u548c\u662f\u4e00\u4e2a\u6700\u57fa\u7840\u4e5f\u6700\u5e38\u89c1\u7684\u64cd\u4f5c\uff0c\u800c\u5728\u590d\u6742\u7684\u6570\u636e\u5904\u7406\u6216\u516c\u5f0f\u4e2d\uff0c\u5982\u4f55\u66f4\u52a0\u7075\u6d3b\u3001\u7cbe\u786e\u5730\u8fdb\u884c\u6c42 […]", "date_published": "2025-06-25T08:10:17+08:00", "date_modified": "2025-06-25T08:10:17+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "arcmap\u5982\u4f55\u5bfc\u51faExcel\u8868\u683c", "Excel\u8868\u683cvlookup\u51fd\u6570\u7684\u4f7f\u7528\u65b9\u6cd5\u53ca\u5b9e\u4f8b", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u597d\u591a\u884c\u90fd\u7f29\u8fdb\u53bb\u4e86", "Excel\u8868\u683c\u5982\u4f55\u4e00\u952e\u590d\u5236\u5230\u5e95", "Excel\u8868\u683c\u5982\u4f55\u5c06\u6a2a\u6392\u53d8\u7ad6\u6392", "Excel\u8868\u683c\u5bf9\u5e94\u4fe1\u606f\u5339\u914d\u516c\u5f0f", "Excel\u8868\u683c\u600e\u4e48\u6bd4\u8f83\u4e24\u4e2a\u8868\u683c\u7684\u4e0d\u540c\u4e4b\u5904", "Excel\u8868\u683c\u8ba1\u7b97\u516c\u5f0f\u52a0\u51cf\u4e58\u9664", "Excel\u8868\u683c\u997c\u56fe\u600e\u4e48\u663e\u793a\u767e\u5206\u6bd4", "Excel\u6a21\u677f" ] }, { "id": "https://www.6erp.cn/?p=78076", "url": "https://www.6erp.cn/article_78076.html", "title": "Excel\u8868\u683c\u600e\u4e48\u7528\u5fae\u8f6f365\u7248\u52a0\u5bc6\u534f\u4f5c\uff1f", "content_html": "\u5728\u6570\u5b57\u5316\u529e\u516c\u548c\u8fdc\u7a0b\u534f\u4f5c\u65e5\u76ca\u666e\u53ca\u7684\u4eca\u5929\uff0cExcel\u8868\u683c\u4f5c\u4e3a\u4e00\u79cd\u91cd\u8981\u7684\u6570\u636e\u5904\u7406\u548c\u8bb0\u5f55\u5de5\u5177\uff0c\u5e7f\u6cdb\u5e94\u7528\u4e8e\u4f01\u4e1a\u3001\u56e2\u961f\u3001\u4ee5 […]", "content_text": "\u5728\u6570\u5b57\u5316\u529e\u516c\u548c\u8fdc\u7a0b\u534f\u4f5c\u65e5\u76ca\u666e\u53ca\u7684\u4eca\u5929\uff0cExcel\u8868\u683c\u4f5c\u4e3a\u4e00\u79cd\u91cd\u8981\u7684\u6570\u636e\u5904\u7406\u548c\u8bb0\u5f55\u5de5\u5177\uff0c\u5e7f\u6cdb\u5e94\u7528\u4e8e\u4f01\u4e1a\u3001\u56e2\u961f\u3001\u4ee5 […]", "date_published": "2025-06-24T08:49:06+08:00", "date_modified": "2025-06-24T08:49:06+08:00", "authors": [ { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" } ], "author": { "name": "tongshang2023", "url": "https://www.6erp.cn/article_author/tongshang2023", "avatar": "https://gravatar.loli.net/avatar/c21223269de33a21f9fe247e64e9d4fb" }, "tags": [ "Excel\u8868\u6253\u5370\u5982\u4f55\u6bcf\u9875\u90fd\u6709\u8868\u5934", "Excel\u8868\u683c\u4e00\u952e\u7f8e\u5316", "Excel\u8868\u683c\u51fa\u751f\u5e74\u6708\u600e\u4e48\u7b97\u5e74\u9f84", "Excel\u8868\u683c\u5408\u5e76\u5feb\u6377\u952e", "Excel\u8868\u683c\u5927\u5c0f\u5199\u600e\u4e48\u8f6c\u6362", "Excel\u8868\u683c\u600e\u4e48\u8bbe\u7f6e\u9009\u9879\u5185\u5bb9", "Excel\u8868\u683c\u600e\u4e48\u9009\u51fa\u91cd\u590d\u9879", "Excel\u8868\u683c\u600e\u6837\u8bbe\u7f6e\u6bcf\u9875\u90fd\u6709\u8868\u5934", "Excel\u8868\u683c\u6761\u4ef6\u7b5b\u9009", "Excel\u8868\u683c\u7f16\u8f91\u53d7\u9650\u600e\u4e48\u89e3\u9664", "Excel\u6a21\u677f" ] } ] }