Unpacking Software Livestream

Join our monthly Unpacking Software livestream to hear about the latest news, chat and opinion on packaging, software deployment and lifecycle management!

Learn More

Chocolatey Product Spotlight

Join the Chocolatey Team on our regular monthly stream where we put a spotlight on the most recent Chocolatey product releases. You'll have a chance to have your questions answered in a live Ask Me Anything format.

Learn More

Chocolatey Coding Livestream

Join us for the Chocolatey Coding Livestream, where members of our team dive into the heart of open source development by coding live on various Chocolatey projects. Tune in to witness real-time coding, ask questions, and gain insights into the world of package management. Don't miss this opportunity to engage with our team and contribute to the future of Chocolatey!

Learn More

Calling All Chocolatiers! Whipping Up Windows Automation with Chocolatey Central Management

Webinar from
Wednesday, 17 January 2024

We are delighted to announce the release of Chocolatey Central Management v0.12.0, featuring seamless Deployment Plan creation, time-saving duplications, insightful Group Details, an upgraded Dashboard, bug fixes, user interface polishing, and refined documentation. As an added bonus we'll have members of our Solutions Engineering team on-hand to dive into some interesting ways you can leverage the new features available!

Watch On-Demand
Chocolatey Community Coffee Break

Join the Chocolatey Team as we discuss all things Community, what we do, how you can get involved and answer your Chocolatey questions.

Watch The Replays
Chocolatey and Intune Overview

Webinar Replay from
Wednesday, 30 March 2022

At Chocolatey Software we strive for simple, and teaching others. Let us teach you just how simple it could be to keep your 3rd party applications updated across your devices, all with Intune!

Watch On-Demand
Chocolatey For Business. In Azure. In One Click.

Livestream from
Thursday, 9 June 2022

Join James and Josh to show you how you can get the Chocolatey For Business recommended infrastructure and workflow, created, in Azure, in around 20 minutes.

Watch On-Demand
The Future of Chocolatey CLI

Livestream from
Thursday, 04 August 2022

Join Paul and Gary to hear more about the plans for the Chocolatey CLI in the not so distant future. We'll talk about some cool new features, long term asks from Customers and Community and how you can get involved!

Watch On-Demand
Hacktoberfest Tuesdays 2022

Livestreams from
October 2022

For Hacktoberfest, Chocolatey ran a livestream every Tuesday! Re-watch Cory, James, Gary, and Rain as they share knowledge on how to contribute to open-source projects such as Chocolatey CLI.

Watch On-Demand

Downloads:

218

Downloads of v 4.0.1:

8

Last Update:

24 Oct 2024

Package Maintainer(s):

Software Author(s):

  • Russel Webber

Tags:

xlslim python excel

xlSlim Excel Add-In

  • 1
  • 2
  • 3

4.0.1 | Updated: 24 Oct 2024

Downloads:

218

Downloads of v 4.0.1:

8

Maintainer(s):

Software Author(s):

  • Russel Webber

xlSlim Excel Add-In 4.0.1

Legal Disclaimer: Neither this package nor Chocolatey Software, Inc. are affiliated with or endorsed by Russel Webber. The inclusion of Russel Webber trademark(s), if any, upon this webpage is solely to identify Russel Webber goods or services and not for commercial purposes.

  • 1
  • 2
  • 3

All Checks are Passing

3 Passing Tests


Validation Testing Passed


Verification Testing Passed

Details

Scan Testing Successful:

No detections found in any package files

Details
Learn More

Deployment Method: Individual Install, Upgrade, & Uninstall

To install xlSlim Excel Add-In, run the following command from the command line or from PowerShell:

>

To upgrade xlSlim Excel Add-In, run the following command from the command line or from PowerShell:

>

To uninstall xlSlim Excel Add-In, run the following command from the command line or from PowerShell:

>

Deployment Method:

NOTE

This applies to both open source and commercial editions of Chocolatey.

1. Enter Your Internal Repository Url

(this should look similar to https://community.chocolatey.org/api/v2/)


2. Setup Your Environment

1. Ensure you are set for organizational deployment

Please see the organizational deployment guide

2. Get the package into your environment

  • Open Source or Commercial:
    • Proxy Repository - Create a proxy nuget repository on Nexus, Artifactory Pro, or a proxy Chocolatey repository on ProGet. Point your upstream to https://community.chocolatey.org/api/v2/. Packages cache on first access automatically. Make sure your choco clients are using your proxy repository as a source and NOT the default community repository. See source command for more information.
    • You can also just download the package and push it to a repository Download

3. Copy Your Script

choco upgrade xlslim -y --source="'INTERNAL REPO URL'" [other options]

See options you can pass to upgrade.

See best practices for scripting.

Add this to a PowerShell script or use a Batch script with tools and in places where you are calling directly to Chocolatey. If you are integrating, keep in mind enhanced exit codes.

If you do use a PowerShell script, use the following to ensure bad exit codes are shown as failures:


choco upgrade xlslim -y --source="'INTERNAL REPO URL'" 
$exitCode = $LASTEXITCODE

Write-Verbose "Exit code was $exitCode"
$validExitCodes = @(0, 1605, 1614, 1641, 3010)
if ($validExitCodes -contains $exitCode) {
  Exit 0
}

Exit $exitCode

- name: Install xlslim
  win_chocolatey:
    name: xlslim
    version: '4.0.1'
    source: INTERNAL REPO URL
    state: present

See docs at https://docs.ansible.com/ansible/latest/modules/win_chocolatey_module.html.


chocolatey_package 'xlslim' do
  action    :install
  source   'INTERNAL REPO URL'
  version  '4.0.1'
end

See docs at https://docs.chef.io/resource_chocolatey_package.html.


cChocoPackageInstaller xlslim
{
    Name     = "xlslim"
    Version  = "4.0.1"
    Source   = "INTERNAL REPO URL"
}

Requires cChoco DSC Resource. See docs at https://github.com/chocolatey/cChoco.


package { 'xlslim':
  ensure   => '4.0.1',
  provider => 'chocolatey',
  source   => 'INTERNAL REPO URL',
}

Requires Puppet Chocolatey Provider module. See docs at https://forge.puppet.com/puppetlabs/chocolatey.


4. If applicable - Chocolatey configuration/installation

See infrastructure management matrix for Chocolatey configuration elements and examples.

Package Approved

This package was approved as a trusted package on 24 Oct 2024.

Description

Calling Python functions from Excel should be easy. xlSlim makes calling Python functions as simple as possible. No Python code changes are required (although sometimes type hints are).

Russel Webber, owner of Webber Software Solutions Ltd, grants permission for the Chocolatey Community Repository to redistribute this software.


tools\chocolateybeforemodify.ps1
# This runs before upgrade or uninstall.
# Use this file to do things like stop services prior to upgrade or uninstall.
# NOTE: It is an anti-pattern to call chocolateyUninstall.ps1 from here. If you
#  need to uninstall an MSI prior to upgrade, put the functionality in this
#  file without calling the uninstall script. Make it idempotent in the
#  uninstall script so that it doesn't fail when it is already uninstalled.
# NOTE: For upgrades - like the uninstall script, this script always runs from
#  the currently installed version, not from the new upgraded package version.
get-process *excel* | stop-process -force
tools\chocolateyinstall.ps1

$ErrorActionPreference = 'Stop'
$toolsDir   = "$(Split-Path -parent $MyInvocation.MyCommand.Definition)"
$fileLocation = Join-Path $toolsDir 'xlSlim.exe'

$packageArgs = @{
  packageName   = $env:ChocolateyPackageName
  unzipLocation = $toolsDir
  fileType      = 'exe'
  file         = $fileLocation

  softwareName  = 'xlslim*'

  checksum64    = '711d7173028ebe2b26d1cb3f120bc17f08408fb8'
  checksumType64= 'sha1'

  silentArgs    = "/exenoui /quiet"
  validExitCodes= @(0, 3010, 1641)
}

Install-ChocolateyInstallPackage @packageArgs

















tools\LICENSE.txt
From: https://www.xlslim.com/pages/end-user-license-agreement

LICENSE



End user licence agreement

Please read this EULA carefully, as it sets out the basis upon which we license the Software for use.

By selecting “I accept the terms in the License Agreement” or clicking "I agree to the License terms and conditions" when you first install the Software, you agree to be bound by the provisions of this EULA.

Before you download the Software from our website, we will ask you to give your express agreement to the provisions of this EULA.

By agreeing to be bound by this EULA, you further agree that your employees or any person you authorise to use the Software will comply with the provision of this EULA.

    Definitions

1.1    In this EULA:

"Charges" means licence fees that the parties have agreed shall be payable by the User to the Licensor in respect of this EULA, these are listed at https://www.xlslim.com;

"Documentation" means the documentation for the Software produced by the Licensor and made available by the Licensor to the User;

"Effective Date" means the date upon which the User gives the User's express consent to this EULA, following the issue of this EULA by the Licensor;

"EULA" means this end user licence agreement, including any amendments to this end user licence agreement from time to time;

"Force Majeure Event" means an event, or a series of related events, that is outside the reasonable control of the party affected (including failures of the internet or any public telecommunications network, hacker attacks, denial of service attacks, virus or other malicious software attacks or infections, power failures, industrial disputes affecting any third party, changes to the law, disasters, explosions, fires, floods, riots, terrorist attacks and wars);

"Intellectual Property Rights" means all intellectual property rights wherever in the world, whether registrable or unregistrable, registered or unregistered, including any application or right of application for such rights (and these "intellectual property rights" include copyright and related rights, database rights, confidential information, trade secrets, know-how, business names, trade names, trade marks, service marks, passing off rights, unfair competition rights, patents, petty patents, utility models, semi-conductor topography rights and rights in designs);

"Licensor" means Webber Software Solutions Ltd, a company incorporated in England and Wales (registration number 14125883) having its registered office at 11 Braemar, 12 Kersfield Road, London, SW15 3HG;

"Minimum Term" means, in respect of this EULA, the period of 12 months beginning on the Effective Date;

“Open Source Software” means open source software as defined by the Open Source Initiative (https://opensource.org) or the Free Software Foundation (https://www.fsf.org)

"Software" means the xlSlim Add-In for the Microsoft Excel application;

"Software Defect" means a defect, error or bug in the Software having an adverse effect on the appearance, operation, functionality or performance of the Software, but excluding any defect, error or bug caused by or arising as a result of:

(a)     any act or omission of the User or any person authorised by the User to use the Software;

(b)     any use of the Software contrary to the Documentation by the User or any person authorised by the User to use the Software;

(c)     a failure of the User to perform or observe any of its obligations in this EULA; and/or

(d)     an incompatibility between the Software and any other system, network, application, program, hardware or software not specified as compatible in the Software Specification];

"Software Specification" means the specification for the Software set out in the Documentation;

"Source Code" means the Software code in human-readable form or any part of the Software code in human-readable form, including code compiled to create the Software or decompiled from the Software, but excluding interpreted code comprised in the Software;

"Term" means the term of this EULA, commencing in accordance with Clause 2.1 and ending in accordance with Clause 2.2;

"Update" means a hotfix, patch or minor version update to the Software;

"Upgrade" means a major version upgrade of the Software;

"User" means the person to whom the Licensor grants a right to use the Software under this EULA; and

    Term

2.1    This EULA shall come into force upon the Effective Date.

2.2    This EULA shall continue in force for twelve months from the Effective Date.

    Licence

3.1    The Licensor hereby grants to the User from the date of supply of the Software to the User until the end of the Term a worldwide, non-exclusive licence to:

(a)     install up to three instances of the Software;

(b)     use up to three instances of the Software in accordance with the Documentation; and

(c)     create, store and maintain up to 5 back-up copies of the Software,

         subject to the limitations and prohibitions set out and referred to in this Clause 3.

3.2    The User may not sub-license and must not purport to sub-license any rights granted under Clause 3.1 without the prior written consent of the Licensor.

3.3    Save to the extent expressly permitted by this EULA or required by applicable law on a non-excludable basis, any licence granted under this Clause 3 shall be subject to the following prohibitions:

(a)     the User must not sell, resell, rent, lease, loan, supply, publish, distribute or redistribute the Software;

(b)     the User must not alter, edit or adapt the Software; and

(c)     the User must not decompile, de-obfuscate or reverse engineer, or attempt to decompile, de-obfuscate or reverse engineer, the Software.

3.4    The User shall be responsible for the security of copies of the Software supplied to the User under this EULA (or created from such copies) and shall use all reasonable endeavours (including all reasonable security measures) to ensure that access to such copies is restricted to persons authorised to use them under this EULA.

    Source Code

4.1    Nothing in this EULA shall give to the User or any other person any right to access or use the Source Code or constitute any licence of the Source Code.

    No assignment of Intellectual Property Rights

6.1    Nothing in this EULA shall operate to assign or transfer any Intellectual Property Rights from the Licensor to the User, or from the User to the Licensor.

    Charges

7.1    The User shall pay the Charges to the Licensor in accordance with this EULA.

7.2    All amounts stated in or in relation to this EULA are, unless the context requires otherwise, stated inclusive of any applicable value added taxes.

    Payments

8.1    The Licensor shall issue receipts for the Charges to the User when the licence is purchased.

8.2    The User must pay the Charges to the Licensor in advance.

    Warranties

9.1    The Licensor warrants to the User that it has the legal right and authority to enter into this EULA and to perform its obligations under this EULA.

9.2    The User warrants to the Licensor that it has the legal right and authority to enter into this EULA and to perform its obligations under this EULA.

9.3    All of the parties' warranties and representations in respect of the subject matter of this EULA are expressly set out in this EULA. To the maximum extent permitted by applicable law, no other warranties or representations concerning the subject matter of this EULA will be implied into this EULA or any related contract.

9.5    The User acknowledges that any Open Source Software provided by the Licensor is provided “as is” and expressly subject to the disclaimer in 9.6.

9.6    All other conditions, warranties or other terms which might have effect between the parties or be implied or incorporated into this licence or any collateral contract, whether by statute, common law or otherwise, are hereby excluded, including the implied conditions, warranties or other terms as to satisfactory quality, fitness for purpose or the use of reasonable skill and care.

    Acknowledgements and warranty limitations

10.1  The User acknowledges that complex software is never wholly free from defects, errors and bugs; and subject to the other provisions of this EULA, the Licensor gives no warranty or representation that the Software will be wholly free from defects, errors and bugs.

10.2  The User acknowledges that complex software is never entirely free from security vulnerabilities; and subject to the other provisions of this EULA, the Licensor gives no warranty or representation that the Software will be entirely secure.

10.3  The User acknowledges that the Software is only designed to be compatible with that software specified as compatible in the Software Specification; and the Licensor does not warrant or represent that the Software will be compatible with any other software.

10.4  The User acknowledges that the Licensor will not provide any legal, financial, accountancy or taxation advice under this EULA or in relation to the Software; and, except to the extent expressly provided otherwise in this EULA, the Licensor does not warrant or represent that the Software or the use of the Software by the User will not give rise to any legal liability on the part of the User or any other person.

    Limitations and exclusions of liability

11.1  Nothing in this EULA will:

(a)     limit or exclude any liability for death or personal injury resulting from negligence;

(b)     limit or exclude any liability for fraud or fraudulent misrepresentation;

(c)     limit any liabilities in any way that is not permitted under applicable law; or

(d)     exclude any liabilities that may not be excluded under applicable law,

         and, if a party is a consumer, that party's statutory rights will not be excluded or limited by this EULA, except to the extent permitted by law.

11.2  The limitations and exclusions of liability set out in this Clause 11 and elsewhere in this EULA:

(a)     are subject to Clause 11.1; and

(b)     govern all liabilities arising under this EULA or relating to the subject matter of this EULA, including liabilities arising in contract, in tort (including negligence) and for breach of statutory duty, except to the extent expressly provided otherwise in this EULA.

11.3  The Licensor will not be liable to the User in respect of any losses arising out of a Force Majeure Event.

11.4  The Licensor will not be liable to the User in respect of any loss of profits or anticipated savings.

11.5  The Licensor will not be liable to the User in respect of any loss of revenue or income.

11.6  The Licensor will not be liable to the User in respect of any loss of business, contracts or opportunities.

11.7  The Licensor will not be liable to the User in respect of any loss or corruption of any data, database or software.

11.8  The Licensor will not be liable to the User in respect of any special, indirect or consequential loss or damage.

11.9  The liability of the Licensor to the User under this EULA in respect of any event or series of related events shall not exceed the total amount paid and payable by the User to the Licensor under this EULA in the 12 month period preceding the commencement of the event or events.

11.10 The aggregate liability of the Licensor to the User under this EULA shall not exceed the total amount paid and payable by the User to the Licensor under this EULA.

    Termination

12.1  The Licensor may terminate this EULA by giving to the User not less than 30 days' written notice of termination.

12.2  The User may terminate this EULA by giving to the Licensor not less than 30 days' written notice of termination.

12.3  Either party may terminate this EULA immediately by giving written notice of termination to the other party if:

(a)     the other party commits any breach of this EULA, and the breach is not remediable;

(b)     the other party commits a breach of this EULA, and the breach is remediable but the other party fails to remedy the breach within the period of 30 days following the giving of a written notice to the other party requiring the breach to be remedied; or

(c)     the other party persistently breaches this EULA (irrespective of whether such breaches collectively constitute a material breach).

12.4  Either party may terminate this EULA immediately by giving written notice of termination to the other party if:

(a)     the other party:

(i)      is dissolved;

(ii)     ceases to conduct all (or substantially all) of its business;

(iii)    is or becomes unable to pay its debts as they fall due;

(iv)    is or becomes insolvent or is declared insolvent; or

(v)     convenes a meeting or makes or proposes to make any arrangement or composition with its creditors;

(b)     an administrator, administrative receiver, liquidator, receiver, trustee, manager or similar is appointed over any of the assets of the other party;

(c)     an order is made for the winding up of the other party, or the other party passes a resolution for its winding up[ (other than for the purpose of a solvent company reorganisation where the resulting entity will assume all the obligations of the other party under this EULA)]; or

12.5  The Licensor may terminate this EULA immediately by giving written notice to the User if:

(a)     any amount due to be paid by the User to the Licensor under this EULA is unpaid by the due date and remains unpaid upon the date that that written notice of termination is given; and

(b)     the Licensor has given to the User at least 30 days' written notice, following the failure to pay, of its intention to terminate this EULA in accordance with this Clause 14.5.

    Effects of termination

13.1  Upon the termination of this EULA, all of the provisions of this EULA shall cease to have effect, save that the following provisions of this EULA shall survive and continue to have effect (in accordance with their express terms or otherwise indefinitely): Clauses 1, 11, 13, 14 and 15.

13.2  Except to the extent that this EULA expressly provides otherwise, the termination of this EULA shall not affect the accrued rights of either party.

13.3  For the avoidance of doubt, the licences of the Software in this EULA shall terminate upon the termination of this EULA; and, accordingly, the User must immediately cease to use the Software upon the termination of this EULA.

13.4  Within 10 Business Days following the termination of this EULA, the User must:

(a)     irrevocably delete from all computer systems in its possession or control all copies of the Software.

    General

14.1  No breach of any provision of this EULA shall be waived except with the express written consent of the party not in breach.

14.2  If any provision of this EULA is determined by any court or other competent authority to be unlawful and/or unenforceable, the other provisions of this EULA will continue in effect. If any unlawful and/or unenforceable provision would be lawful or enforceable if part of it were deleted, that part will be deemed to be deleted, and the rest of the provision will continue in effect (unless that would contradict the clear intention of the parties, in which case the entirety of the relevant provision will be deemed to be deleted).

14.3  This EULA may not be varied except by a written document signed by or on behalf of each of the parties.

14.4  The User hereby agrees that the Licensor may assign the Licensor's contractual rights and obligations under this EULA to any successor to all or a substantial part of the business of the Licensor from time to time. Save to the extent expressly permitted by applicable law, the User must not without the prior written consent of the Licensor assign, transfer or otherwise deal with any of the User's contractual rights or obligations under this EULA.

14.5  This EULA is made for the benefit of the parties, and is not intended to benefit any third party or be enforceable by any third party. The rights of the parties to terminate, rescind, or agree any amendment, waiver, variation or settlement under or relating to this EULA are not subject to the consent of any third party.

14.6  Subject to Clause 13.1, this EULA shall constitute the entire agreement between the parties in relation to the subject matter of this EULA, and shall supersede all previous agreements, arrangements and understandings between the parties in respect of that subject matter.

14.7  This EULA shall be governed by and construed in accordance with English law.

14.8  The courts of England shall have exclusive jurisdiction to adjudicate any dispute arising under or in connection with this EULA.

    Interpretation

15.1  In this EULA, a reference to a statute or statutory provision includes a reference to:

(a)     that statute or statutory provision as modified, consolidated and/or re-enacted from time to time; and

(b)     any subordinate legislation made under that statute or statutory provision.

15.2  The Clause headings do not affect the interpretation of this EULA.

15.3  References in this EULA to "calendar months" are to the 12 named periods (January, February and so on) into which a year is divided.

15.4  In this EULA, general words shall not be given a restrictive interpretation by reason of being preceded or followed by words indicating a particular class of acts, matters or things.


REDISTRIBUTION USING CHOCOLATELY

Redistribution of the software via the site https://community.chocolatey.org is permitted. Please see https://www.xlslim.com/pages/chocolatey-redistribution
tools\VERIFICATION.txt
VERIFICATION
Verification is intended to assist the Chocolatey moderators and community
in verifying that this package's contents are trustworthy.

All files are scanned for virusses and malware using www.virustotal.com which scans files using all the major antivirus products. The report for the installer can be viewed here <https://www.virustotal.com/gui/file/9638c449e6fc0d5a7b23e6c54ecf80e9ec2f667c4947b6d3b0776dd290dfbbc4/details>

The xlSlim.exe installer as well as .exe and .xll files within the download are digitally signed by Webber Software Solutions Ltd using a DigiCert Extended Validation (EV) Code Signing Certificate <https://www.digicert.com/signing/code-signing-certificates>.

The installer was downloaded from <https://www.xlslim.com/downloads/xlslim/v4.0.1>
and can be verified like this:

1. Download the following installer:
   https://www.xlslim.com/downloads/xlslim/v4.0.1
2. You can use the powershell function 'Get-AuthenticodeSignature .\xlSlim.exe' to verify the digital signature

SignerCertificate                         Status                    StatusMessage            Path
-----------------                         ------                    -------------            ----
B040A599CD2DE967343166BE1C0178E6FADC529B  Valid                     Signature verified.      xlSlim.exe

File 'LICENSE.txt' is obtained from <https://www.xlslim.com/pages/end-user-license-agreement>
tools\xlSlim.exe
md5: B317675BE446D7F7F01716117943E177 | sha1: 711D7173028EBE2B26D1CB3F120BC17F08408FB8 | sha256: 9638C449E6FC0D5A7B23E6C54ECF80E9EC2F667C4947B6D3B0776DD290DFBBC4 | sha512: D9885B29B09269CC7230587211121FC6E882A4A91A142DE164E084AC3D59982D61CD9E56247E8E0FE94CDDBC268A6138BC479AE764806AAA2EC6C31AC010AFF6

Log in or click on link to see number of positives.

In cases where actual malware is found, the packages are subject to removal. Software sometimes has false positives. Moderators do not necessarily validate the safety of the underlying software, only that a package retrieves software from the official distribution point and/or validate embedded software against official distribution point (where distribution rights allow redistribution).

Chocolatey Pro provides runtime protection from possible malware.

Add to Builder Version Downloads Last Updated Status
xlSlim Excel Add-In 4.0.0 9 Friday, October 11, 2024 Approved
xlSlim Excel Add-In 3.3.2 27 Thursday, June 27, 2024 Approved
xlSlim Excel Add-In 3.3.1 25 Monday, May 27, 2024 Approved
xlSlim Excel Add-In 3.3.0 17 Thursday, May 16, 2024 Approved
xlSlim Excel Add-In 3.2.0 27 Thursday, March 14, 2024 Approved
xlSlim Excel Add-In 3.1.5 29 Wednesday, January 24, 2024 Approved
xlSlim Excel Add-In 3.1.1 76 Wednesday, January 10, 2024 Approved

Changelog

All notable changes to this project will be documented in this file.

The format is based on Keep a Changelog,
and this project adheres to Semantic Versioning.

[4.0.1] 2024-10-24

Fixed

  • Fixed a problem with nested functions returning cached objects. Amended the object cache key generation so multiple functions run within the same cell will generate unique keys.

[4.0.0] 2024-10-11

Added

  • New DuckDbQuery() function allows DuckDB SQL to be run in Excel.

Fixed

  • Adjusted the license checks so expired licenses do not request product details.
  • Remote module imports now work for Python 3.12

[3.3.2] 2024-06-27

Fixed

  • Type hinted functions with optional parameters were not picking up the defaults correctly when the function was not hinted with Optional

Changed

  • A more user-friendly error messge is returned if a cache key is passed when an Excel range is expected.

[3.3.1] 2024-05-24

Fixed

  • The ViewPyObject() function now displays numpy vectors

Changed

  • The digital signature used for code signing has been updated as the previous certificate expired in May 2024.

[3.3.0] 2024-05-16

Added

  • Added support for Python 3.12, note that the remote module imports do not yet work for Python 3.12

Changed

  • The bundled Python is now Python 3.11
  • Updated Excel DNA to 1.7.0
  • Updated Python.Net to 3.0.3
  • Updated Python.Included to 3.11.6
  • Updated LicenseSpring SDK to 7.26.0
  • Updated NLog to 5.3.2
  • Updated MessagePack to 2.5.140

[3.2.0] 2024-03-14

Fixed

  • Missing string arguments are correctly detected and passed to Python as None not ""
  • Python 3.11 introduced slightly different handling of type hints with a None default, this is now handled so all Python versions have the same behaviour in xlSlim

Added

  • Streaming (RTD) functions can now accept cached Python objects.

[3.1.5] 2023-11-29

Fixed

  • Fixed a bug in the ActivatePremiumLicense() function introduced in Release 3.1.2.

[3.1.4] 2023-11-16

Fixed

  • Context and ribbon menus can now have spaces in the labels.

[3.1.3] 2023-09-22

Fixed

  • Improved the performance of list arguments.
  • Optional arguments dependent on function calls are now supported, for example def f(x=date(2023,9,22))...

Changed

  • Lists of doubles are now passed into Python functions as native Python lists, previously they were passed as wrapped .Net sequences.
  • Updated Python.Net to 3.0.2

[3.1.2] 2023-09-14

Added

  • When loaded the addin checks if a newer version is available and displays a popup window with details. This can be disabled by setting HKEY_CURRENT_USER\xlslim\skipVersionCheck to Y
  • When loaded the addin checks if a premium license is within 14 days of expiry and displays a popup window with details. This can be disabled by setting HKEY_CURRENT_USER\xlslim\skipExpiryCheck to Y

[3.1.1] 2023-08-12

Fixed

  • Python function registrations can be added to the named range XLSLIM_RUN_AT_START. They will be run when workbooks are opened.

[3.1.0] 2023-07-22

Added

  • Python functions expecting lists of lists can now be passed a range from Excel. Previously only the first row was being passed from Excel.
  • Pandas NaT values are recognised and a #NA error is returned

Fixed

  • Python datetime.date and datetime.time instances are correctly handled when returned from functions
  • Lists of strings are not unpacked into list of lists of characters when returned to Excel
  • Optional lists now work correctly when not passed from Excel, previously the mapped function was not being called
  • Removed unused sections in the xlSlim License Manager application
  • The utility function ViewPyObject() has been improved

Changed

  • nan and inf doubles are now returned as #NUM errors
  • nulls and None are now returned as #NA errors
  • Lists of strings are not unpacked into list of lists of characters when returned to Excel
  • Updated LicenseSpring SDK to 7.20.0
  • The digital signature used for code signing has been updated as the previous certificate expired in June 2023.

[3.0.0] 2023-06-02

Added

  • New interactive mode where cells starting with "#py" are treated as Python code and are run in the worksheet
  • New Python editor to edit Python code contained within cells.
  • Cells in the named range XLSLIM_RUN_AT_START are calculated when workbooks are opened.

Fixed

  • Fixed displaying pandas dataframes that contain timezone aware datetime64 values
  • Extra Python and DLL paths are now cached in the Windows registry along with the previously cached Python executable path.

Changed

  • Python module analysis is now much faster
  • Updated Excel DNA to 1.7.0-rc4
  • Updated LicenseSpring SDK to 7.17.1
  • Updated NLog to 5.1.4
  • Updated MessagePack to 2.5.108

[2.1.0] 2023-04-14

Added

  • Added simple context and ribbon menus.

[2.0.10] 2023-03-22

Added

  • Added a new CreatePyModule() Excel function to create modules from text.

Fixed

  • Fixed a missing acquisition of the GIL while analyzing modules (part of the function registration process).
  • Include the function name in the object cache keys generated by RTD functions.

[2.0.9] 2023-02-16

Added

  • Added support for remote module imports

[2.0.8] 2022-12-01

Added

  • Added support for VBA event handling, Application.OnTime and Application.OnKey methods.
  • Added a new function ClearCacheItem() to remove an item from the object cache.

[2.0.7] 2022-11-09

Added

  • Added support for Python 3.11

Changed

  • Updated Python.Net to 3.0.1
  • Updated LicenseSpring SDK to 7.10
  • Updated NLog to 5.0.5

[2.0.6] 2022-10-12

Fixed

  • Fixed a problem initialising Python 3.7, this was a result of the platform module patch added in 2.0.4.

Changed

  • pandas timestamps and numpy datetime64 types are now treated as dates when returned from functions.

[2.0.5] 2022-10-06

Fixed

  • Null values are filtered out of ranges of cached objects.

Changed

  • The CreateRange() utility function now works with 2d ranges. The results can be passed as dictionary inputs.

[2.0.4] 2022-10-02

Added

  • Added support for Python dictionaries. Dictionaries can be passed as function arguments and returned as function results. Dictionaries can be created from two columns in Excel.
  • Python classes are now registered as Excel functions. Objects can be created directly within Excel.
  • Python data classes are also supported and can be created directly within Excel.
  • Python enums have limited support, enums defined within registered modules are recognised and the enum text can be passed to functions that expect enums.
  • Added new utility functions: GetAttr and GetItem

Fixed

  • Fixed a reference counting bug when passing lists of cached objects
  • The utility function ViewPyObject() supports more data types including datetimes and lists.
  • Fixed a bug introduced in 2.0.1 where boolean results were returned as doubles.
  • Patched the Python platform module's use of cmd as this is seen as an exploit by some antivirus vendors.

Changed

  • Lists of datetimes can now be passed from Excel, they are correctly parsed.

[2.0.3] 2022-09-07

Fixed

  • Fixed a bug so the Excel COM object functionality is only imported when used. This was causing the bundled Python to fail as it does not contain pythoncom.

[2.0.2] 2022-09-01

Added

  • Enable access to the Excel COM object via the new XLSLIM_COMAPPFUNC global. Any functions accessing the global are registered as macro functions.
  • New utility function XlSlimVersion() to return the xlSlim version to Excel

Fixed

  • Fixed a bug with type hinted functions returning lists with numpy floats.
  • Fixed the setting of sys.prefix and sys.exec_prefix so the site module is correctly processed.

[2.0.1] 2022-08-25

Added

  • Support for numpy floats (np.float16, np.float32, np.float64). These can now be returned from Python functions and used in type hints.

Fixed

  • Load user modules from file rather than text, this enables debugging.

[2.0.0] 2022-08-12

Added

  • Python iterator classes and generator functions (async and regular) can be registered and then stream data to Excel via the RTD(..) internals

Changed

  • Refactored the Python object cacheing
  • Updated MessagePack to 2.4.35
  • Updated LicenseSpring SDK to 7.8
  • Updated Python.Net to 3.0.0rc4

Fixed

  • Python functions that return None are handled better, an empty string is sent to Excel
  • Add the current Python module location to the sys.path
  • Python logs use the correct module name
  • Fixed the log sizing

[1.0.3] 2022-07-17

Fixed

  • Reverted removal of binding redirects in the app.config files from v.1.0.2

[1.0.2] 2022-07-01

Added

  • Can specify additional Python module search paths when registering modules
  • Can specify additional Windows DLL search paths when registering modules
  • Can control which functions are imported from a module and have a different function name in Excel
  • Can add PrefixBuiltInFunctions to the appSettings in xlSlim64.xll.config file to prefix builtin function names

Changed

  • Cleaned up the app.config files
  • Removed unnecessary XML and config files from installation

[1.0.1] - 2022-06-23

Added

  • Added 3rd party software licenses file.
  • Added this change log

Changed

  • Lowered the default logging levels to be INFO, was DEBUG
  • Configured all logs to be rolling logs
  • Renamed the background process log from addinlog.txt to xlslim-subproc.log
  • Renamed the Excel add-in log from addinlog.txt to xlslim-addin.log

[1.0.0] - 2022-06-16

Added


This package has no dependencies.

Discussion for the xlSlim Excel Add-In Package

Ground Rules:

  • This discussion is only about xlSlim Excel Add-In and the xlSlim Excel Add-In package. If you have feedback for Chocolatey, please contact the Google Group.
  • This discussion will carry over multiple versions. If you have a comment about a particular version, please note that in your comments.
  • The maintainers of this Chocolatey Package will be notified about new comments that are posted to this Disqus thread, however, it is NOT a guarantee that you will get a response. If you do not hear back from the maintainers after posting a message below, please follow up by using the link on the left side of this page or follow this link to contact maintainers. If you still hear nothing back, please follow the package triage process.
  • Tell us what you love about the package or xlSlim Excel Add-In, or tell us what needs improvement.
  • Share your experiences with the package, or extra configuration or gotchas that you've found.
  • If you use a url, the comment will be flagged for moderation until you've been whitelisted. Disqus moderated comments are approved on a weekly schedule if not sooner. It could take between 1-5 days for your comment to show up.
comments powered by Disqus