{"id":706,"date":"2024-02-04T15:18:16","date_gmt":"2024-02-04T07:18:16","guid":{"rendered":"https:\/\/live-d365fo.pantheonsite.io\/?p=706"},"modified":"2024-07-19T17:39:14","modified_gmt":"2024-07-19T09:39:14","slug":"how-to-import-excel-in-d365fo","status":"publish","type":"post","link":"https:\/\/dev-d365fo.pantheonsite.io\/how-to-import-excel-in-d365fo\/","title":{"rendered":"\u5982\u4f55\u5728D365FO\u5bfc\u5165Excel\u6587\u4ef6(How to import EXCEL using X++ in D365 FO)"},"content":{"rendered":"\n<h1 class=\"wp-block-heading\"><strong>\u5f00\u59cb\u4e4b\u524d\u7684\u51c6\u5907<\/strong><\/h1>\n\n\n\n<ul>\n<li>\u547d\u540d\u7a7a\u95f4<\/li>\n\n\n\n<li>\u53c2\u8003\u5305\uff08reference packages\uff09<\/li>\n<\/ul>\n\n\n\n<pre lang=\"python\">\nUsing System.IO;\nUsing OfficeOpenXml;\nUsing OfficeOpenXml.ExcelPackage;\nUsing OfficeOpenXml.ExcelRange;\n<\/pre>\n\n\n\n<p>\u9664\u4e86\u57fa\u672c\u7684\u5305\uff0c\u6211\u4eec\u8fd8\u9700\u8981\u53c2\u8003\u5305:<strong>Directory<\/strong><\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202402041431593.png\" alt=\"How to Import Records from Excel Using X++ Code in D365FO\" title=\"How to Import Records from Excel Using X++ Code in D365FO\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u7b2c\u4e00\u90e8\u5206\u4ee3\u7801<\/h2>\n\n\n\n<p>\u5728\u8fd9\u90e8\u5206\u4ee3\u7801\u4e2d\uff0c\u521b\u5efa\u4e86\u4e00\u4e2a\u5bfc\u5165\u5bf9\u8bdd\u6846\uff0c\u5728\u8fd9\u91cc\u6211\u4eec\u53ef\u4ee5\u9009\u62e9\u9700\u8981\u5bfc\u5165\u7684\u6587\u4ef6\uff0c\u6587\u4ef6\u4e0a\u4f20\u4e4b\u540e\u4f1a\u88ab\u5b58\u50a8\u5728\u4e34\u65f6\u7684\u7a7a\u95f4\u4e2d<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202402041434002.png\" alt=\"How to Import Records from Excel Using X++ Code in D365FO\" title=\"How to Import Records from Excel Using X++ Code in D365FO\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEit0tCC4xqKpD7KPQF9NGoBh_wiL5k-rmShYDHB7XpmcKYfKyEJdbzG5OCUUBwq0C93r_iqgKgB1YttARTyq6aC0qA5EeHDGXoMoidSFALlq6xYMzSjaxbGQdXJWVUYuNbJgYn4JL2fM_U5HmcxHVpXUkUNMbJu75GGgKfvCAgHRKzxuG5aOUhkbGjq=s1001\"><\/a>\u7b2c\u4e8c\u90e8\u5206\u4ee3\u7801<\/h2>\n\n\n\n<p>\u5728\u8fd9\u90e8\u5206\u4ee3\u7801\u4e2d\uff0c\u6211\u4eec\u4ece\u5bfc\u5165\u7684Excel\u4e2d\u83b7\u53d6\u6570\u636e<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202402041435201.png\" alt=\"How to Import Records from Excel Using X++ Code in D365FO\" title=\"How to Import Records from Excel Using X++ Code in D365FO\"\/><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\">\u5b8c\u6574\u7684\u4ee3\u7801<a href=\"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEiOCrX7wzMIduwzbPMuwbDCY8jKrpyyoAHJcoI6Qvzi7w2kd5A_WhkjcP31Xt0oqKcz9QuYSLHaGS_EdQYkPsdgeZpParEcLJBwDZqs2ukqPSYwFtGpn2nQcjt5MHvR6tT_aq-AGlnVDjPPPPobqmXo-TRRK7j7P0WucaO2cJMWNayyRF-ShfbsLssg=s1004\"><\/a><\/h2>\n\n\n\n<pre lang=\"python\">\nUsing System.IO;\nUsing OfficeOpenXml;\nUsing OfficeOpenXml.ExcelPackage;\nUsing OfficeOpenXml.ExcelRange;\nclass RunnableClass1\n{\n    \/\/\/ <summary>\n    \/\/\/ Runs the class with the specified arguments.\n    \/\/\/ <\/summary>\n    \/\/\/ <param name = \"_args\">The specified arguments.<\/param>\n    public static void main(Args _args)\n    {\n        \/*---------part 1 ------------------*\/\n        System.IO.Stream stream;\n        ExcelSpreadsheetName sheet;\n        FileUploadBuild fileUpload,fileUploadBuild;\n        DialogGroup dialogUploadGroup;\n        FormBuildControl formBuildControl;\n        Dialog dialog=new Dialog(\"Excel Import Example\");\n        dialogUploadGroup=dialog.addGroup(\"@SYS54759\");\n        formBuildControl=dialog.formBuildDesign().control(dialogUploadGroup.name());\n        fileUploadBuild=formBuildControl.addControlEx(classStr(fileUpload),\"UploadExcel\");\n        fileUploadBuild.style(FileUploadStyle::MinimalWithFilename);\n        fileUploadBuild.fileTypesAccepted(\".xlsx\");\n        if(dialog.run() && dialog.closedOk())\n        {\n            FileUpload fileUploadControl=dialog.formRun().control(dialog.formRun().controlId(\"Upload\"));\n            FileUploadTemporaryStorageResult\n            fileUploadResult=file::GetFileFromUser(classStr(FileUploadTemporaryStorageStrategy));\n            \/\/fileUploadResult=fileUploadControl.getFileUploadResult();\n            \/*------------------part 1 end---------------------*\/\n            \/*------------------part 2---------------------*\/\n            if(fileUploadResult!= null && fileUploadResult.getUploadStatus())\n            {\n                stream=fileUploadResult.openResult();\n                using(ExcelPackage  package= new ExcelPackage(stream))\n                {\n                    int rowCount, iterator;\n                    package.Load(stream);\n                    ExcelWorksheet worksheet= package.get_workbook().get_worksheets().get_Item(1);\n                    OfficeOpenXml.ExcelRange range=worksheet.Cells;              \n                    rowCount = worksheet.Dimension.End.Row - worksheet.Dimension.Start.Row + 1;\n                    for(iterator=2;iterator<=rowCount;iterator++)\n                    {\n                        Info(range.get_Item(iterator,1).Value);\n                        Info(range.get_Item(iterator,2).Value);\n                        Info(range.get_Item(iterator,3).Value);\n                    }\n                }\n            }\n            \/*------------------part 2 end---------------------*\/\n        }\n        else\n        {\n            Error(\"error occured.\");\n        }\n    }\n}\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">\u5bfc\u5165<\/h2>\n\n\n\n<p>\u8fd0\u884c\u4e0a\u9762\u7684Job\u4e4b\u540e\uff0c\u7cfb\u7edf\u4f1a\u5f39\u51fa\u5bfc\u5165\u5bf9\u8bdd\u6846\uff0c\u7136\u540e\u9009\u62e9\u4e0b\u9762\u7684\u6587\u4ef6\u3002<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202402041435842.png\" alt=\"How to Import Records from Excel Using X++ Code in D365FO\" title=\"How to Import Records from Excel Using X++ Code in D365FO\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202402041435513.png\" alt=\"How to Import Records from Excel Using X++ Code in D365FO\" title=\"How to Import Records from Excel Using X++ Code in D365FO\"\/><\/figure>\n\n\n\n<figure class=\"wp-block-image size-large\"><a href=\"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEj9E6p-hGX8nKK80mGHesnNFHdPsZ3BDTjuPSZwwIR1wvadT6dIhm71OulxM48Y3y6DyHEVH7SxLrDgNXPYKokbyGo27sqCa4KriJ4cdT1NtQUT8RwwpEXyjZZaFsMG5Ix0XcDeoNTS8ihz2snT0WDPQR_v9IyEoqAySZfEYEf8su2vwpyhbrLFQVRF=s1114\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202402041435385.png\" alt=\"How to Import Records from Excel Using X++ Code in D365FO\" title=\"How to Import Records from Excel Using X++ Code in D365FO\"\/><\/a><\/figure>\n\n\n\n<p>\u4ee5\u4e0b\u662f\u70b9\u51fb\u201cOK\u201d\u4e4b\u540e\u7684\u7ed3\u679c\uff1a<\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" src=\"https:\/\/nashome-image-bucket.oss-cn-shanghai.aliyuncs.com\/PicGo\/202402041436676.png\" alt=\"How to Import Records from Excel Using X++ Code in D365FO\" title=\"How to Import Records from Excel Using X++ Code in D365FO\"\/><\/figure>\n\n\n\n<p><a href=\"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEiAKdieKUX4GQdIWSDIyjbU9OCi1h1l7FAAkG7ldoRIrGGM_-L4q4JieKiWRZS46zgBDHEEU3I8CoUMLbYiL4rjcYC5406wWa1p7b_wFoGzDIhGOE3L6ciSJaSJszTU0TggnnaT8Z17npkaPrFkns-x6iIN8d_WduiwkY8ks-QUIDCS1bBP72sj7wWJ=s1114\"><\/a>\u5173\u4e8eExcel\u5bfc\u51fa\u529f\u80fd\uff0c\u8bf7\u53c2\u8003\u4e00\u4e0b\u94fe\u63a5\uff1a<\/p>\n\n\n<div class=\"vlp-link-container vlp-layout-compact-copy wp-block-visual-link-preview-link\"><a href=\"https:\/\/dev-d365fo.pantheonsite.io\/how-to-export-to-excel-in-d365fo\/\" class=\"vlp-link\" title=\"\u5982\u4f55\u5728D365FO\u5bfc\u51faExcel\u6587\u4ef6(How to export to EXCEL using X++ in D365 FO) \u00bb Microsoft Dynamics AX\/365 FO Developer`s Blog\" rel=\"nofollow\" target=\"_blank\"><\/a><div class=\"vlp-layout-zone-main\"><div class=\"vlp-block-0 vlp-link-title\">\u5982\u4f55\u5728D365FO\u5bfc\u51faExcel\u6587\u4ef6(How to export to EXCEL using X++ in D365 FO) \u00bb Microsoft Dynamics AX\/365 FO Developer`s Blog<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>\u5f00\u59cb\u4e4b\u524d\u7684\u51c6\u5907 Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange; \u9664\u4e86\u57fa\u672c\u7684\u5305\uff0c\u6211\u4eec\u8fd8\u9700\u8981\u53c2\u8003\u5305:Directory \u7b2c\u4e00\u90e8\u5206\u4ee3\u7801 \u5728\u8fd9\u90e8\u5206\u4ee3\u7801\u4e2d\uff0c\u521b\u5efa\u4e86\u4e00\u4e2a\u5bfc\u5165\u5bf9\u8bdd\u6846\uff0c\u5728\u8fd9\u91cc\u6211\u4eec\u53ef\u4ee5\u9009\u62e9\u9700\u8981\u5bfc\u5165\u7684\u6587\u4ef6\uff0c\u6587\u4ef6\u4e0a\u4f20\u4e4b\u540e\u4f1a\u88ab\u5b58\u50a8\u5728\u4e34\u65f6\u7684\u7a7a\u95f4\u4e2d \u7b2c\u4e8c\u90e8\u5206\u4ee3\u7801 \u5728\u8fd9\u90e8\u5206\u4ee3\u7801\u4e2d\uff0c\u6211\u4eec\u4ece\u5bfc\u5165\u7684Excel\u4e2d\u83b7\u53d6\u6570\u636e \u5b8c\u6574\u7684\u4ee3\u7801 Using System.IO; Using OfficeOpenXml; Using OfficeOpenXml.ExcelPackage; Using OfficeOpenXml.ExcelRange; class RunnableClass1 { \/\/\/ \/\/\/ Runs the class with the specified arguments. \/\/\/ \/\/\/ The specified arguments. public static void main(Args _args) { \/*&#8212;&#8212;&#8212;part 1 &#8212;&#8212;&#8212;&#8212;&#8212;&#8212;*\/ System.IO.Stream stream; ExcelSpreadsheetName sheet; FileUploadBuild fileUpload,fileUploadBuild; &#8230;<\/p>\n<p><a href=\"https:\/\/dev-d365fo.pantheonsite.io\/how-to-import-excel-in-d365fo\/\" class=\"more-link\">Continue reading &lsquo;\u5982\u4f55\u5728D365FO\u5bfc\u5165Excel\u6587\u4ef6(How to import EXCEL using X++ in D365 FO)&rsquo; &raquo;<\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[42,10],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/706"}],"collection":[{"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/comments?post=706"}],"version-history":[{"count":24,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/706\/revisions"}],"predecessor-version":[{"id":791,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/706\/revisions\/791"}],"wp:attachment":[{"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/media?parent=706"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/categories?post=706"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/tags?post=706"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}