{"id":54532,"date":"2020-04-15T17:05:51","date_gmt":"2020-04-15T15:05:51","guid":{"rendered":"https:\/\/ar3dp.de\/docs\/3d-druckkosten-kalkulator\/export\/exportieren-als-excel-datei\/"},"modified":"2020-04-15T17:05:51","modified_gmt":"2020-04-15T15:05:51","slug":"exportieren-als-excel-datei","status":"publish","type":"docs","link":"https:\/\/ar3dp.de\/en\/docs\/3d-druckkosten-kalkulator\/export\/exportieren-als-excel-datei\/","title":{"rendered":"Export as an Excel file"},"content":{"rendered":"<div id=\"whatWeDoSection\" class=\"container space-2\"><div class=\"row\"><div class=\"col-md-6 mb-7 mb-md-9\"><div class=\"media\"><div class=\"d-flex mr-3\"><span class=\"btn btn-icon rounded-circle mr-3 btn-soft-primary\"><span class=\"far fa-file-code btn-icon__inner\"><\/span><\/span><\/div><div class=\"media-body\"><h4 class=\"fgb-icon-blocks-la__name d-block h6 text-secondary font-weight-normal mb-0\">Available from<\/h4><span class=\"d-block font-size-1\">v0.0.9-beta<\/span><\/div><\/div><\/div> <div class=\"col-md-6 mb-7 mb-md-9\"><div class=\"media\"><div class=\"d-flex mr-3\"><span class=\"btn btn-icon rounded-circle mr-3 btn-soft-primary\"><span class=\"fab fa-bandcamp btn-icon__inner\"><\/span><\/span><\/div><div class=\"media-body\"><h4 class=\"fgb-icon-blocks-la__name d-block h6 text-secondary font-weight-normal mb-0\">Only in Pro version?<\/h4><span class=\"d-block font-size-1\">Yes<\/span><\/div><\/div><\/div> <\/div><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Export as an Excel file<\/h2>\n\n\n\n<h3 class=\"wp-block-heading\">Single calculation<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to export the information to an Excel file or write it into an Excel template, simply click on the \u201cExport as Excel file\u201d next to the calculation to be exported.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1450\" height=\"720\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_1.png\" alt=\"\" class=\"wp-image-54676\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_1.png 1450w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_1-768x381.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_1-380x189.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_1-350x175.png 350w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_1-590x293.png 590w\" sizes=\"(max-width: 1450px) 100vw, 1450px\" \/><figcaption>Export of a single calculation as an Excel file<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">You will then be asked to assign a file name for your Excel file.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"946\" height=\"533\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_2.png\" alt=\"\" class=\"wp-image-54677\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_2.png 946w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_2-768x433.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_2-380x214.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_2-590x332.png 590w\" sizes=\"(max-width: 946px) 100vw, 946px\" \/><figcaption>Name of the Excel file<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">If everything worked, you will get the following message from the tool.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"772\" height=\"166\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_3.png\" alt=\"\" class=\"wp-image-54678\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_3.png 772w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_3-768x165.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_3-380x82.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_3-590x127.png 590w\" sizes=\"(max-width: 772px) 100vw, 772px\" \/><figcaption>Export successful<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The standard export for Excel files currently contains the following information:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Printer<\/li><li>Material<\/li><li>Project name<\/li><li>Volume of the extruded filament<\/li><li>Quantity<\/li><li>Printing time<\/li><li>Printing costs<\/li><li>Material costs<\/li><li>Energy costs<\/li><li>Work steps<\/li><li>Handling fee<\/li><li>Profit <\/li><li>Taxes<\/li><\/ul>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"931\" height=\"137\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_4.png\" alt=\"\" class=\"wp-image-54679\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_4.png 931w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_4-768x113.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_4-380x56.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_4-590x87.png 590w\" sizes=\"(max-width: 931px) 100vw, 931px\" \/><figcaption>Information from the standard export<\/figcaption><\/figure><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Multiple calculations<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">If you want to export several calculations as a list into an Excel file, you have to mark the desired calculations and click on the \u201cExport as Excel file\u201d button.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1450\" height=\"720\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_5.png\" alt=\"\" class=\"wp-image-54680\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_5.png 1450w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_5-768x381.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_5-380x189.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_5-350x175.png 350w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_5-590x293.png 590w\" sizes=\"(max-width: 1450px) 100vw, 1450px\" \/><figcaption>Selection of several calculations in the extended view<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">After assigning a file name, the export result looks like this.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"938\" height=\"167\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_6.png\" alt=\"\" class=\"wp-image-54681\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_6.png 938w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_6-768x137.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_6-380x68.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/04\/3dpcc_en_calculations_file_excel_6-590x105.png 590w\" sizes=\"(max-width: 938px) 100vw, 938px\" \/><figcaption>Export multiple calculations<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Write in an Excel template<\/h2>\n\n\n\n<p class=\"wp-block-paragraph\">As an alternative to the standard export, you can create and use various Excel templates in the tool. In contrast to a simple list, here you can have specific values written in certain rows and columns. This is particularly suitable for offer and invoice templates.<\/p>\n\n\n\n<div class=\"alert-box alert text-center font-size-1 rounded-0 mb-0 bg-danger\"><span class=\"text\"><span style=\"color:#fff\" class=\"fgb-has-inline-color\"><strong class=\"text-uppercase\">Caution <\/strong> Diese Funktion ist noch in der Testphase. Sollten Probleme auftauchen, meldet diese bitte \u00fcber folgendes\u00a0<a rel=\"noreferrer noopener\" href=\"https:\/\/ar3dp.de\/en\/kontakt\/\" target=\"_blank\">Kontaktformular<\/a>.<\/span><\/span><\/div>\n\n\n\n<h3 class=\"wp-block-heading\">Activate Excel templates<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">In order to be able to use this function, you must first activate the corresponding option in the settings. To do this, go to \u201cExcel export\u201d in the settings and activate the export to an Excel template.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"1450\" height=\"720\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_7.png\" alt=\"\" class=\"wp-image-54684\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_7.png 1450w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_7-768x381.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_7-380x189.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_7-350x175.png 350w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_7-590x293.png 590w\" sizes=\"(max-width: 1450px) 100vw, 1450px\" \/><figcaption>Activate writing in an Excel template<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">A distinction is currently made between two types of templates:<\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>Template for a single calculation<\/li><li>Template for a number of calculations<\/li><\/ul>\n\n\n\n<p class=\"wp-block-paragraph\">By default, you will find one template each as a template. You can either change our standard templates or create your own new templates.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Create a new template<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">To create a new template, prepare your Excel file. This is already required in the creation step. If you have everything at hand, you can create a new template with the \"Create Excel template\" button.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"877\" height=\"371\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_8.png\" alt=\"\" class=\"wp-image-54685\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_8.png 877w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_8-768x325.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_8-380x161.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_8-590x250.png 590w\" sizes=\"(max-width: 877px) 100vw, 877px\" \/><figcaption>Form for creating a new template<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">At the beginning, select your Excel file which you want to use as a template. Please note that the tool does not copy the file, but only saves the path where it can be found. Please do not move the data afterwards, or update the path in your template settings.<\/p>\n\n\n\n<p class=\"wp-block-paragraph\">Furthermore, you have to assign at least one attribute to a coordinate in your Excel file. Simply click on the \"+\" button. This opens another dialog in which you can assign attributes to coordinates in your Excel template. The dialog automatically recognizes your workbooks.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"855\" height=\"281\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/02\/3dpcc_en_export_template_new_2.png\" alt=\"\" class=\"wp-image-52215\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/02\/3dpcc_en_export_template_new_2.png 855w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/02\/3dpcc_en_export_template_new_2-590x194.png 590w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/02\/3dpcc_en_export_template_new_2-768x252.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/02\/3dpcc_en_export_template_new_2-750x246.png 750w\" sizes=\"(max-width: 855px) 100vw, 855px\" \/><figcaption>Assigning an attribute to a coordinate<\/figcaption><\/figure><\/div>\n\n\n\n<div class=\"alert-box alert text-center font-size-1 rounded-0 mb-0 bg-primary\"><span class=\"text\"><span style=\"color:#fff\" class=\"fgb-has-inline-color\">The example shows how the value for the printing costs is inserted at coordinate A: 2 in the \u201cData\u201d workbook.<\/span><\/span><\/div>\n\n\n\n<p class=\"wp-block-paragraph\"><\/p>\n\n\n\n<p class=\"wp-block-paragraph\">You can use attributes as often as you like and thus fill your template. Please note, however, that there are differences between the \u201cSingle\u201d and \u201cList\u201d template types.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"867\" height=\"403\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_9.png\" alt=\"\" class=\"wp-image-54686\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_9.png 867w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_9-768x357.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_9-380x177.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_9-590x274.png 590w\" sizes=\"(max-width: 867px) 100vw, 867px\" \/><figcaption>Save Template<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">Now you can create and save the template. From now on this is available for selection when exporting, provided you activate the export to a template file.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Export of the calculation (s) to an Excel template<\/h3>\n\n\n\n<p class=\"wp-block-paragraph\">Once all settings have been saved, another dialog opens when you click on \u201cExport as Excel file\u201d in your calculations. Depending on whether you choose one or more calculations, either the templates appear with the type \u201cIndividual\u201d or \u201cList\u201d.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"868\" height=\"289\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_10png.png\" alt=\"\" class=\"wp-image-54687\" srcset=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_10png.png 868w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_10png-768x256.png 768w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_10png-380x127.png 380w, https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/05\/3dpcc_en_calculations_file_excel_10png-590x196.png 590w\" sizes=\"(max-width: 868px) 100vw, 868px\" \/><figcaption>Export to a template<\/figcaption><\/figure><\/div>\n\n\n\n<p class=\"wp-block-paragraph\">The Excel export then writes the required information to the specified coordinates.<\/p>\n\n\n\n<div class=\"wp-block-image is-style-default\"><figure class=\"aligncenter size-large\"><img decoding=\"async\" width=\"168\" height=\"143\" src=\"https:\/\/ar3dp.de\/wp-content\/uploads\/2020\/02\/3dpcc_en_export_template_3.png\" alt=\"\" class=\"wp-image-52270\"\/><figcaption>Result<\/figcaption><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\">Third party software used<\/h2>\n\n\n\n<p class=\"wp-block-paragraph translation-block\">For the export as an Excel file, we use the <a rel=\"noreferrer noopener\" href=\"https:\/\/www.syncfusion.com\/excel-framework\/net\" target=\"_self\"> Nuget package from Syncfusion <\/a>. You can find the license directly in the tool under \u201cSettings\u201d and in the \u201cAbout\u201d tab. We are happy to answer any questions you may have.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">Save as a calculation file<\/h2>\n\n\n\n<p class=\"wp-block-paragraph translation-block\">If you want to save your calculations as a calculation file, please have a look at this <a href=\"https:\/\/andreas-reitberger.de\/docs\/3d-druckkosten-kalkulator\/export\/exportieren-als-kalkulations-daten\/\" target=\" _self \"> Instructions <\/a>.<\/p>","protected":false},"excerpt":{"rendered":"<p>Als Excel-Datei exportieren Einzelne Kalkulation Wenn du die Informationen in eine Excel-Datei exportieren, oder in eine Excel-Vorlage schreiben m\u00f6chtest, klicke einfach auf den &#8220;Export als Excel-Datei&#8221; bei der zu exportierenden Kalkulation. Folgend wirst du aufgefordert einen Dateinamen f\u00fcr deine Excel-Datei zu vergeben. Hat alles geklappt, bekommst du folgende Meldung vom Tool. Aktuell enth\u00e4lt der Standard-Export&#8230;<\/p>","protected":false},"author":1,"featured_media":0,"parent":54099,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"_featured":false,"_is_vendor_doc":"0","footnotes":""},"doc_tag":[],"class_list":["post-54532","docs","type-docs","status-publish","hentry"],"comment_count":0,"_links":{"self":[{"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/docs\/54532","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/docs"}],"about":[{"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/types\/docs"}],"author":[{"embeddable":true,"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/comments?post=54532"}],"version-history":[{"count":0,"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/docs\/54532\/revisions"}],"up":[{"embeddable":true,"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/docs\/54099"}],"next":[{"title":"Export as a calculation file","link":"https:\/\/ar3dp.de\/en\/docs\/3d-druckkosten-kalkulator\/export\/exportieren-als-kalkulations-datei\/","href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/docs\/54533"}],"wp:attachment":[{"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/media?parent=54532"}],"wp:term":[{"taxonomy":"doc_tag","embeddable":true,"href":"https:\/\/ar3dp.de\/en\/wp-json\/wp\/v2\/doc_tag?post=54532"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}