From mboxrd@z Thu Jan 1 00:00:00 1970 From: James Harkins Subject: Use babel to import table data from OpenDocument spreadsheets? Date: Tue, 02 Jul 2013 22:10:35 +0800 Message-ID: <87k3l9kq78.wl%jamshark70@dewdrop-world.net> Mime-Version: 1.0 (generated by SEMI 1.14.6 - "Maruoka") Content-Type: text/plain; charset=US-ASCII Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51714) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uu1I9-0007y4-SD for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 10:10:51 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Uu1I7-0003dN-Ty for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 10:10:49 -0400 Received: from mail-pd0-x233.google.com ([2607:f8b0:400e:c02::233]:34014) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uu1I7-0003cu-Az for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 10:10:47 -0400 Received: by mail-pd0-f179.google.com with SMTP id q10so3649293pdj.10 for ; Tue, 02 Jul 2013 07:10:46 -0700 (PDT) Received: from dlm-A6200.gmail.com ([113.109.18.9]) by mx.google.com with ESMTPSA id tq8sm27579357pbc.30.2013.07.02.07.10.42 for (version=TLSv1.2 cipher=RC4-SHA bits=128/128); Tue, 02 Jul 2013 07:10:45 -0700 (PDT) List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: orgmode Just wondering if anyone out there has some magic code snippets that will automatically bring in data from a LibreOffice spreadsheet during HTML export. I think I could save, by hand, the required worksheets out of the ods file into separate CSVs, and then write an emacs-lisp Babel block to import the table from file -- presumably this would run the lisp function at export time. But it would be so much slicker if something could go into the ods file directly and return the results in org table format. If somebody has already done something like this, it would save me quite a bit of time. If not, I would have to weigh my available time (not much), the time it would take to implement (maybe not extremely difficult, but not trivial either, especially if it involves digging through LibreOffice library documentation) and the weekly time I would save by just hitting C-e h h, instead of doing another manual process before C-e h h. (Or possibly an alternative would be to write a macro in LibreOffice to write the CSV files and run that from the commandline as part of the org export process.) Thanks -- this is just, no harm in asking. Otherwise I'll deal with it some other way. hjh