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

kaige_naidooCYGKB — Wed, 03 Apr 2024 08:26:49 GMT

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.

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

pendean — Wed, 03 Apr 2024 13:03:39 GMT

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-D2BFCD399851#:~:text=Counts%20and%20highlights%20the%20instances%20of%20the%20selected%20object%20in%20the%20drawing.

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-FDEF2F0E3D38#:~:text=Opens%20the%20Count%20palette%20to%20display%20and%20manage%20the%20counted%20blocks.

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-305508495156#:~:text=Extracts%20attribute%20data%2C%20informational%20text%20associated%20with%20a%20block%2C%20into%20a%20file.

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#:~:text=These%20commands%20and%20system%20variables%20are%20used%20to%20count%20objects%20in%20the%20drawing.

HTH

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

kaige_naidooCYGKB — Wed, 03 Apr 2024 14:15:36 GMT

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

topic Re: Is there a way for to transfer data from a BCOUNT into an excel spread sheet? in AutoCAD LT Forum

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

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

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