×
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

STRAND7_API with Excel Sheet

STRAND7_API with Excel Sheet

STRAND7_API with Excel Sheet

(OP)
Dear Engineers,
I'm new to strand7.
Can we Link Strand7 API with Excel Spreadsheets? If yes what's the steps to do so?.

Thanks in advance.

RE: STRAND7_API with Excel Sheet

Yes, you can, I have blog posts on it at:
https://newtonexcelbach.com/2011/09/23/using-the-s...
and
https://newtonexcelbach.com/2012/02/19/strand7-api...

but:
The code in my download spreadsheet in the 2nd link is for Rel 2.6 and won't work with the latest version (Rel 3).
The Strand7 API download for the latest version includes Excel VBA code for 64 bit Excel, but doesn't have a 32 bit version.

If you have 64 bit Excel and Strand7 Rel 3 (or 32 bit Excel and you are still using Rel 2.6) I suggest having a look at their example spreadsheet.

If you use Strand7 regularly it's certainly worth the effort to get the API working, but it's not a trivial task.

If you have any specific questions feel free to ask here.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: STRAND7_API with Excel Sheet

Ryan - I see you also asked here about linking Python to Strand7. I also do that, using pyxll to link Excel to the API Python code without VBA. If you are more familiar with Python than VBA you may prefer that route. Pyxll is a commercial (but low cost) package, or Xlwings is a free alternative.

Doug Jenkins
Interactive Design Services
http://newtonexcelbach.wordpress.com/

RE: STRAND7_API with Excel Sheet

(OP)
Dear Doug,
Thank you for your reply .I will definitely try it out.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Resources

Low-Volume Rapid Injection Molding With 3D Printed Molds
Learn methods and guidelines for using stereolithography (SLA) 3D printed molds in the injection molding process to lower costs and lead time. Discover how this hybrid manufacturing process enables on-demand mold fabrication to quickly produce small batches of thermoplastic parts. Download Now
Design for Additive Manufacturing (DfAM)
Examine how the principles of DfAM upend many of the long-standing rules around manufacturability - allowing engineers and designers to place a part’s function at the center of their design considerations. Download Now
Taking Control of Engineering Documents
This ebook covers tips for creating and managing workflows, security best practices and protection of intellectual property, Cloud vs. on-premise software solutions, CAD file management, compliance, and more. Download Now

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close