Dynamic Blocks

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

data extraction from dynamic blocks

418 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
Distinguished Mentor
steven-g
Posts: 612
Registered: ‎05-11-2009
Message 2 of 2 (395 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
Post to the Community

Have questions about Autodesk products? Ask the community.

New Post
Need installation help?

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