Create Electric Single Line Diagram importing Excel file

[jtm2020hyo]

Is there a way to create a single line Electrical Diagram from an imported Excel file with LISP or similar?

[3wood]

Can you upload "before" and "after" files so people can get more information about it?

[devitg]

@jtm2020hyo . yes it is possible.

Give us , both xls , and dwg where and how to be done. 

[jtm2020hyo]

---

@3wood wrote:

Can you upload "before" and "after" files so people can get more information about it?

---

---

@devitg  wrote:
@jtm2020hyo . yes it is possible.

Give us , both xls , and dwg where and how to be done. 

---

Good morning.

I will create the "before" and "after" in .xls and .dwg and I'll send the files to you in a few hours

[jtm2020hyo]

hello   @devitg  @3wood 

This took me the entire day, but finally, I did. In theory, should be possible to draw any Single line diagram. if anyone helps me with the lisp I might create a SLD template for everyone.

PD: attached files

related links:

https://forums.autodesk.com/t5/visual-lisp-autolisp-and-general/create-electric-single-line-diagram-...

https://forums.autodesk.com/t5/revit-architecture-forum/create-electric-single-line-diagram-importin...

https://www.theswamp.org/index.php?topic=56014.0

[devitg]

@jtm2020hyo . Please upload the sample.dwg 

[jtm2020hyo]

---

@devitg wrote:

@jtm2020hyo . Please upload the sample.dwg 

---

I did not notice that was not uploaded.

attached here.

[jtm2020hyo]

... Any advance?   @3wood @devitg 

[3wood]

The second example in your drawing seem different from the other  2.

The leftmost of the excel has 2 circuits but the drawing only has 1. Is it correct?

[devitg]

@jtm2020hyo  I never , up now, could and can  guess what do you want to do . 

[jtm2020hyo]

---

@3wood wrote:

The second example in your drawing seem different from the other  2.

The leftmost of the excel has 2 circuits but the drawing only has 1. Is it correct?

---

yes, you are completely right.

[jtm2020hyo]

I was searching something like this:

description:

https://forums.autodesk.com/t5/autocad-architecture-forum/new-visio-data-visualizer/td-p/9620472

video:

https://www.youtube.com/watch?v=O2qWMFtyT3s

if someone was developing something similar maybe this add-in help. @devitg  @3wood 

[myra_parayno]

How did you transfer the data from spreadsheet into the drawing in autocad?

[Sea-Haven]

Yes you can GET and PUT cells from a excel spreadsheet, using Vlisp, likewise Excel can talk to Acad using a macro.

A good starting point is getexcel.lsp.

If you google you will find extensive answers to your question. If its a task you want start a new post as the request may have been already answered.