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.
Is there a way to paste some data into a generic table drawing other than one cell at a time?

in Drawings
I have a table of data generate in excel (30 rows x 5 columns) and I want to put this on a drawing, however I can't seem to find a way to paste data across multiple cells...
I can paste a bunch of data into one cell of the drawing table but that's not helpful... I refuse to believe it can't be done, am I missing something obvious?
I really don't want to copy/paste 150 times!
I can paste a bunch of data into one cell of the drawing table but that's not helpful... I refuse to believe it can't be done, am I missing something obvious?
I really don't want to copy/paste 150 times!
1
Comments
Haha! I also can't seem to find a way to do this?
Thanks for trying! I got confirmation it's not currently possible, which is pretty crappy and disappointing...
My workaround was to paste each column into its own cell so I only had to paste 5 times. At least that way it's still text, it's just one row...
You really would expect that if you select data from a table and paste into another table structure it would figure out what you are trying to do. Especially since copy pasting in Onshape tables (mostly) works for config/BOM tables!
Twitter: @BryanLAGdesign
Interesting, I might have to check that out, although it seems like a very convoluted way to get to what I want...
It seems like a fundamental design limitation in the drawing tables: you can select multiple cells to apply formats etc... But you can't affect the data in a cell without first "entering" that cell. Even selecting a cell and hitting the delete key doesn't affect the data like you would expect so it's no wonder you can't paste across multiple cells.
Twitter: @BryanLAGdesign
Seeing you could import a JSON I was hoping to circumvent the google sheet part (it's not really part of my workflow here). It's easy enough to convert data to a JSON table so I tried that but I got an "unable to retrieve BOM data" error.
Part of the issue might be that it's intended to be a BOM rather than just a generic table... I'll have to dig into a it a bit more to see if I can spoof it...
EDIT:
@bryan_lagrange
Can you paste the raw JSON code it spat out in here (should just be plain text)? It looks like there are a number of ways to describe tables in JSON and it might be expecting a specific one...
Thanks,
Twitter: @BryanLAGdesign
Thanks, that looks like a lot of extra "baggage" just to display 3 cells!
Did a quick attempt at "hacking" it but didn't work... I'm going to do an IR to allow inserting a "generic table" in a drawing (from a JSON... or CSV)