Hello , I ran into a problem with the import data option in motion study. I had used a motor to drive a component. I had used spreadsheet data as the input for the motor. But whenever I update the spreadsheet, I do not see the updated data in solidworks. How can we achieve this?
I am using this method on various occasions and it works fine. Now I want this table to be shown in the corresponding SW drawing derived from the originating SW part, where the Excel table was inserted into the drawing as an Ole Object. We've done that in the past, but I can't find it anywhere how this was done. Reverse engineering from such an existing drawing didn't help me either. Anyone for a clue?
Hi guys, I am building a SolidWorks part whose dimensions are calculated by complex equations, and I must do these calculations in Excel. I want to link those resulting dimensions from Excel to SolidWorks. I am wondering if one of the following methods is the better one: 1. Create a design table and link it to another Excel spreadsheet. Implies: Needing to open the design table every time you open the assembly, or the changes will not be made. 2. Have a macro to export Excel file into .txt file. Use the .txt file to import variable values into SolidWorks. I know both methods would work, but I'm mostly looking to know which one is the cleanest of the two, as in which one will give SolidWorks a better time.
OH WELL. I can actually cheat and change the extension of a variables file that I export, making it a .csv. It works just like a .txt file, except now I can mash all calculations in. >=D
Perfect Video! Clear, short and complete! Great job Thank you!
Hello ,
I ran into a problem with the import data option in motion study. I had used a motor to drive a component. I had used spreadsheet data as the input for the motor. But whenever I update the spreadsheet, I do not see the updated data in solidworks. How can we achieve this?
I believe you need to have both documents open at the same time
I am using this method on various occasions and it works fine. Now I want this table to be shown in the corresponding SW drawing derived from the originating SW part, where the Excel table was inserted into the drawing as an Ole Object. We've done that in the past, but I can't find it anywhere how this was done. Reverse engineering from such an existing drawing didn't help me either. Anyone for a clue?
did you find any solution?
GREAT VIDEO!! THANKS!
Thanks man, really don the job!
Hi guys,
I am building a SolidWorks part whose dimensions are calculated by complex equations, and I must do these calculations in Excel. I want to link those resulting dimensions from Excel to SolidWorks.
I am wondering if one of the following methods is the better one:
1. Create a design table and link it to another Excel spreadsheet.
Implies: Needing to open the design table every time you open the assembly, or the changes will not be made.
2. Have a macro to export Excel file into .txt file.
Use the .txt file to import variable values into SolidWorks.
I know both methods would work, but I'm mostly looking to know which one is the cleanest of the two, as in which one will give SolidWorks a better time.
OH WELL.
I can actually cheat and change the extension of a variables file that I export, making it a .csv. It works just like a .txt file, except now I can mash all calculations in. >=D
Second method, and more generally, using the import option is the best way to go ahead instead of the table stuff
Great !
good video
Nice
great!!
I've done this before in my CAD lesson. :)
Better than MS Excell is PTC Mathcad. Mathcad could be integrated with SolidWorks too.
how much did you pay the voice actor and why does he wisper