From: "Rustom Mody" <firstname.lastname@example.org> To: email@example.com Subject: exporting from org to excel Date: Thu, 15 Jan 2009 13:56:42 +0530 [thread overview] Message-ID: <firstname.lastname@example.org> (raw) 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#
reply other threads:[~2009-01-15 8:26 UTC|newest] Thread overview: [no followups] expand[flat|nested] mbox.gz Atom feed
Reply instructions: You may reply publicly to this message via plain-text email using any one of the following methods: * Save the following mbox file, import it into your mail client, and reply-to-all from there: mbox Avoid top-posting and favor interleaved quoting: https://en.wikipedia.org/wiki/Posting_style#Interleaved_style List information: https://www.orgmode.org/ * Reply using the --to, --cc, and --in-reply-to switches of git-send-email(1): git send-email \ --email@example.com \ --firstname.lastname@example.org \ --email@example.com \ --subject='Re: exporting from org to excel' \ /path/to/YOUR_REPLY https://kernel.org/pub/software/scm/git/docs/git-send-email.html * If your mail client supports setting the In-Reply-To header via mailto: links, try the mailto: link
Code repositories for project(s) associated with this inbox: https://git.savannah.gnu.org/cgit/emacs/org-mode.git This is a public inbox, see mirroring instructions for how to clone and mirror all data and code used for this inbox; as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).