Express Tools Export Attributes

[crawfordscott]

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

[pendean · Accepted solution]

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.

[TheCADnoob · Accepted solution]

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. 

[TheCADnoob · Accepted solution]

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. 

[crawfordscott]

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.
**********************************************************************

[crawfordscott]

Thanks very much for that.

C