Solidworks Automation using Excel Add in

Поделиться
HTML-код
  • Опубликовано: 11 июл 2024
  • Using excel tools to drive Solidworks
    github.com/jraleighdev/Automa...

Комментарии • 48

  • @luisamaral7689
    @luisamaral7689 2 года назад

    Great Add-in Engineering Automation.
    I have some problems to install and save the program, but with the resource of videos on RUclips, i as capable to add in to excel.
    I dont undestand nothing of Codes, and programming but it was easy.
    Thanks dude, will help me a lot !

  • @davidbaumgartner146
    @davidbaumgartner146 2 года назад

    nice work!

  • @engineeringautomation8585
    @engineeringautomation8585  3 года назад +2

    Thanks for all interest in the application. I've started adding some updates to the ui. The settings in solidworks tab now contains the selection for the units the app will feed into solidworks.

    • @MrFreaky1989
      @MrFreaky1989 3 года назад

      Thank you for all the work you put into this, the install is tricky and holding me up but I'll keep following you to see what you come up with in the future.

  • @dimitarhristakiev6610
    @dimitarhristakiev6610 3 года назад +6

    Would you lease make a video how to install thiss add in.

  • @aplied115
    @aplied115 2 года назад

    I have managed to get the vsto to run and open Solidworks with no errors but the "solidworks build" and "inventor build" tabs are not displaying. Do you know why this is?!

  • @aliallaw5529
    @aliallaw5529 2 года назад +1

    This add in th realy helpfull
    Thanks for sharing with us
    But i dont under stand codes and programing.. Is there a simple way to install this program easilly

  • @abhishekdubey1162
    @abhishekdubey1162 Год назад

    Hi,
    Can you please share details videos of how you have created all the options in Excel for this

  • @hypertool35
    @hypertool35 4 месяца назад

    hi, whats the difference from inserting "design table" ?

  • @nekadaracikdegilmi
    @nekadaracikdegilmi 3 года назад

    @Engineering Automation
    Sorry for too many questions. I asked this under another video but it is related to this video.
    After using this addin to control assembly, if i copy the assembly with all parts (like pack and go) will i be have control on new assembly and new parts by new Excel or the old one?

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад +1

      You can use any excel sheet as long as the part number matches the open documents structure. It doesn't have a link like design tables do. So its pretty flexible on that.

    • @nekadaracikdegilmi
      @nekadaracikdegilmi 3 года назад

      @@engineeringautomation8585 Thank you very very much! Would you please demonstrate other commands (for example 'equation') how to use? And do you mind if i ask your e-mail? Thank you again for this amazing addin!

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад +1

      @@nekadaracikdegilmi Sure thing working on making a new video to explain all the commands! I working on some drawing automation for a future release.

    • @nekadaracikdegilmi
      @nekadaracikdegilmi 3 года назад

      @@engineeringautomation8585 Great news!

  • @92Trane
    @92Trane 3 года назад +4

    Hello Engineering Automation,
    Thank you for openly sharing your work ! I really appreciate it.
    I've been watching so many tutorials to looking into API to do exactly this. I'm not a developer. I am terrified !
    Perhaps you could help?
    I downloaded and opened the .sln file in Visual Studio.
    It is showing : "...\SolidworksWrapper\SolidworksWrapper\SolidworksWrapper.csproj : error : The project file could not be loaded"
    It says the same thing with InventorWrapper.
    ...I have no idea what a "Wrapper" is. I don't listen to rap music much.
    Could you clarified on how to get it to work ?
    Thanks in advance.
    TR

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад +2

      Without getting to complicated a wrapper is section of code that wraps another. The reason for wrapper is to make talking with cad applications easier and manage memory.

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад +2

      The next step will be downloading the inventor wrapper and solidworks wrapper from github the visual studio will be able to find the projects and compile.

    • @92Trane
      @92Trane 3 года назад +1

      Hey man,

      Thanks again for sharing the project.

      For the people who got stuck:
      1) Download the Inventor/SolidWorks wrapper from this link:
      github.com/jraleighdev?tab=repositories
      2) Open up InventorWrapper.sln
      3) Add reference to the Autodesk.Inventor.Interop.dll
      This file is located at where you installed Inventor.
      If you don't have Inventor, there is a copy of the file in AutomationDesigner/References
      (from zip)
      4) Open AutomationDesigner.sln.
      Reload the 2 wrappers.
      Add references to the Syncfusion from Nuget packages by:
      ...
      Finding the name of each and install them.
      All the reference files should be gray (no yellow).
      5) If you want to run debug to see what's going on in the code,
      Open Properties of Automation Designer.
      In "Debug" tab, select start external program and link to "EXCEL.exe" on your machine.
      6) Enjoy the power.

  • @NiculaGeorgeStefan
    @NiculaGeorgeStefan Год назад +1

    Hi, it is a great tool, I wanted to try it out too, and after a bit o struggle to install it I get this error:
    Exception from HRESULT: 0x800A03EC
    Does anybody knows why and how to resolve it?

  • @mustafagimy5942
    @mustafagimy5942 2 года назад

    Hello ! May you help me to install that addin it's very helpfull

  • @ericoskar6138
    @ericoskar6138 3 года назад

    please help to install for a week already trying it does not work

  • @RoshanShandres
    @RoshanShandres Год назад

    Can this add in be added to WPS office?

  • @arieloliveramedina6553
    @arieloliveramedina6553 Год назад

    Como hago para tener en Excel ese icono de construir?

  • @adamboleskavsky9415
    @adamboleskavsky9415 3 года назад

    Hello Engineering Automation,
    I'm a big fan of your work. This tool is exactly what I am looking for :D. But I have an issue with running this add in.
    In advance, I want to say that I'm not a developer :D.
    When I open it in Visual studio, and try to compile, it will send me 70 errors and all of them are CS0246. I downloaded wrappers and placed them correctly. The files that cannot reach are where they are supposed to be, I think.
    Can you please help me to fix it?
    Thank you in advance ;)

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад

      The only thing that comes to mind initially is making sure you have the correct version of the dotnet framework installed. It that doesn't help let me know at github.com/jraleighdev/AutomationDesinger

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад

      Well another thing came to mind lol. The ui is powered by some syncfusion tools they are free to download you can create an account use them for any open source project.

    • @nekadaracikdegilmi
      @nekadaracikdegilmi 3 года назад

      @@engineeringautomation8585 Hello Engineer Automation, thanks for this useful tool. Can you please help me to compile the project? I'm getting same CS0246 errors. Also tried "advanced installer" but i get different errors on that too. Thanks in advance and thanks for the tool again.

    • @nekadaracikdegilmi
      @nekadaracikdegilmi 3 года назад

      Nevermind i solve the problem. The problem was syncfusion files in project were in false condition. When i change their condition to true errors are gone :)
      I just want to ask something; dimension values on excel are comes to solidworks inch type. How can i change it mm?

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад +1

      @@nekadaracikdegilmi So units are handled in the solidworks wrapper. I haven't implemented user setting in ui. You can uodate the default units in wrapper. Solidworks using meters as its internal units through the api we have to convert to desired units.

  • @alomara2776
    @alomara2776 2 месяца назад

    hello this is a great tool !!!
    but how can i install it ?

  • @StudioIngegneriaFabioPic-yo2vx
    @StudioIngegneriaFabioPic-yo2vx 11 месяцев назад +1

    Hello Engineering Automation,
    very interesting add-in.
    I have downloaded the files but i dont understand how to install the application in excel. Could you give intructions to do it? Shall i subscribe a plan, make a one-time-payment or other? thank you very much.

  • @xingminzhong5368
    @xingminzhong5368 3 года назад

    Can you package and publish the program?
    I'm not a programmer. I can't install the program in GitHub.

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад

      Maybe in the future this project is still under active development. Hosting the deployment is not free so i would had to have charge for deployed version. Thanks for interest.

    • @xingminzhong5368
      @xingminzhong5368 3 года назад

      @@engineeringautomation8585 I'm looking forward to your release

  • @nekadaracikdegilmi
    @nekadaracikdegilmi 3 года назад

    Helo... me again. I tried a lot but i can't figure out. If i command to suppress ( S ) a part in an assembly, then build process end up with an error that can't find the supressed part. Would you help me about it please if posibble.

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад +1

      Could you open as issue on github with the stack trace?

    • @nekadaracikdegilmi
      @nekadaracikdegilmi 2 года назад

      @@engineeringautomation8585 Hi.. i sent an email and opened an issue but didn't get any return. Hope you are fine.

  • @xihuahe745
    @xihuahe745 3 года назад +1

    Hello how did it install?

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад +1

      The addin is a vsto addin built using visual studio. Vsto addins can be installed using oneclick or a custom installer.

  • @caioyoshiaki764
    @caioyoshiaki764 3 года назад +4

    Would you by any chance share this excel Add-In ? hahah

  • @ericoskar6138
    @ericoskar6138 3 года назад

    thanks for the video but show me how to install this plugin

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад

      There is a couple training videos on how to install the app. It currently works as a VSTO add in the that requires visual studio. I don't have a deployable made for the add in at this time.

    • @Mambocha35
      @Mambocha35 11 месяцев назад

      @@engineeringautomation8585 can you help ? ı couldnt find any videos. do you have any suggestions videos ?

  • @ericoskar6138
    @ericoskar6138 3 года назад

    Can't install talking error

    • @engineeringautomation8585
      @engineeringautomation8585  3 года назад

      Please raise an issue on github with stack trace included i can't help with out more information.