topic Re: Express Tools Export Attributes in AutoCAD Forum

Express Tools Export Attributes

crawfordscott — Mon, 08 Apr 2024 15:11:09 GMT

Hi all,

I’m trying to export Attributes from a drawing using the Express Tools version rather than the native Autocad command. (For the 1st time)

Something strange is happening.

When I export to .txt file and then load into excel, everything seems fine until I try to add

up any quantities.

On the attached example I am trying to add the column of Cable lengths.

If I highlight the column I want to add up and enter Sum , Excel is changing all the cells to 0 (ZERO) and returning the addition as Zero.

It is also not allowing me to format the numbers to zero decimal places.

Numbers are numbers, not text.

Is this normal behaviour when using the Express Tools version?

Anybody?

Thanks, in anticipation.

Crawford

Re: Express Tools Export Attributes

pendean — Mon, 08 Apr 2024 15:21:36 GMT

Can you share the source DWG portion that you used please? Having only the final result in Excel is not enough to confirm your results independently.

Re: Express Tools Export Attributes

TheCADnoob — Mon, 08 Apr 2024 15:31:40 GMT

This is due to how you are importing your data into excel.

You data is defined in the table as text per the query editor.

Re: Express Tools Export Attributes

TheCADnoob — Mon, 08 Apr 2024 15:45:11 GMT

To fix (if you want to stick with the way you imported your data) click on query in excel ribbon

Then click on edit

This will open the query editor. First what you will want to do is convert the first row to column header so that it will remove that text from your data and help identify your columns.

Next you will want to go to your column and change the value type. After I converted the first row to headers It automatically converted my data to numbers, but if yours does not, go to the column and right click on the column, then click change type

When you are done click close and load.

You will see your column is now labeled in your table, and the sum formula should now work.

Re: Express Tools Export Attributes

crawfordscott — Mon, 08 Apr 2024 15:50:13 GMT

Hi CADnoob,
Thanks for that.
Not got time at the moment but wiil report back when I do.
Regards
Crawford
**********************************************************************
This email and files transmitted with it are confidential and are intended for the sole use of the individual or organisation to whom they are addressed.
If you have received this eMail in error please notify the sender immediately and delete it without using, copying, storing, forwarding or disclosing its contents to any other person.
The Council has endeavoured to scan this eMail message and attachments for computer viruses and will not be liable for any losses incurred by the recipient.
********************************************************************** **********************************************************************
This email and files transmitted with it are confidential and are intended for the sole use of the individual or organisation to whom they are addressed.
If you have received this eMail in error please notify the sender immediately and delete it without using, copying, storing, forwarding or disclosing its contents to any other person.
The Council has endeavoured to scan this eMail message and attachments for computer viruses and will not be liable for any losses incurred by the recipient.
**********************************************************************

Re: Express Tools Export Attributes

crawfordscott — Mon, 15 Apr 2024 09:06:39 GMT

Thanks very much for that.