Welcome to the Onshape forum! Ask questions and join in the discussions about everything Onshape.
First time visiting? Here are some places to start:- Looking for a certain topic? Check out the categories filter or use Search (upper right).
- Need support? Ask a question to our Community Support category.
- Please submit support tickets for bugs but you can request improvements in the Product Feedback category.
- Be respectful, on topic and if you see a problem, Flag it.
If you would like to contact our Community Manager personally, feel free to send a private message or an email.
3D from Excel to Onshape
jacek_zagaja
Member Posts: 47 ✭✭
Below is Excel file with macro:
https://sphericalhorns.net/wp-content/uploads/2021/03/DrBA_JMLC_V303.zip
that computes cross section point cloud with parameters on Sheet1:
Points are on Sheet2 but hard to see gap between step size.
https://sphericalhorns.net/wp-content/uploads/2021/03/DrBA_JMLC_V303.zip
that computes cross section point cloud with parameters on Sheet1:
- Min. points per ellipse
- Ellipse step size [mm] - step in Z direction
Points are on Sheet2 but hard to see gap between step size.
Tagged:
0
Comments
-
There is a FeatureScript for reading .csv files. You have to bring your coordinates in the correct format, an example is included. The Loft has to be done as a separate feature with this CustomFeature.
https://cad.onshape.com/documents/e161fbe2d3ea5f28da279c93/v/be9e27c457dc6f53de95e809/e/8d2acc927cc9433b70245871
Principal Technical Services Engineer, EMEAI1 -
That's problem of that macro all point are in one file instead of each cross section in separate file.0
-
If you have each set on a different row or column, you should be able to still process each one from one csv. You might also consider just recreating all of the sheet's logic with Featurescript instead and ditching the sheet, but on a skim there's a lot going on there.0
-
Solidworks can import one curve through XYZ points. I would like do the same in Onshape but bulk to make a loft. Spline has to be closed type.0
-
Done, here's the doc:
https://cad.onshape.com/documents/ae2be4f95e789a8efda1315d/w/3cf31603c523c20e4099c20d/e/8f6f9236b006f146876f5554
The loft is still done manually (and I only used two of your shared tables). But here's a link to another article with a similar challenge including a FeatureScript that creates a loft based on your coordinate data.
https://forum.onshape.com/discussion/19542/spline-plus-cross-sections-for-loft#latest
Principal Technical Services Engineer, EMEAI1 -
From what I see you need manually add csv file just like in Solidworks - can't automate selecting all csv files?0
-
It probably wouldn't take much work to take the existing CSV import FS and modify it to support multiple CSV files. I wouldn't be surprised if someone with time on their hands went ahead and did that for you
0 -
If still interested, I can give you a hand to do it. It will not be too difficult to automate.
1
