Community
Dynamic Blocks Forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

data extraction from dynamic blocks

1 REPLY 1
Reply
Message 1 of 2
cuneydo
984 Views, 1 Reply

data extraction from dynamic blocks

 

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
1 REPLY 1
Message 2 of 2
steven-g
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.

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

”Boost

 

”Tips

 

”Services