From mboxrd@z Thu Jan 1 00:00:00 1970 From: "Rustom Mody" Subject: exporting from org to excel Date: Thu, 15 Jan 2009 13:56:42 +0530 Message-ID: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Return-path: Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43) id 1LNNYu-0001Nu-Qf for emacs-orgmode@gnu.org; Thu, 15 Jan 2009 03:26:48 -0500 Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43) id 1LNNYt-0001NU-BE for emacs-orgmode@gnu.org; Thu, 15 Jan 2009 03:26:48 -0500 Received: from [199.232.76.173] (port=57171 helo=monty-python.gnu.org) by lists.gnu.org with esmtp (Exim 4.43) id 1LNNYt-0001NR-9c for emacs-orgmode@gnu.org; Thu, 15 Jan 2009 03:26:47 -0500 Received: from mx20.gnu.org ([199.232.41.8]:3714) by monty-python.gnu.org with esmtps (TLS-1.0:RSA_AES_256_CBC_SHA1:32) (Exim 4.60) (envelope-from ) id 1LNNYs-00044u-TM for emacs-orgmode@gnu.org; Thu, 15 Jan 2009 03:26:47 -0500 Received: from rv-out-0708.google.com ([209.85.198.240]) by mx20.gnu.org with esmtp (Exim 4.60) (envelope-from ) id 1LNNYr-0002Zw-1r for emacs-orgmode@gnu.org; Thu, 15 Jan 2009 03:26:45 -0500 Received: by rv-out-0708.google.com with SMTP id k29so1156664rvb.6 for ; Thu, 15 Jan 2009 00:26:42 -0800 (PST) Content-Disposition: inline List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: emacs-orgmode@gnu.org This is a cross post of something I asked on the emacs list. Since the questions are partly around emacs, partly org (and mostly WIN-XP :-) I hope its ok to cross-post. ------------------------------------- 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? --------------- Followup -------------- Thanks Colin, Paul, Xah for the comments and tips. Here are some clarifications. excel is not a choice its a given; emacs-org is the choice! The context: Our organization has a web-based system for logging hours which can be slow at times. It has a facility to upload the hours in an xls format so thats where the given comes from. So csv also is not an option in itself except as a hopping point between emacs and xls. Assuming I use that hopping point the task breaks up into 3: 1. Write elisp code to scrape an org mode file containing hours clocked (in a suitable format) and write it to a csv file (in a corresponding format) 2. Write a wscript script to read in the csv into excel and write it out as xls 3. Write a ??? script to upload the output of 2 to the server Even if we ignore 3, I was seeing what it would take to combine 1 and 2 into a 'one-click' solution (rather one-M-x solution) that would convert my org record into an xls file. Xah: Ive not really thought about 1 (and perhaps the better place to pursue it would be the org mode list). I will do that if the other parts seem workable. Colin: The link you sent seems to be some other lisp? Or does it work in elisp? ------------- The original http://groups.google.com/group/gnu.emacs.help/browse_thread/thread/e3c735777531d5f7#