{"id":948,"date":"2023-08-21T01:13:09","date_gmt":"2023-08-20T16:13:09","guid":{"rendered":"http:\/\/www.charleskwon.com\/?p=948"},"modified":"2023-08-21T01:24:24","modified_gmt":"2023-08-20T16:24:24","slug":"the-say-is-only-required-for-generating-xlsx-files","status":"publish","type":"post","link":"https:\/\/www.charleskwon.com\/?p=948","title":{"rendered":"The Say() is only required for generating Xlsx files."},"content":{"rendered":"\n

A<\/strong>t last, I’ve achieved the capability to transform all Harbour variables into Xlsx format. However, I’ve gone beyond the limitations of specific variable types and developed a robust feature that allows the creation of Xlsx files using just the say() method.

METHOD Say( nRow, nCol, uVal, nAlign, cFormat )<\/strong> automatically handles all the methods listed below:<\/p>\n\n\n\n

<\/div>\n\n\n\n
    \n
  1.  METHOD WriteString( nRow, nCol, cString, nAlign )<\/li>\n\n\n\n
  2.  METHOD WriteNumber( nRow, nCol, nNumber, nAlign, cFormat )<\/li>\n\n\n\n
  3.  METHOD WriteDate( nRow, nCol, dDate, nAlign, cFormat )    <\/li>\n\n\n\n
  4.  METHOD WriteDatetime( nRow, nCol, dDate, nAlign, cFormat )<\/li>\n\n\n\n
  5.  METHOD WriteLogical(  nRow, nCol, lLogical, nAlign )<\/li>\n<\/ol>\n\n\n\n

    Say test<\/h2>\n\n\n\n
    <\/circle><\/circle><\/circle><\/g><\/svg><\/span><\/path><\/path><\/svg><\/span>
    FUNCTION <\/span>Saytest<\/span>()<\/span><\/span>\n    LOCAL oXlsx :<\/span>=<\/span> <\/span>TDrXlsx<\/span>()<\/span>:<\/span>New<\/span>()<\/span><\/span>\n    LOCAL dtTest :<\/span>=<\/span> <\/span>hb_DateTime<\/span>(<\/span> <\/span>2023<\/span>,<\/span> <\/span>8<\/span>,<\/span> <\/span>23<\/span>,<\/span> <\/span>20<\/span>,<\/span> <\/span>0<\/span>4<\/span>,<\/span> <\/span>30<\/span> <\/span>)<\/span><\/span>\n        <\/span><\/span>\n    oXlsx:<\/span>CreateFile<\/span>(<\/span>"<\/span>say.xlsx<\/span>"<\/span>)<\/span><\/span>\n<\/span>\n    oXlsx:<\/span>SetColumnSize<\/span>(<\/span>0<\/span>,<\/span> <\/span>0<\/span>,<\/span> <\/span>30<\/span>)<\/span><\/span>\n    oXlsx:<\/span>SetColumnSize<\/span>(<\/span>0<\/span>,<\/span> <\/span>1<\/span>,<\/span> <\/span>30<\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>0<\/span>,<\/span>0<\/span>,<\/span>"<\/span>Valtype<\/span>"<\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>0<\/span>,<\/span>1<\/span>,<\/span>"<\/span>Value<\/span>"<\/span>)<\/span><\/span>\n<\/span>\n<\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>1<\/span>,<\/span>0<\/span>,<\/span>"<\/span>Character<\/span>"<\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>2<\/span>,<\/span>0<\/span>,<\/span>"<\/span>Numeric<\/span>"<\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>3<\/span>,<\/span>0<\/span>,<\/span>"<\/span>Date<\/span>"<\/span> <\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>4<\/span>,<\/span>0<\/span>,<\/span>"<\/span>Logic<\/span>"<\/span> <\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>5<\/span>,<\/span>0<\/span>,<\/span>"<\/span>Datetime format<\/span>"<\/span> <\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>6<\/span>,<\/span>0<\/span>,<\/span>"<\/span>Datetime<\/span>"<\/span> <\/span>)<\/span><\/span>\n<\/span>\n<\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>1<\/span>,<\/span>1<\/span>,<\/span>"<\/span>Hello<\/span>"<\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>2<\/span>,<\/span>1<\/span>,<\/span>1234<\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>3<\/span>,<\/span>1<\/span>,<\/span> <\/span>DATE<\/span>()<\/span> <\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>4<\/span>,<\/span>1<\/span>,<\/span> .T. <\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>5<\/span>,<\/span>1<\/span>,<\/span> dtTest<\/span>,,<\/span> <\/span>"<\/span>yyyy-mm-dd hh:mm:ss<\/span>"<\/span>)<\/span><\/span>\n    oXlsx:<\/span>Say<\/span>(<\/span>6<\/span>,<\/span>1<\/span>,<\/span> dtTest <\/span>)<\/span><\/span>\n<\/span>\n    oXlsx:<\/span>Close<\/span>()<\/span><\/span>\n<\/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":"
    At last, I’ve achieved the capability to transform all Harbour variables into Xlsx format. However, I’ve gone beyond…<\/p>\n","protected":false},"author":1,"featured_media":950,"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-948","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":["https:\/\/www.charleskwon.com\/wp-content\/uploads\/2023\/08\/image-10.png",561,572,false],"author_info":{"display_name":"CharlesKWON","author_link":"https:\/\/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":"https:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/posts\/948","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=948"}],"version-history":[{"count":3,"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/posts\/948\/revisions"}],"predecessor-version":[{"id":954,"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/posts\/948\/revisions\/954"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=\/wp\/v2\/media\/950"}],"wp:attachment":[{"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=948"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=948"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.charleskwon.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=948"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}