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#
_______________________________________________
Emacs-orgmode mailing list
Remember: use `Reply All' to send replies to the list.
Emacs-orgmode@gnu.org
http://lists.gnu.org/mailman/listinfo/emacs-orgmode
