python classes

[Peihong Ke]

Dear xlSlim,

 

Can I check with you if you have some framework in xlSlim to deal with class/objects and their associated functions calls  (either instance or static functions) please? Or the users must come up with one themselves?

 

For example, if I have a class A which has ten methods. What is the best way to call these functions in xlSlim given an object of A?

 

Regards,

Peihong

Classification: Internal - ADIA Only

**************************************************************************************************************
PRIVATE & CONFIDENTIAL COMMUNICATION: This email is from the Abu Dhabi Investment Authority (ADIA). This email and its attachments (if any) are confidential and private business communication and are intended only for the named addressees. If you received this email in error, please notify the sender by reply email and promptly delete the original email from your system. The unauthorised use, disclosure or copying of this email, or any part of it, is strictly prohibited.

While ADIA takes care to protect its systems from viruses, it cannot guarantee that this message (including attachments) is free of any virus or other harmful matter, and accepts no responsibility for any loss or damage resulting from the recipient receiving, opening or using it, or for any damage or liability that may be caused by or result from the use of email or internet communications or the reliance thereon.

ADIA does not enter into contracts or undertakings, or provide binding assurances, by email.
**************************************************************************************************************

[xlSlim Dev]

Hi,

Classes are automatically cached when returned from functions and the cache handle can then be passed into other functions. This is described in this section of the documentation:

https://russelwebber.github.io/xlslim-docs/html/user/passing_objects.html

Since that guide was written I have added the GetAttr() utility function which is useful to conveniently access attributes of cached objects without having to write any Python functions: https://russelwebber.github.io/xlslim-docs/html/reference/api.html#getattr Also you can now create classes directly in Excel - each class is automatically registered as a function.

The Equity Option pricing example has a good overview of creating classes and passing them around: https://russelwebber.github.io/xlslim-docs/html/samples/equity_index_options.html

This earlier conversation has an example showing a  shared resource object being created and then passed to other functions:

https://groups.google.com/g/xlslim-support/c/qHfCuMP1LRc

All the best,

Russel