Batch export EXCEL OLE TO excel file

Batch export EXCEL OLE TO excel file

likesela
Observer Observer
736 Views
2 Replies
Message 1 of 3

Batch export EXCEL OLE TO excel file

likesela
Observer
Observer

I have lots cad file(.dwg) each incloud a BOM (excel ole), i need batch export each BOM(excel ole) to each excel file (same file name.XLSX), anyone can help me ? i can Donate, please

0 Likes
737 Views
2 Replies
Replies (2)
Message 2 of 3

Ed__Jobe
Mentor
Mentor

In your dwg, you can't use OLECONVERT. Your only option is to use OLEOPEN and then use Excel to SaveAs. Also, in VBA and lisp, there is no way to work with the ole in a silent method. You can only script the OLEOPEN command and that will open the ole in Excel. So in a batch mode, you would end up with a bunch of instances of Excel that you would have to save the file and close the app. In other words, batch processing gets messy.

 

In NET, it can give you access to the actual OLE object and then you can access Microsoft's api's. If you ask in the NET forum, someone might be able to help you.

Ed


Did you find this post helpful? Feel free to Like this post.
Did your question get successfully answered? Then click on the ACCEPT SOLUTION button.
How to post your code.

EESignature

0 Likes
Message 3 of 3

aurocherie3
Community Visitor
Community Visitor

Hi, did you finally succeeded into batch export ?

I have the same need... (tried w/ python but no success for the moment...)

 

thanks

0 Likes