ASE, SQL, OLE, ADE

Reply
*Inc., Viljoen Architect
Message 1 of 5 (80 Views)

Excel 97 --> R2000 problems/questions

80 Views, 4 Replies
01-17-2000 01:44 PM
Hi everyone,

I have a question about using Excel charts. It's nice to try and get the
automation of Excel into AutoCAD, but it is difficult to figure out. I have
a chart done up in Excel...not too big. about 25 rows & maybe 12 columns.
When inserted, you don't get to see the whole chart, only a small portion of
it. If I close the drawing and then reopen it, the whole chart is visible,
but it has tons of empty cells to make it (the chart) square shaped. I have
no idea how to get R2000 to only display a certain range of cells. Is there
even a way to do this? It's driving me nuts!

Thanks in advance.

Brian

--------------------
Brian Majerus
Dipl. Arch. Tech.

Viljoen Architect Inc.
300 A Wilson Avenue
Downsview, Ontario M3H 1S8
Tel: (416) 630-2255 extension 147
Fax: (416) 630-4782

Direct Email: bmajerus@viljoenarch.com
General Email: info@viljoenarch.com

Viljoen Architect Inc. retains the copyright in all drawings, plans,
sketches, and all digital information. They may not be used for any
other projects or purposes without the written consent of Viljoen
Architect Inc. Failure to do so will result in legal action.
*Support, Fletcher Clover - Autodesk GIS
Message 2 of 5 (80 Views)

Re: Excel 97 --> R2000 problems/questions

01-18-2000 09:40 AM in reply to: *Inc., Viljoen Architect
Hi,

To display the data contained in the Excel spreadsheet, there must be at
least one named range of cells. This name corresponds to a table name in
Access and is displayed under the Tables branch of the Data Source.
Create at least one named range of cells in the Excel spreadsheet (do not
use DATABASE or other reserved words when naming the cell range).
Important: When you select a range of cells to name, select one row and one
column either side of the extents of the data in the range you are naming.
Otherwise, even though the name of the range is shown as a table below the
Data Source in the Project Manager; there is no content
when the table is opened.

To create a named range of cells in Microsoft Excel, select the cells and
then name them using the Name Box to the left of the formula bar. When you
attach an Excel file with at least one named range of cells, there is a
table with the relative fields and values in the Data Sources section of the
Project Workspace. This table represents the named range of cells.

I hope this helps,

Fletcher

Viljoen Architect Inc. wrote in message
news:8602g1$a2p20@adesknews2.autodesk.com...
> Hi everyone,
>
> I have a question about using Excel charts. It's nice to try and get the
> automation of Excel into AutoCAD, but it is difficult to figure out. I
have
> a chart done up in Excel...not too big. about 25 rows & maybe 12 columns.
> When inserted, you don't get to see the whole chart, only a small portion
of
> it. If I close the drawing and then reopen it, the whole chart is
visible,
> but it has tons of empty cells to make it (the chart) square shaped. I
have
> no idea how to get R2000 to only display a certain range of cells. Is
there
> even a way to do this? It's driving me nuts!
>
> Thanks in advance.
>
> Brian
>
>
> --------------------
> Brian Majerus
> Dipl. Arch. Tech.
>
> Viljoen Architect Inc.
> 300 A Wilson Avenue
> Downsview, Ontario M3H 1S8
> Tel: (416) 630-2255 extension 147
> Fax: (416) 630-4782
>
> Direct Email: bmajerus@viljoenarch.com
> General Email: info@viljoenarch.com
>
> Viljoen Architect Inc. retains the copyright in all drawings, plans,
> sketches, and all digital information. They may not be used for any
> other projects or purposes without the written consent of Viljoen
> Architect Inc. Failure to do so will result in legal action.
>
>
>
*Fleming, Jon
Message 3 of 5 (80 Views)

Re:

01-18-2000 02:37 PM in reply to: *Inc., Viljoen Architect
I think he is doing a pasted OLE link rather than a database-type lookup.

jrf
Member of the Autodesk Discussion Forum Moderator Program

In article <8628ii$fre4@adesknews2.autodesk.com>, Fletcher Clover - Autodesk
GIS Product Support wrote:
> Hi,
>
> To display the data contained in the Excel spreadsheet, there must be at
> least one named range of cells. This name corresponds to a table name in
> Access and is displayed under the Tables branch of the Data Source.
> Create at least one named range of cells in the Excel spreadsheet (do not
> use DATABASE or other reserved words when naming the cell range).
> Important: When you select a range of cells to name, select one row and one
> column either side of the extents of the data in the range you are naming.
> Otherwise, even though the name of the range is shown as a table below the
> Data Source in the Project Manager; there is no content
> when the table is opened.
>
> To create a named range of cells in Microsoft Excel, select the cells and
> then name them using the Name Box to the left of the formula bar. When you
> attach an Excel file with at least one named range of cells, there is a
> table with the relative fields and values in the Data Sources section of the
> Project Workspace. This table represents the named range of cells.
>
> I hope this helps,
>
> Fletcher
>
> Viljoen Architect Inc. wrote in message
> news:8602g1$a2p20@adesknews2.autodesk.com...
> > Hi everyone,
> >
> > I have a question about using Excel charts. It's nice to try and get the
> > automation of Excel into AutoCAD, but it is difficult to figure out. I
> have
> > a chart done up in Excel...not too big. about 25 rows & maybe 12 columns.
> > When inserted, you don't get to see the whole chart, only a small portion
> of
> > it. If I close the drawing and then reopen it, the whole chart is
> visible,
> > but it has tons of empty cells to make it (the chart) square shaped. I
> have
> > no idea how to get R2000 to only display a certain range of cells. Is
> there
> > even a way to do this? It's driving me nuts!
> >
> > Thanks in advance.
> >
> > Brian
> >
> >
> > --------------------
> > Brian Majerus
> > Dipl. Arch. Tech.
> >
> > Viljoen Architect Inc.
> > 300 A Wilson Avenue
> > Downsview, Ontario M3H 1S8
> > Tel: (416) 630-2255 extension 147
> > Fax: (416) 630-4782
> >
> > Direct Email: bmajerus@viljoenarch.com
> > General Email: info@viljoenarch.com
> >
> > Viljoen Architect Inc. retains the copyright in all drawings, plans,
> > sketches, and all digital information. They may not be used for any
> > other projects or purposes without the written consent of Viljoen
> > Architect Inc. Failure to do so will result in legal action.
> >
> >
> >
>
*Furman, Paul
Message 4 of 5 (80 Views)

Re: Excel 97 --> R2000 problems/questions

01-18-2000 06:39 PM in reply to: *Inc., Viljoen Architect
Brian,

OLE in acad is crummy. Paste special as autocad entities for the best look (& no
link) or look into add-on programs such as at http://www.dotsoft.com Perhaps
with the next release oc acad... I don't believe 2000 fixes this situation?

Paul

"Viljoen Architect Inc." wrote:

> Hi everyone,
>
> I have a question about using Excel charts. It's nice to try and get the
> automation of Excel into AutoCAD, but it is difficult to figure out. I have
> a chart done up in Excel...not too big. about 25 rows & maybe 12 columns.
> When inserted, you don't get to see the whole chart, only a small portion of
> it. If I close the drawing and then reopen it, the whole chart is visible,
> but it has tons of empty cells to make it (the chart) square shaped. I have
> no idea how to get R2000 to only display a certain range of cells. Is there
> even a way to do this? It's driving me nuts!
>
> Thanks in advance.
>
> Brian
>
> --------------------
> Brian Majerus
> Dipl. Arch. Tech.
>
> Viljoen Architect Inc.
> 300 A Wilson Avenue
> Downsview, Ontario M3H 1S8
> Tel: (416) 630-2255 extension 147
> Fax: (416) 630-4782
>
> Direct Email: bmajerus@viljoenarch.com
> General Email: info@viljoenarch.com
>
> Viljoen Architect Inc. retains the copyright in all drawings, plans,
> sketches, and all digital information. They may not be used for any
> other projects or purposes without the written consent of Viljoen
> Architect Inc. Failure to do so will result in legal action.
*DS
Message 5 of 5 (80 Views)

Re:

02-03-2000 07:44 PM in reply to: *Inc., Viljoen Architect
Actually, there are two to blame. Microsoft is addressing some known issues
with OLE in Windows 2000, while Autodesk is working on some issues with OLE
in the next release of AutoCAD (I'm told by unnamed sources). One of these
"issues" relates to the problems of plot rotation with embedded or linked
OLE objects such as Word and Excel documents or clips.

DS
Announcements
Are you familiar with the Autodesk Expert Elites? The Expert Elite program is made up of customers that help other customers by sharing knowledge and exemplifying an engaging style of collaboration. To learn more, please visit our Expert Elite website.
Need installation help?

Start with some of our most frequented solutions or visit the Installation and Licensing Forum to get help installing your software.