From mboxrd@z Thu Jan 1 00:00:00 1970 Path: news.gmane.org!not-for-mail From: Xah Lee Newsgroups: gmane.emacs.help Subject: Re: exporting from emacs to excel Date: Wed, 14 Jan 2009 12:21:19 -0800 (PST) Organization: http://groups.google.com Message-ID: <6c041653-184b-411f-bb1f-ce5042f5f79a@s1g2000prg.googlegroups.com> References: NNTP-Posting-Host: lo.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable X-Trace: ger.gmane.org 1231980484 5667 80.91.229.12 (15 Jan 2009 00:48:04 GMT) X-Complaints-To: usenet@ger.gmane.org NNTP-Posting-Date: Thu, 15 Jan 2009 00:48:04 +0000 (UTC) To: help-gnu-emacs@gnu.org Original-X-From: help-gnu-emacs-bounces+geh-help-gnu-emacs=m.gmane.org@gnu.org Thu Jan 15 01:49:17 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 1LNGQ2-0000UQ-Ij for geh-help-gnu-emacs@m.gmane.org; Thu, 15 Jan 2009 01:49:11 +0100 Original-Received: from localhost ([127.0.0.1]:51532 helo=lists.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LNGOm-0000JC-5E for geh-help-gnu-emacs@m.gmane.org; Wed, 14 Jan 2009 19:47:52 -0500 Original-Path: news.stanford.edu!newsfeed.stanford.edu!postnews.google.com!s1g2000prg.googlegroups.com!not-for-mail Original-Newsgroups: gnu.emacs.help Original-Lines: 40 Original-NNTP-Posting-Host: 24.6.175.142 Original-X-Trace: posting.google.com 1231964479 6911 127.0.0.1 (14 Jan 2009 20:21:19 GMT) Original-X-Complaints-To: groups-abuse@google.com Original-NNTP-Posting-Date: Wed, 14 Jan 2009 20:21:19 +0000 (UTC) Complaints-To: groups-abuse@google.com Injection-Info: s1g2000prg.googlegroups.com; posting-host=24.6.175.142; posting-account=bRPKjQoAAACxZsR8_VPXCX27T2YcsyMA User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Macintosh; U; PPC Mac OS X 10_4_11; en) AppleWebKit/525.27.1 (KHTML, like Gecko) Version/3.2.1 Safari/525.27.1, gzip(gfe), gzip(gfe) Original-Xref: news.stanford.edu gnu.emacs.help:166010 X-Mailman-Approved-At: Wed, 14 Jan 2009 19:45:47 -0500 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:61338 Archived-At: On Jan 14, 3:13 am, 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 =3D CreateObject("Excel.Application") > objExcel.Workbooks.Add > objExcel.Visible =3D True > > Is there some easy/natural way to get this functionality inside elisp? dont know what's wscript. Wikipedia says http://en.wikipedia.org/wiki/Windows_Script_File but if all you want is export some text formatted as some table in emacs to excell, that's really easy elisp. i dont use org-mode, so i'm not sure what format is its table. But basically, a table is just text with special markers to indicate row and column beginnings. in ascii format, typically a row is just a line, and column are delimited by comma. Typically known as csv format http://en.wikipedia.org/wiki/Comma-separated_values all app or spreadsheet that deals with table data can import and export this format. if you can give a concrete example of what your source format is, then perhaps me or others can show you the elisp code. It's probably just a 10 min job. Xah =E2=88=91 http://xahlee.org/ =E2=98=84