OLE object (Excel) only showing x amount of lines

[Anonymous]

I know this has been discussed before, but I cannot find the answer here
anymore.

I am linking an ole object (excel spreadsheet) and I am only getting the
first 13 rows of 25.

[Anonymous]

From: http://www.dotsoft.com/xl2cad.htm

OLE has it's limitations!

OLE Size is limited to 'a page worth' meaning large spreadsheets lose rows
and columns.
Linked OLE won't grow/shrink as you add/delete rows and columns.
Plotting problems in which OLE appears 'grainy', 'fuzzy', etc.
If the drawing is plotted rotated, the OLE does not rotate.
Drawings with embedded OLE objects make huge multi-megabyte files.
OLE Objects can 'bleed through' multiple layouts in AutoCAD, showing up in
places where they don't belong.
Recipients of your drawings (especially on other CAD systems) may have
problems with the OLE representation.


--

Murph
http://map3d.wordpress.com/


"Jason" wrote in message
news:6347902@discussion.autodesk.com...
I know this has been discussed before, but I cannot find the answer here
anymore.

I am linking an ole object (excel spreadsheet) and I am only getting the
first 13 rows of 25.

[sfore]

See pic. Mine has 120 rows and 28 columns. I had issues when trying to bring it in thru Insert/OLE Object. So what I did was opened Excel, clicked and dragged what I wanted, right-clicked copy. Then I went to Edit/Paste Special in cad. The OLE dialog box appeared and I toggled 'paste link' and brought it in paperspace and did some resizing. It's not embedded, it's still linked so any changed made to the excel file will reflect in the excel sheet in cad. If I would've added anymore rows to it, I would've had to separate it into 2 sheets. The text in the OLE was equivelent to a .08 text size or just shy. It was more like a .07, but you could still read it. The contractor may not like it though.

Shawn

[roarznz · Accepted solution]

Hi, I encountered this problem yesterday with a spreadsheet and I may have a solution.

The issue seems to be with the "zoom" of the OLE object. When you create the OLE, it shows only a certain area of cells and it won't let you change the viewed area (remember it's by area, not by the amount of cells).

I've found that this "zoom area" is set after the first time you edit the OLE. When you first edit the OLE, it automatically sets a "zoom area" focussed only on the cells which have been edited.

1) decide the size that you want the table to be (I did it in mm)

2) decide how many columns and how many rows you want

3) decide the size of the columns and rows in autocad (I did it in mm)

These first 3 steps are the hardest. I cheated by creating an autocad table and using that to decide my dimensions

4) creat a new OLE microsoft excell worksheet (important: do not close or save the excell window until step 😎

5) If it's not open already, Open the OLE to edit it. (Right click on the OLE, then OLE, then open)

6) put an "x" in the top left cell and one in the bottom right cell based on the number of columns and rows you decided on in step 2. (the OLE "zoom area" will be set around these two "x")

7) Adjust the columns and rows to the heights and widths you chose in step 3

😎 save and close the OLE Excell window

Now, the OLE in AutoCad should show the two cells containing "x" in each corner, but its geometry will be all messed up.

9) in Autocad select the OLE and open it's properties. Set the "lock aspect" to NO and enter the height and width into the properties. Then set "lock aspect" back to YES

11) copy the table and delete the original (this sets its size percentages back to 100% x 100% so that it's nice and tidy 🙂

Here's my one:

I wanted a table 780mm wide by 500mm high with 38 columns and 7 rows.

All columns 20mm wide except the 1st column which is 40mm wide. (which adds up to 780mm wide)

Row 1 = 35mm high, Row 2 = 55mm, Rows 3-5 = 60mm, Rows 6-7 = 115mm (which adds up to 500mm high)

Following the steps above, i've attached a picture of what it looks like

[Joe-Bouza]

Paste Link as acad entities and its a beautiful autocad table

[Joe-Bouza]

Thanks for the list, Murph

[Joe-Bouza]

When they come to me in our office and turn them away stating "I do not support OLE"

[Anonymous]

Thank you for spelling out exactly how to "teach" OLE how many rows & columns to show from the spreadsheet. Really appreciate it!

--Linda

[TerryDotson]

... turn them away stating "I do not support OLE"

My statement is "I would use a crayon before I would use OLE"

[MikeEvansUK · Accepted solution]

I agree, I have had multiple problems in the past with Ole documents rotating on plots etc.

I would just use Pastespec as Autocad objects then check link and get a nice table linked to the excel sheet.

If you open the excel sheet and create a named selection, select it and copy you can use this to link correctly in autocad, when the named selection range updates in excel it will update in autocad.

M.

[Joe-Bouza]

Me too.
And often I I by pass excel all together. Really, with copy, fill and formula in acad tables sometimes I wonder why use excel at all?

[lossbit]

what i am do is, open the ole and then re select and copy, then paste back in the dwg.

simple as that.

regards,

EZ

[Joe-Bouza]

Not sure if you are asking a question or making a statement?

[igor.lshz]

1. open OLE
2. make  desired changes
3. choose area should be presented
4. ctrl+C
5. return to drawing
6. ctrl+V

[bforr]

how nice that is. Thanks.

[Joe-Bouza]

Usually the math I do is so simple I may even forego Excel and do the calcs right in the acad table