Welcome to the Onshape forum! Ask questions and join in the discussions about everything Onshape.

First time visiting? Here are some places to start:
  1. Looking for a certain topic? Check out the categories filter or use Search (upper right).
  2. Need support? Ask a question to our Community Support category.
  3. Please submit support tickets for bugs but you can request improvements in the Product Feedback category.
  4. 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.

Importing Excel Table as a sketch

juan_nolibos
juan_nolibos Member Posts: 3 ✭
in Community Support
Hi to all.
I want to know if its posible to import an excel table as a sketch in Onshape.
I want to make a table of fractions multiplications like the one above without having to tipe each one.


X 1/2 1/3 1/4 1/5 1/6 1/7 1/8 1/9
1/2 1/ 4 1/ 6 1/ 8 1/10 1/12 1/14 1/16 1/18
1/3 1/ 6 1/ 9 1/12 1/15 1/18 1/21 1/24 1/27
1/4 1/ 8 1/12 1/16 1/20 1/24 1/28 1/32 1/36
1/5 1/10 1/15 1/20 1/25 1/30 1/35 1/40 1/45
1/6 1/12 1/18 1/24 1/30 1/36 1/42 1/48 1/54
1/7 1/14 1/21 1/28 1/35 1/42 1/49 1/56 1/63
1/8 1/16 1/24 1/32 1/40 1/48 1/56 1/64 1/72
1/9 1/18 1/27 1/36 1/45 1/54 1/63 1/72 1/81

I tried pasting directly as text but diidnt get right

Best Answer

Answers

  • _Ðave_
    _Ðave_ Member, Developers Posts: 712 ✭✭✭✭
    You could import it as a pic into a sketch by first taking a screenshot of the spreadsheet.
  • juan_nolibos
    juan_nolibos Member Posts: 3 ✭
    _Ðave_ said:
    You could import it as a pic into a sketch by first taking a screenshot of the spreadsheet.
    But it will sketch it the numbers automatically or i will have to draw each number ??

  • mahir
    mahir Member, Developers Posts: 1,324 ✭✭✭✭✭
    Have you tried just copy/pasting the text? If that doesn't work, paste into Notepad first, and then copy paste the unformatted text into an Onshape text feature.
  • mahir
    mahir Member, Developers Posts: 1,324 ✭✭✭✭✭
    Nope, I stand corrected. Looks like you can't enter more than 250 characters and tabs don't translate. Oh well.
  • juan_nolibos
    juan_nolibos Member Posts: 3 ✭
    mahir said:
    Nope, I stand corrected. Looks like you can't enter more than 250 characters and tabs don't translate. Oh well.
    Thks,
    I will try today at night inserting the \t and \n to make the tabs and new lines.

Categories