{"id":730,"date":"2017-01-07T19:02:01","date_gmt":"2017-01-07T19:02:01","guid":{"rendered":"http:\/\/marco-krapf.de\/?page_id=730"},"modified":"2018-10-14T21:38:58","modified_gmt":"2018-10-14T19:38:58","slug":"add-in-xl-export","status":"publish","type":"page","link":"https:\/\/marco-krapf.de\/gb\/add-in-xl-export\/","title":{"rendered":"XL export"},"content":{"rendered":"


\nFree open source tool for exporting worksheet content to a text or CSV file with lots of special features – Excel 2007-2019 (Windows optimized)<\/p>\n

 <\/p>\n\n\n\n\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t\n\t
File name<\/td>XL_export_v1-0.xlam<\/td>\n<\/tr>\n
Excel versions<\/td>2010 or later (Windows)<\/td>\n<\/tr>\n
Interface languages<\/td>German, English<\/td>\n<\/tr>\n
Where is the add-in after activation?<\/td>\"Data\" tab, next to the \"Data tools\" group<\/td>\n<\/tr>\n
File size<\/td>180 KB<\/td>\n<\/tr>\n
Lines of code (total)<\/td>1226<\/td>\n<\/tr>\n
Source lines of code<\/td>923<\/td>\n<\/tr>\n
Comment lines of code<\/td>122<\/td>\n<\/tr>\n
Blank lines<\/td>181<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n

Source code
\n<\/strong>The source code is published on GitHub<\/a> and can also be opened in the VBA editor.<\/p>\n

Installation<\/strong>
\nThe tool is shipped as an add-in for Microsoft Excel (.xlam). After installation and activation<\/a> the tool\u00b4s icon is added on the “Data” tab next to the “Data tools” group.<\/p>\n

Download version 1.0<\/strong> \u2013 it\u00b4s free!<\/span><\/h1>\n

Automatic installation (recommended for Windows)
\n\n\tXL export\t(7323 downloads\t)\n<\/a>\n<\/h3>\n

Manual installation
\n\n\tXL export\t(7092 downloads\t)\n<\/a>\n<\/h3>\n

Features<\/strong>
\n– Choice of the area to be exported
\n– Export as text file, CSV or custom file type
\n– Free choice of delimiter
\n– Delimiter at the end of a row can be deleted
\n– Unnecessary spaces can be deleted
\n– Control characters can be deleted
\n– Conversion to upper-case or lower-case letters possible
\n– Preview of the export file
\n– Automatically saving the tool settings<\/p>\n

Screenshots<\/strong><\/p>\nngg_shortcode_0_placeholder\n

Donation<\/strong>
\nThis add-in is being developed and maintained with private effort and provided for free download. I would be very happy about a small donation<\/strong><\/span> to this foundation for sick children in the region of Heilbronn\/Germany. Read more on the website of the foundation<\/a>.<\/p>\n

\"Website<\/a><\/p>\n

Donate now!<\/a><\/h1>\n","protected":false},"excerpt":{"rendered":"

Free open source tool for exporting worksheet content to a text or CSV file with lots of special features – Excel 2007-2019 (Windows optimized)   Source code The source code is published on GitHub and can also be opened in the VBA editor. Installation The tool is shipped as an add-in for Microsoft Excel (.xlam). […]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"ngg_post_thumbnail":0,"footnotes":""},"class_list":["post-730","page","type-page","status-publish","hentry"],"translation":{"provider":"WPGlobus","version":"3.0.2","language":"gb","enabled_languages":["de","gb"],"languages":{"de":{"title":true,"content":true,"excerpt":false},"gb":{"title":false,"content":true,"excerpt":false}}},"_links":{"self":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/730","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/comments?post=730"}],"version-history":[{"count":38,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/730\/revisions"}],"predecessor-version":[{"id":818,"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/pages\/730\/revisions\/818"}],"wp:attachment":[{"href":"https:\/\/marco-krapf.de\/gb\/wp-json\/wp\/v2\/media?parent=730"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}