Is there a way for to transfer data from a BCOUNT into an excel spread sheet?

Is there a way for to transfer data from a BCOUNT into an excel spread sheet?

kaige_naidooCYGKB
Participant Participant
543 Views
2 Replies
Message 1 of 3

Is there a way for to transfer data from a BCOUNT into an excel spread sheet?

kaige_naidooCYGKB
Participant
Participant

Is there a way to transfer data from a table and transfer it into excel? also is the an API that can take a DWG and do a BCOUNT on a floor plan which includes multiple rooms (I can set up a rectangular block or polyline to mark the separate rooms) and transfer that data into an excel spreadsheet.

0 Likes
544 Views
2 Replies
Replies (2)
Message 2 of 3

pendean
Community Legend
Community Legend

Are you using FIELDs to generate the data you want from your Plines and shapes/"blocks"?

 

BCOUNT Express Tool (that only counts blocks) does not exist in the LT versions of AutoCAD AFAIK, also the topic of this forum: are you running another variant of AutoCAD? Or have a different LISP or Custom tool called BCOUNT?

Or are you typing BCOUNT but the command being triggered is COUNT, different, but you have to be watching the commandline to see https://help.autodesk.com/view/ACDLT/2024/ENU/index.html?guid=GUID-3A0C3460-6ABC-4D13-BF1F-D2BFCD399....

If you are using COUNT, are you asking how to export COUNTLIST command to Excel by chance?
https://help.autodesk.com/view/ACDLT/2024/ENU/index.html?guid=GUID-86778E28-1E40-4C06-80E8-FDEF2F0E3....

AutoCADLT only exports to EXCEL using ATTEXT command (and attributes inside blocks), explore it fully if you are indeed a user of LT variants in HELP https://help.autodesk.com/view/ACDLT/2024/ENU/index.html?guid=GUID-6FEA6520-430E-47E2-BA16-305508495....

I forgot to add, here is the full list of commands and variables that "count" in the LT versions of AutoCAD
https://help.autodesk.com/view//ACDLT/2024/ENU/?guid=GUID-C9A53FE1-6A33-4230-BAC9-300C995F1C85#:~:te....

HTH

0 Likes
Message 3 of 3

kaige_naidooCYGKB
Participant
Participant

Hi Pendean, 

 

Thanks for the help. It turns out I have been using the count command even though I had typed BCOUNT. I have managed to get AutoCAD to do what I needed using multiple count areas. I will try the ATTEXT command tomorrow when I have access to AutoCAD and I will let you know if it helps me

0 Likes