Category Archives: Link to dll

Using Excel with Python and ctypes

The Strand7 API provides an interface between the Strand7 Finite Element Analysis program and external software. It works with many different languages, including Python, which uses ctypes to transfer data to and from the API functions. It is essential that … Continue reading

Posted in Beam Bending, Excel, Link to dll, Link to Python, NumPy and SciPy, PyXLL, Strand7, UDFs | Tagged , , , , , | Leave a comment

64 bit Excel and the Strand7 API

Back in May 2017 I posted a sample spreadsheet using the Strand7 API to allow Excel to read and write Strand7 node data and results.  A comment noted at the time that the spreadsheet was not working with 64 bit … Continue reading

Posted in Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7 | Tagged , | Leave a comment

Installing Frame4 and 3DFrame

Following a recent comment I have added a VBA only version to the download files of the frame analysis spreadsheets: 3DFrame.zip Frame4.zip The VBA versions should work on any version of Excel from 2007, with macros enabled, without any further installation. The … Continue reading

Posted in AlgLib, Excel, Frame Analysis, Link to dll, Newton, VBA | Tagged , , , , , , | Leave a comment

February Links

Two new links with valuable free resources: .net and office automation follies : including many advanced VBA resources.  Thanks to Alfred Vachris for the link. AET VBE Tools : Tools for the Visual Basic editor from Andrew Engwirda (via Daily Dose of … Continue reading

Posted in Excel, Link to dll, VBA | Tagged , , , | Leave a comment

Frame analysis with spring releases; 2D

I have updated the Frame4 spreadsheet to allow a rotational spring stiffness to be specified for members with a rotational end release.  The new file can be downloaded from: Frame4.zip See Installing C# dll files, reminder for details of installing the … Continue reading

Posted in Beam Bending, Excel, Finite Element Analysis, Frame Analysis, Link to dll, Newton, Strand7, VBA | Tagged , , , , | 1 Comment