{"id":12,"date":"2022-03-14T09:08:07","date_gmt":"2022-03-14T09:08:07","guid":{"rendered":"https:\/\/kadence.pixel-show.com\/blog-affiliate\/?p=12"},"modified":"2023-08-21T01:16:55","modified_gmt":"2023-08-20T16:16:55","slug":"habits-how-to-form-better-habits-and-break-bad-ones","status":"publish","type":"post","link":"http:\/\/www.charleskwon.com\/?p=12","title":{"rendered":"How to make XLSX File with Harbour"},"content":{"rendered":"\n

There are various ways to create xlsx files using tools like Harbour or Fivewin. However, some methods require the use of specific DLLs or ADO.<\/p>\n\n\n\n

In my case, I prefer not to distribute many auxiliary files. Moreover, when using ADO, there are numerous unknown issues depending on the client environment. This can lead to unforeseen compatibility problems when dealing with a wide range of users.<\/p>\n\n\n\n

How was the above issue resolved?<\/h2>\n\n\n\n
<\/div>\n\n\n\n
    \n
  1. I hardforked the source of libxlsxwriter. <\/li>\n\n\n\n
  2. libxlsxwriter is under the FreeBSD license, allowing freedom to modify, adapt, and distribute without the need to disclose the modified source code. <\/li>\n\n\n\n
  3. I adapted libxlsxwriter for both Harbour 32-bit and 64-bit environments and bound it as a library. ( DrXlsx32.lib and DrXlsx64.lib, no need libxlsxwriter.dll )<\/li>\n\n\n\n
  4. I removed all external dependencies of libxlsxwriter and replaced them with substitute code, eliminating the need for any DLLs.I removed all external dependencies of libxlsxwriter and replaced them with substitute code, eliminating the need for any DLLs.<\/li>\n\n\n\n
  5. To make it user-friendly, I created the TDrXlsx CLASS.<\/li>\n<\/ol>\n\n\n\n

    Hello world!<\/h2>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    FUNCTION <\/span>Main<\/span>()<\/span><\/span>\n    LOCAL oXlsx :<\/span>=<\/span> <\/span>TDrXlsx<\/span>()<\/span>:<\/span>New<\/span>()<\/span><\/span>\n    <\/span><\/span>\n    oXlsx:<\/span>CreateFile<\/span>(<\/span>"<\/span>test.xlsx<\/span>"<\/span>)<\/span><\/span>\n    oXlsx:<\/span>WriteString<\/span>(<\/span>0<\/span>,<\/span>0<\/span>,<\/span>"<\/span>\uc548\ub155\ud558\uc138\uc694<\/span>"<\/span>)<\/span><\/span>\n    oXlsx:<\/span>WriteString<\/span>(<\/span>1<\/span>,<\/span>0<\/span>,<\/span>"<\/span>Hello World!<\/span>"<\/span>)<\/span><\/span>\n    oXlsx:<\/span>Close<\/span>()<\/span><\/span>\n    <\/span><\/span>\nRETURN NIL  <\/span><\/span><\/code><\/pre><\/div>\n\n\n\n
    \n
    <\/p>\nby Charles KWON<\/span><\/strong><\/cite><\/blockquote>\n\n\n\n
    \"\"<\/figure>\n","protected":false},"excerpt":{"rendered":"
    There are various ways to create xlsx files using tools like Harbour or Fivewin. However, some methods require…<\/p>\n","protected":false},"author":1,"featured_media":906,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_kad_blocks_custom_css":"","_kad_blocks_head_custom_js":"","_kad_blocks_body_custom_js":"","_kad_blocks_footer_custom_js":"","_kadence_starter_templates_imported_post":true,"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-12","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technique-productivity"],"taxonomy_info":{"category":[{"value":4,"label":"Technique"}]},"featured_image_src_large":["http:\/\/www.charleskwon.com\/wp-content\/uploads\/2023\/08\/image-5.png",496,465,false],"author_info":{"display_name":"CharlesKWON","author_link":"http:\/\/www.charleskwon.com\/?author=1"},"comment_info":0,"category_info":[{"term_id":4,"name":"Technique","slug":"technique-productivity","term_group":0,"term_taxonomy_id":4,"taxonomy":"category","description":"","parent":0,"count":8,"filter":"raw","cat_ID":4,"category_count":8,"category_description":"","cat_name":"Technique","category_nicename":"technique-productivity","category_parent":0}],"tag_info":false,"_links":{"self":[{"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/posts\/12","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=12"}],"version-history":[{"count":18,"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/posts\/12\/revisions"}],"predecessor-version":[{"id":953,"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/posts\/12\/revisions\/953"}],"wp:featuredmedia":[{"embeddable":true,"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/media\/906"}],"wp:attachment":[{"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=12"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=12"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.charleskwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=12"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}