Dynamic Blocks

Reply
New Member
cuneydo
Posts: 1
Registered: ‎06-14-2012
Message 1 of 2 (370 Views)

data extraction from dynamic blocks

370 Views, 1 Replies
06-14-2012 01:11 AM

 

Hello,

 

In my dynamic block, there are 6 different visibility of a wardrobe with 6 different prices. When I extract a data, I want to see the prices in excel row by row in a one column. However Autocad shows them in 3 column as below:

 

CountNamePRICEPRICE(1)PRICE(2)Visibility
1Block Wardrobe200 YTL150 YTL350 YTL3
1Block Wardrobe200 YTL150 YTL350 YTL2
1Block Wardrobe200 YTL150 YTL350 YTL1
Valued Mentor
steven-g
Posts: 494
Registered: ‎05-11-2009
Message 2 of 2 (347 Views)

Re: data extraction from dynamic blocks

06-16-2012 07:05 AM in reply to: cuneydo

That is how data is extracted.

You get

A B C D E

A B C D E

A B C D E

etc.

 

If you want

A A A

B B B

C C C

D D D

E E E

etc. Then you will need to do that from within excel. The easiest way would be to copy the data in excel go to a new sheet and use paste-transpose, and where that is varies with different versions of excel.

Regards Steven Gray
Setting Out (Joinery Manufacturing)
Autocad 2013LT
Windows 7 professional

You are not logged in.

Log into access your profile, ask and answer questions, share ideas and more. Haven't signed up yet? Register

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 to get help installing your software.

Ask the Community