Importing Excel Table as a sketch

juan_nolibos

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

3dcad

I think you need to first paste into some vector graphic software and convert 'sheet' to dxf and insert that into Onshape sketch.

_Ðave_

You could import it as a pic into a sketch by first taking a screenshot of the spreadsheet.

juan_nolibos

_Ð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

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

Nope, I stand corrected. Looks like you can't enter more than 250 characters and tabs don't translate. Oh well.

juan_nolibos

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.

3dcad

I think you need to first paste into some vector graphic software and convert 'sheet' to dxf and insert that into Onshape sketch.