emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: "Rustom Mody" <rustompmody@gmail.com>
To: emacs-orgmode@gnu.org
Subject: exporting from org to excel
Date: Thu, 15 Jan 2009 13:56:42 +0530	[thread overview]
Message-ID: <f46c52560901150026j3e37e8a9ge477f95fe955a6a8@mail.gmail.com> (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.Visible = True

Is there some easy/natural way to get this functionality inside elisp?

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

                 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:

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=f46c52560901150026j3e37e8a9ge477f95fe955a6a8@mail.gmail.com \
    --to=rustompmody@gmail.com \
    --cc=emacs-orgmode@gnu.org \
    --subject='Re: exporting from org to excel' \


* 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:


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).