将 Excel 数据导入 AutoCAD 需要阅读哪些资源?

发布于 2024-11-16 19:59:30 字数 217 浏览 7 评论 0原文

为项目做一些前期工作。我在一家工程公司工作,工程师们制作 Excel 电子表格,其中包含有关项目使用的材料的信息(称为电缆明细表)。该数据将交给绘图员,他们将其转换为 AutoCAD 绘图。如果电子表格发生更改,绘图员需要仔细更改每张图纸。据说这需要大量的手工工作。

我对 AutoCAD 知之甚少,想知道我应该做哪些研究来看看自动化这个过程是否以及有多难。如果有课程或书籍可用,我希望有人指出这个方向。

Doing some preliminary work on a project. I work at an engineering firm and the engineers build Excel spreadsheets containing information on what material the project uses (called cable schedules). This data is handed over to the drafter and they turn it into an AutoCAD drawing. If a change in the spreadsheet gets made the drafter needs to meticulously change every drawing. This is supposedly a lot of manual work.

I know little of AutoCAD and was wondering what research I should do to see if and how hard it would be to automate this process. If a course or books are available I'd like to be pointed in that direction.

如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。

扫码二维码加入Web技术交流群

发布评论

需要 登录 才能够评论, 你可以免费 注册 一个本站的账号。

评论(3

北座城市 2024-11-23 19:59:30

如果您只想在 AutoCAD 中将一些 Excel 数据显示为表格,则该功能已通过 AutoCAD 的 DATALINK 命令。

如果您想自动化比这更复杂的事情,请查看 Autodesk 的 ObjectARX< /a>.它用于创建 AutoCAD 插件,可以从其网站免费下载。 ObjectARX 公开 .NET 和本机 C++ API。它是 AutoCAD 本身所基于的库。

Chris Neilsen 提到的 RealDWG API(以前称为 ObjectDBX)是 ObjectARX 中可用功能的子集。它允许您在 AutoCAD 进程之外读取和操作 AutoCAD 图形。然而,RealDWG 并不是免费的。

至于文档,ObjectARX 附带的帮助文件和示例非常好,并且 Autodesk 和 AUGI 论坛上有大量的编程讨论。如果您的雇主是 ADN 会员,您会在那里找到更多信息,包括专业支持。

If you're looking to simply display some Excel data as a table in AutoCAD the functionality is already built in via AutoCAD's DATALINK command.

If you want to automate something more complicated than that check out Autodesk's ObjectARX. It's used to create AutoCAD plugins and can be downloaded for free from their website. ObjectARX exposes both .NET and native C++ APIs. It is the library that AutoCAD itself is based on.

The RealDWG API (formally ObjectDBX) that Chris Neilsen mentioned is a subset of the functionality available in ObjectARX. It allows you to read and manipulate AutoCAD drawings outside of an AutoCAD process. RealDWG is, however, not free.

As for documentation, the help files and samples included with ObjectARX are pretty good and there is a fair amount of programming discussion on the Autodesk and AUGI forums. If your employer is an ADN member you'll find a lot more information there, including professional support.

短暂陪伴 2024-11-23 19:59:30

请参阅此SO Question,了解有关访问绘图文件的库的讨论,包括ODA
AutoDesk RealDWG 以及其他一些

See this SO Question for a discussion of libraries to access drawing files, including ODA and
AutoDesk RealDWG and a few others

神爱温柔 2024-11-23 19:59:30

我用于从 AutoCAD 操作 Excel 的库可在此处下载:

http ://download.cnet.com/KozMos-VXLLS/3000-2077_4-94214.html

我发现使用这个要容易得多在 VLIDE 内部操作 Excel 数据(无论它是否与 AutoCAD 有关),而不是使用 Excel 的 VBA(可怕的)或脚本和互操作的组合。

我确实必须纠正其中的一两个错误,所以请记住这一点......

The library I use for manipulating Excel from AutoCAD is available as a download here:

http://download.cnet.com/KozMos-VLXLS/3000-2077_4-94214.html

I found it far easier to use this inside the VLIDE to manipulate Excel data (whether it has anything to do with AutoCAD or not), than to use Excel's VBA (a horror) or a combination of scripting and interop.

I did have to fix one or two mistakes in there, so bear that in mind...

~没有更多了~
我们使用 Cookies 和其他技术来定制您的体验包括您的登录状态等。通过阅读我们的 隐私政策 了解更多相关信息。 单击 接受 或继续使用网站,即表示您同意使用 Cookies 和您的相关数据。
原文