Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- Commenting a block of code in VBA
- Using Goal Seek on Multiple Cells
- Downloads by category
- Solving Quadratic, Cubic, Quartic and higher order equations; examples
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
- Downloads
- Using LINEST for non-linear curve fitting
- Time in hours and minutes between two dates
- ULS Analysis of Concrete Beams; now with added units
- About Newton Excel Bach
Recent Comments
Elastic Biaxial Bend… on Biaxial bending update Bill Harvey on Floating Point Precision … Floating Point Preci… on When does 35 not equal 35… dougaj4 on mpmath for Excel dougaj4 on mpmath for Excel Kapt Blasto on mpmath for Excel mktisis on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… dougaj4 on 3D Frame with zero stiffness… mktisis on 3D Frame with zero stiffness… th3budd on Time in hours and minutes betw… dougaj4 on Moving Load Spreadsheet… Ario on Moving Load Spreadsheet… dougaj4 on About Newton Excel Bach David Graves on About Newton Excel Bach
Tag Archives: default arguments
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 default arguments, Excel, Python, PyXLL, UDFs, VBA
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 default arguments, Excel, Python, PyXLL, SciPy, Scipy stats, UDFs
1 Comment