{"id":692,"date":"2024-02-04T14:26:42","date_gmt":"2024-02-04T06:26:42","guid":{"rendered":"https:\/\/live-d365fo.pantheonsite.io\/?p=692"},"modified":"2024-02-04T15:23:39","modified_gmt":"2024-02-04T07:23:39","slug":"how-to-export-to-excel-in-d365fo","status":"publish","type":"post","link":"https:\/\/live-d365fo.pantheonsite.io\/how-to-export-to-excel-in-d365fo\/","title":{"rendered":"\u5982\u4f55\u5728D365FO\u5bfc\u51faExcel\u6587\u4ef6(How to export to EXCEL using X++ in D365 FO)"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">\u6b65\u9aa4<\/h2>\n\n\n\n<p>\u521b\u5efa\u4e00\u4e2aJob<\/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\/202402021727251.png\" alt=\"Create and Export excel files in d365 using xpp d365snippets\" title=\"Create and Export excel files in d365 using xpp d365snippets\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\u6dfb\u52a0\u4ee5\u4e0b\u4ee3\u7801<strong><a href=\"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEjPYICr4zNREVOL2-sJnOkTXCL-VUQxt3DaL20FG6sofNlNnQ58RE3TJEXNw-jXT4Jut_dMlm7Xtp-lBB6-FawfyQRAPx4zqJPwhAkT8zQUQdf1EgeW26eEmOxbm2E2kXuUpXAYwRL8zZX0x3TGCLbztc-tdBkdi40blszXbBna0YT_whx0gBzGY19b=s875\"><\/a><\/strong><\/p>\n\n\n\n<pre lang=\"python\">\nclass RunnableClass2\n{\n    public static void main(Args _args)\n    {\n        CustTable custTable;\n        DocuFileSaveResult saveResult =\n    DocuFileSave::promptForSaveLocation(\"@ApplicationPlatform:OfficeDefaultWorkbookFileName\",\"xlsx\", null, \"excel create and export\");\n        if (saveResult&& saveResult.parmAction() != DocuFileSaveAction::Cancel)\n        {\n            saveResult.parmOpenParameters('web=1');\n            saveResult.parmOpenInNewWindow(false);\n            System.IO.Stream\n      workbookStream = new System.IO.MemoryStream();\n            System.IO.MemoryStream\n      memoryStream = new System.IO.MemoryStream();\n            using(var package = new OfficeOpenXml.ExcelPackage(memoryStream))\n            {\n                var worksheets = package.get_Workbook().get_Worksheets();\n                var worksheet = worksheets.Add(\"Sheet1\");\n                var cells = worksheet.get_Cells();\n                var currentRow=1 ;\n                \/*-------HEADER PART -------*\/\n                var cell = cells.get_Item(currentRow,1);\n                cell.set_Value(\"Customer Name\");\n                cell=null;\n                cell = cells.get_Item(currentRow,2);\n                cell.set_Value(\"Customer Address\");\n                \/*-------HEADER PART END-------*\/\n                \/*-------RECORD 1-------*\/\n                currentRow=2;\n                cell= cells.get_Item(currentRow, 1);\n                cell.set_Value(\"ABCD Trading\");\n                cell= null;\n                cell= cells.get_Item(currentRow, 2);\n                cell.set_Value(\"ABCD Complex, P.O Box :xxxxxx, XYZ Street\");\n                \/*-------RECORD 1 END-------*\/\n                \/*-------RECORD 2-------*\/\n                currentRow=3;\n                cell= cells.get_Item(currentRow, 1);\n                cell.set_Value(\"XYZ Trading\");\n                cell = null;\n                cell = cells.get_Item(currentRow, 2);\n                cell.set_Value(\"XYZ Complex, P.O Box :xxxxxx, ABC Street\");\n                \/*-------RECORD 2 END-------*\/\n                package.Save();\n            }\n            memoryStream.Seek(0,System.IO.SeekOrigin::Begin);\n            \/\/Download the file.\n            DocuFileSave::processSaveResult(memoryStream,saveResult);\n        }\n    }\n}\n<\/pre>\n\n\n\n<p>\u628a\u8fd9\u4e2aJob\u8bbe\u7f6e\u4e3a\u542f\u52a8\u9879\uff0c\u8fd0\u884c\u5b83\u540e\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u4ee5\u4e0b\u754c\u9762\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\/202402021728637.png\" alt=\"Create and Export excel files in d365 using xpp d365snippets2\" title=\"Create and Export excel files in d365 using xpp d365snippets2\"\/><\/figure>\n\n\n\n<p><\/p>\n\n\n\n<p>\u70b9\u51fb\u4e0b\u8f7d\u6309\u94ae\uff0cExcel\u5c31\u4f1a\u88ab\u5bfc\u51fa\u5230\u4e0b\u8f7d\u6587\u4ef6\u5939\u91cc\u9762<a href=\"https:\/\/blogger.googleusercontent.com\/img\/a\/AVvXsEjv1oLp5NiDJuJ7A0x2OcpB692JXKDuPtJWMl_MhKaCRobCUGgQ7aPwDCq3uqfK-eOTXTMEt8s96xN2NzUOjWZFYpKCIz2E87TNlp0qFEnW8Pyq_5Z2NdjKnsIXHQy15lnEd6kKGBaE67aMqPKULJ3urHsZty2SRjurxrefjD2YLAP_w7kHvp9mqbT_=s1113\"><\/a><\/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\/202402021728711.png\" alt=\"Create and Export excel files in d365 using xpp d365snippets2\" title=\"Create and Export excel files in d365 using xpp d365snippets2\"\/><\/figure>\n\n\n\n<p>\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:\/\/live-d365fo.pantheonsite.io\/how-to-import-excel-in-d365fo\/\" class=\"vlp-link\" title=\"\u5982\u4f55\u5728D365FO\u5bfc\u5165Excel\u6587\u4ef6(How to import 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\u5165Excel\u6587\u4ef6(How to import EXCEL using X++ in D365 FO) \u00bb Microsoft Dynamics AX\/365 FO Developer`s Blog<\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>\u6b65\u9aa4 \u521b\u5efa\u4e00\u4e2aJob \u6dfb\u52a0\u4ee5\u4e0b\u4ee3\u7801 class RunnableClass2 { public static void main(Args _args) { CustTable custTable; DocuFileSaveResult saveResult = DocuFileSave::promptForSaveLocation(&#8220;@ApplicationPlatform:OfficeDefaultWorkbookFileName&#8221;,&#8221;xlsx&#8221;, null, &#8220;excel create and export&#8221;); if (saveResult&#038;&#038; saveResult.parmAction() != DocuFileSaveAction::Cancel) { saveResult.parmOpenParameters(&#8216;web=1&#8217;); saveResult.parmOpenInNewWindow(false); System.IO.Stream workbookStream = new System.IO.MemoryStream(); System.IO.MemoryStream memoryStream = new System.IO.MemoryStream(); using(var package = new OfficeOpenXml.ExcelPackage(memoryStream)) { var worksheets = package.get_Workbook().get_Worksheets(); var worksheet = worksheets.Add(&#8220;Sheet1&#8221;); &#8230;<\/p>\n<p><a href=\"https:\/\/live-d365fo.pantheonsite.io\/how-to-export-to-excel-in-d365fo\/\" class=\"more-link\">Continue reading &lsquo;\u5982\u4f55\u5728D365FO\u5bfc\u51faExcel\u6587\u4ef6(How to export to 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:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/692"}],"collection":[{"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/comments?post=692"}],"version-history":[{"count":10,"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/692\/revisions"}],"predecessor-version":[{"id":742,"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/posts\/692\/revisions\/742"}],"wp:attachment":[{"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/media?parent=692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/categories?post=692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/live-d365fo.pantheonsite.io\/wp-json\/wp\/v2\/tags?post=692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}