From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: "Colin S. Miller" Newsgroups: gmane.emacs.help Subject: Re: exporting from emacs to excel Date: Wed, 14 Jan 2009 20:12:57 +0000 Organization: SunSITE.dk - Supporting Open source Message-ID: <496e45d7$0$90275$14726298@news.sunsite.dk> References: NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: ger.gmane.org 1231965660 20546 80.91.229.12 (14 Jan 2009 20:41:00 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Wed, 14 Jan 2009 20:41:00 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Wed Jan 14 21:42:12 2009 Return-path: Envelope-to: geh-help-gnu-emacs@m.gmane.org Original-Received: from lists.gnu.org ([199.232.76.165]) by lo.gmane.org with esmtp (Exim 4.50) id 1LNCYt-00066g-Lt for geh-help-gnu-emacs@m.gmane.org; Wed, 14 Jan 2009 21:42:03 +0100 Original-Received: from localhost ([127.0.0.1]:55438 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LNCXc-0007aK-Tb for geh-help-gnu-emacs@m.gmane.org; Wed, 14 Jan 2009 15:40:44 -0500 Original-Path: news.stanford.edu!newsfeed.stanford.edu!goblin2!goblin.stu.neva.ru!news.net.uni-c.dk!dotsrc.org!filter.dotsrc.org!news.dotsrc.org!not-for-mail User-Agent: Mozilla-Thunderbird 2.0.0.19 (X11/20090103) Original-Newsgroups: gnu.emacs.help In-Reply-To: Original-Lines: 28 Original-NNTP-Posting-Host: 62.56.124.164 Original-X-Trace: news.sunsite.dk DXC=`QFed]OA0Q9XYXkC6[Mbh; YSB=nbEKnk; 4mi>jDOWoH7G1[Bg<0aH50\VT\m5_SIb6U_42Df:PaK8TcL2h5ahoT?kF_>m>CYcV?0SWS=c8CH_:`0n1WP2P:b:[h[A4f:f5g> Original-X-Complaints-To: staff@sunsite.dk Original-Xref: news.stanford.edu gnu.emacs.help:166008 X-BeenThere: help-gnu-emacs@gnu.org X-Mailman-Version: 2.1.5 Precedence: list List-Id: Users list for the GNU Emacs text editor List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Original-Sender: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Errors-To: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Xref: news.gmane.org gmane.emacs.help:61335 Archived-At: rustom wrote: > I want to write a bit of elisp to take a file/buffer in org-mode and > export the tables to an excel sheet. > > I know (very little) of how to write the code to make an excel sheet > from wscript. eg > giving wscript the following, opens a blank excel sheet: > > Set objExcel = CreateObject("Excel.Application") > objExcel.Workbooks.Add > objExcel.Visible = True > > Is there some easy/natural way to get this functionality inside elisp? Rustom, That is using DDE/OLE to control Excel. OLE (Object Linking and Embedding) uses DDE (Dynamic Data Exchange) to send messages between the applications. A very quick google reveled http://www.stat.uiowa.edu/~luke/xls/wxls/wxls/node12.html You might want to use DDESpy (part of Visual Studio) to see what your VB app is sending to Excel. However, that elisp module might not support enough of DDE to implement OLE. HTH, Colin S. Miller -- Replace the obvious in my email address with the first three letters of the hostname to reply.