{"id":1855,"date":"2024-09-17T14:47:15","date_gmt":"2024-09-17T14:47:15","guid":{"rendered":"https:\/\/www.pyxll.com\/blog\/?p=1855"},"modified":"2024-11-19T16:09:38","modified_gmt":"2024-11-19T16:09:38","slug":"pyxll-5-9-0-available-now","status":"publish","type":"post","link":"https:\/\/www.pyxll.com\/blog\/pyxll-5-9-0-available-now\/","title":{"rendered":"PyXLL 5.9.0 available now!"},"content":{"rendered":"\n<p>PyXLL 5.9.0 is now available! \ud83e\udd73<\/p>\n\n\n\n<p>There are some big improvements and new features in this release. I&#8217;ve recorded a short video to tell you more&#8230;<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-video is-provider-youtube wp-block-embed-youtube wp-embed-aspect-16-9 wp-has-aspect-ratio\"><div class=\"wp-block-embed__wrapper\">\n<span class=\"embed-youtube\" style=\"text-align:center; display: block;\"><iframe loading=\"lazy\" class=\"youtube-player\" width=\"640\" height=\"360\" src=\"https:\/\/www.youtube.com\/embed\/Yo3EzbVXEdo?version=3&#038;rel=1&#038;showsearch=0&#038;showinfo=1&#038;iv_load_policy=1&#038;fs=1&#038;hl=en-US&#038;autohide=2&#038;wmode=transparent\" allowfullscreen=\"true\" style=\"border:0;\" sandbox=\"allow-scripts allow-same-origin allow-popups allow-presentation allow-popups-to-escape-sandbox\"><\/iframe><\/span>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-highlights\">Highlights<\/h2>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-new-html-based-interactive-plotting\">New html based interactive plotting<\/h4>\n\n\n\n<p>I&#8217;m really excited about the new interactive html based plotting integration.<br>Plotting using plotly, bokeh and altair by rendering static images is still possible, but I hope you agree that embedding the interactive html version in Excel is way better!<br><br>You can read more about plotting in Excel, including using the new html based plotting integration here&nbsp;<a href=\"https:\/\/pyxll.acemlna.com\/lt.php?x=3TxtmrUFUqPUT55qA3P3U.ef23BUidDxw~c1jaHEKaSa6H390NLHWBZyAKBWjwFfx1G4Y6HEI3Ts5I3_yN1F\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.pyxll.com\/docs\/userguide\/plotting\/index.htm<\/a><a href=\"https:\/\/www.pyxll.com\/docs\/userguide\/plotting\/index.html\" target=\"_blank\" rel=\"noreferrer noopener\">l<\/a><\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"h-embed-python-user-interface-controls-as-activex-controls-in-excel\">Embed Python user interface controls as ActiveX controls in Excel<\/h4>\n\n\n\n<p>If you&#8217;ve been using PyXLL for while, you might have seen that you can write &#8220;Custom Task Panes&#8221;. These are user interfaces written in Python, hosted in Excel as an embedded panel that docks in the Excel window alongside the worksheet.<br><br>This new &#8220;ActiveX&#8221; feature goes further and allows you to host Python controls that are placed directly on the Excel worksheet.<br><br>Read about using ActiveX controls here&nbsp;<a href=\"https:\/\/pyxll.acemlna.com\/lt.php?x=3TxtmrUFUqPUT55qA3P3U.ef23BUidDxw~c1jaHEKaSa6H390NLHWBZyAKBWjwFfx1G4Y6HEI3Ts5I3_yN1G\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.pyxll.com\/docs\/usergui<\/a><a href=\"https:\/\/www.pyxll.com\/docs\/userguide\/activex\/index.html\" target=\"_blank\" rel=\"noreferrer noopener\">de\/activex\/index.html<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-other-notable-changes\"><strong>Other notable changes<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Enhanced&nbsp;<a href=\"https:\/\/www.pyxll.com\/docs\/userguide\/udfs\/asyncfuncs.html\" target=\"_blank\" rel=\"noreferrer noopener\">async worksheet functions<\/a><\/li>\n\n\n\n<li>Faster starting (and restartable)&nbsp;<a href=\"https:\/\/www.pyxll.com\/docs\/userguide\/rtd.html\" target=\"_blank\" rel=\"noreferrer noopener\">RTD<\/a>&nbsp;functions<\/li>\n\n\n\n<li>New&nbsp;<a href=\"https:\/\/www.pyxll.com\/docs\/api\/macros.html#xl-disable\" target=\"_blank\" rel=\"noreferrer noopener\">xl_disable<\/a>&nbsp;context manager<\/li>\n\n\n\n<li>Python 3.13 support added<\/li>\n<\/ul>\n\n\n\n<p>For the complete list of changes in this new release (as well as previous versions) take a look at the changelog, which you can find here:<br><a href=\"https:\/\/www.pyxll.com\/changelog\/index.html#pyxll-5-9\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.pyxll.com\/changelog\/index.html<\/a><\/p>\n\n\n\n<p>The easiest way to update to this latest version is to use the pyxll command line tool as follows:<\/p>\n\n\n\n<pre class=\"wp-block-preformatted\">pip install --upgrade pyxll<br>pyxll update<\/pre>\n\n\n\n<p>You can also download this latest release from&nbsp;<a href=\"https:\/\/pyxll.acemlna.com\/lt.php?x=3TxtmrUFUqPUT55qA3P3U.ef23BUidDxw~c1jaHEKaSa6H390NLHWBZyAKBWjwFfx1G4Y6HEI3Ts5I3_yN1L\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/www.pyxll.com\/download.htm<\/a><a href=\"https:\/\/www.pyxll.com\/download.html\" target=\"_blank\" rel=\"noreferrer noopener\">l<\/a>&nbsp;if you prefer to manage your PyXLL add-in manually.<br><br>For more help upgrading please see&nbsp;<a href=\"https:\/\/pyxll.acemlna.com\/lt.php?x=3TxtmrUFUqPUT55qA3P3U.ef23BUidDxw~c1jaHEKaSa6H390NLHWBZyAKBWjwFfx1G4Y6HEI3Ts5I3_yN1M\" target=\"_blank\" rel=\"noreferrer noopener\">https:\/\/support.pyxll.com\/hc\/en-gb\/articles\/36003940507<\/a><a href=\"https:\/\/support.pyxll.com\/hc\/en-gb\/articles\/360039405073\" target=\"_blank\" rel=\"noreferrer noopener\">3<\/a>.<br><br>I hope you enjoy this new release, and as always please let me know using the <a href=\"https:\/\/www.pyxll.com\/contact.html\">Contact Form<\/a> how you get on, if you have any feedback, or if you run into any problems.<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>PyXLL 5.9.0 is now available! \ud83e\udd73 There are some big improvements and new features in this release. I&#8217;ve recorded a short video to tell you more&#8230; Highlights New html based interactive plotting I&#8217;m really excited about the new interactive html based plotting integration.Plotting using plotly, bokeh and altair by rendering static images is still possible,<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_post_was_ever_published":false},"categories":[662],"tags":[],"class_list":["post-1855","post","type-post","status-publish","format-standard","hentry","category-news"],"acf":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p7l3LP-tV","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/posts\/1855","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/comments?post=1855"}],"version-history":[{"count":1,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/posts\/1855\/revisions"}],"predecessor-version":[{"id":1883,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/posts\/1855\/revisions\/1883"}],"wp:attachment":[{"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/media?parent=1855"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/categories?post=1855"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.pyxll.com\/blog\/wp-json\/wp\/v2\/tags?post=1855"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}