Topic: Truely Table Export

[xiaxiang]

Long time  I did not come to the forum
First say "Hi !" to all.
I have a question and I can not solve it .
I will post a table with line and text entity in one dwg drawing,
and a excel table which has been dealed with the software "TableBuilder" ,
this website http://www.cadig.com/products/tablebuilder.php
How can I use autolisp to Process this drawing?
I want that the content , format of the Table can be exported,
the same as the table in the dwg drawings.
Copy another lisp code to here ,from the author Fixo, forums augi.
this website ,15#
http://forums.augi.com/showthread.php?136467-lisp-table-help/page2
 
Distress for a long time
Seems  cannot solve the problem using lisp.
 
Many Thanks.

[irneb]

That's going to be an incredibly painful task ... that "table" is no table. It's lines and text, so the lisp will have to sort through which text goes in what row/column by somehow figuring out from the xy position. But then there's "joined" cells (especially in the heading), so it's no simple task at all.

[xiaxiang]

That's going to be an incredibly painful task ... that "table" is no table. It's lines and text, so the lisp will have to sort through which text goes in what row/column by somehow figuring out from the xy position. But then there's "joined" cells (especially in the heading), so it's no simple task at all.

Yes,I agree.
To Merge cells is very hard for Judgment and Determin.
Thanks for reply,irneb
How about your Caddons software?
You helped much more with Auto Increment suit in the Augi forum...
Many thanks

[irneb]

Glad you liked it, I wish I could snip off some time to fix some of the bugs / add requests.

[HasanCAD]

Thanks for sharing

[jvillarreal]

I had time today to work on a q&d solution for your plain table to csv routine..It should at least be a good start as its currently incompatible with blocks. Its my convert old table routine, implementing code from fixo's table export routine.

As the merge method used requires that all text be deleted, I cheated by simply performing an undo to replace the text at the end. 

Hope you can use it for your final routine.

[xiaxiang]

I had time today to work on a q&d solution for your plain table to csv routine..It should at least be a good start as its currently incompatible with blocks. Its my convert old table routine, implementing code from fixo's table export routine.

As the merge method used requires that all text be deleted, I cheated by simply performing an undo to replace the text at the end. 

Hope you can use it for your final routine.

Sorry for late.
Thanks for your routine,Juan!
I will post my own code tomorrow because some minor matters still exit,for an example,I still failed when bring the color of
the cad text entity to excel text.Others are correct.
My code is stolen from you and fixo.
I think that it will be better when using redraw function to hide the text than delete them and undo.
And,I still cannot understand the meaning of two variables, hmergelist and vmergelist ,such as this list ((0 7 0 6) (0 3 0 2)),
can you explain them in detail?
Next I hope that it will be compatible with blocks.
Your code is a wonderful answer for this topic,Juan,Thanks!

[M-dub]

Have a look at T.Willey's ExportTextTable
http://www.theswamp.org/index.php?topic=24792.msg298916#msg298916

[xiaxiang]

Have a look at T.Willey's ExportTextTable
http://www.theswamp.org/index.php?topic=24792.msg298916#msg298916

Thanks for reply.Serious study of that post

[jvillarreal]

You're welcome
I'm not sure that using redraw will prevent object selection but let me know how it goes.
(0 7 0 6) = Horizontal merge, merge row 0 column 7 with row 0 column 6
Here's the same routine with minor changes to be compatible with blocks.

*Edit*
I needed to re-localize the hmergelist and vmergelist variables.

[xiaxiang]

You're welcome

OK,post my code here.
There is no rigorous test,and it's not compatible with blocks.
but whick kind of blocks would it be compatible with?
I'm not certain.
 Thanks:-)

[jvillarreal]

OK,post my code here.

Nicely done xiaxiang.

There is no rigorous test,

FYI: Although it's probably just an issue between the program versions we're using, some of the colors exported to excel are off.
Using AutoCAD 2010 and 2011, Excel 2007: Blue->Red, Red->Blue, many others->red or Magenta

..it's not compatible with blocks.
but whick kind of blocks would it be compatible with?
I'm not certain.

Blocks should probably be exported as they are when using AutoCAD's "tableexport".

The next step could be to add cell rotation/orientation and border color.

Thanks for taking time to put this together. It'll help me export our Microstation quantity tables  to excel.

[xiaxiang]

Sorry for this lately reply for the reason of holiday，Juan
 
I will think about seriously what you have suggested to me.
The stuff will be updated in next version.
Always cannot sit down alone for programming.
Thanks for your help，Juan！

[xiaxiang]

Nicely done xiaxiang.

OK,V1.1

[je_cusi]

Thanks for sharing!!!