Export Drawing components to excel or spreadsheet using command script.

[Arunkumar.BTQTLR]

Hi Team,
Currently we can able to export data in drawings using "Export to spreadsheet" link.
Is it possible to do the same process using script command,  like create .src file, on execution it save the information to excel.
Which is the correct command for data export to file using script?

Thanks,
Arunkumar.B

[Sea-Haven]

You will need a custom solution.

Your dwg's are different to mine so have no idea of what your trying to output to excel.

Yes it is possible to write direct to excel even down to adding worksheets in excel for say each dwg. 

If you can explain fully what object details your trying to export then some one may be able to help.

[Arunkumar.BTQTLR]

Hi Haven,
Our scenario is initially we have electric schematic dwg, later stages engineers do the changes to dwg, we have to compare both version of dwgs and read for changes like block or component removed or added or changes to any wires.

Show the readable difference to the engineers.

[pendean · Accepted solution]

@Arunkumar.BTQTLR Much like your other identical post making inquiries about using COMPARE command for this need, you will have to pay someone to develop a custom solution for you all if you are unable to contractually compel those that touch your drawings to clearly delineate and tag changes they made to your drawings for review and approval.

Speak with your legal counsel and review your contracts moving forward.

Good luck.

[Arunkumar.BTQTLR]

Thanks for your valuable replies Pendean and Haven.

[Sea-Haven]

Notepad ++ has a COMPARE program as an add on use it often but no idea how I would use it with say 2 dwg's. There must be 2 or more versions say with revisions. You could compare exported data but it needs to be of a similar pattern to work can have missing lines it detects those. As an example if you type Setvar ? * you will get a big list of variable settings so can compare say 2 dwgs or users.

Notepad ++ is free. 

Without some form of consistency of the output pattern not sure how to compare. Hence a custom report as a 1st stage.