Tag Archives: UDFs

Python optional arguments from Excel – Part 2

The previous post provided a method for using pyxll to pass optional arguments from Excel to Python whilst preserving the default values of any called Python function for arguments that were omitted in the Excel function. One condition where this … Continue reading

Posted in Excel, Link to Python, NumPy and SciPy, PyXLL, UDFs, VBA | Tagged , , , , , | Leave a comment

Using Python optional arguments from Excel with pyxll

Python functions allow optional arguments to be specified by allocating a default value to each optional argument. The pyxll add-in allows Python functions called from Excel to work in the same way, so any argument with a default value may … Continue reading

Posted in Excel, Link to Python, PyXLL, UDFs | Tagged , , , , , , | 1 Comment

Units4Excel Update

As discussed here, I have updated the Units4Excel spreadsheet, with the list of non-SI units updated from the latest Wikipedia table. The EvalU user defined function (UDF) has also been modified with three output options, as shown in the screen-shot … Continue reading

Posted in Excel, Maths, Newton, UDFs, VBA | Tagged , , , , | 5 Comments

Extracting text from an Internet table

For use in my Units spreadsheet (Units4Excel) I want to extract the unit conversion values from the comprehensive Wikipedia unit conversion table. On Wikipedia the table looks like this: and when copied and pasted as Unicode text into Excel, like … Continue reading

Posted in Excel, Newton, UDFs, VBA | Tagged , , , , , , , | 3 Comments

Tanh-Sinh Quadrature update

Following some comments here Graeme Dennes and I have modified the start-up code for the Tanh-Sinh Quadrature spreadsheet to avoid problems opening the file when first downloaded, or copied to a new computer. The new file is located (as before) … Continue reading

Posted in Excel, Maths, Newton, Numerical integration, UDFs, VBA | Tagged , , , | Leave a comment