Categories
RSS Feed
Search NewtonExcelBach
Archives
Top Posts
- AS 3600 public comment draft and py_RC Design
- Buckling of columns with varying cross section
- Reinforced concrete elastic analysis; Circular section
- The history of the theory of beam bending - Part 1
- Downloads
- Biaxial bending update
- Reinforced Concrete Section Analysis - 1
- Reinforced Concrete Section Analysis - 5; Ultimate Limit State
- Using LINEST for non-linear curve fitting
- Weighted Least Squares Regression, using Excel, VBA, Alglib and Python
Recent Comments
Tag Archives: pyxll Union
Scipy-statistics with all distributions
Following the previous post the Scipy statistics functions have been updated to include all the distributions, including the discrete distributions. The input to the distribution functions has also been updated to allow arrays to be transferred either as Excel ranges … Continue reading
Posted in Arrays, Excel, Link to Python, Maths, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Alternative data types, Distribution functions, Excel, Numpy, Python, PyXLL, pyxll get_type_converter, pyxll Union, SciPy, Scipy stats, statistics, UDFs
Leave a comment
Transferring different data types to/from Python with pyxll
When a user defined function (UDF) is created in Excel with Python and pyxll the data type of each argument can be specified, either in the @xl_func decorator, or with a separate @xl_arg decorator for each argument. I prefer the … Continue reading
Posted in Arrays, Excel, Link to Python, Newton, NumPy and SciPy, PyXLL, UDFs
Tagged Alternative data types, Excel, Numpy, Python, PyXLL, pyxll get_type_converter, pyxll Union, SciPy, Scipy stats, UDFs
1 Comment