From mboxrd@z Thu Jan 1 00:00:00 1970 From: Jambunathan K Subject: Re: Use babel to import table data from OpenDocument spreadsheets? Date: Tue, 02 Jul 2013 19:49:43 +0530 Message-ID: <878v1pvybk.fsf@gmail.com> References: <87k3l9kq78.wl%jamshark70@dewdrop-world.net> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:55347) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uu1PF-0001Sj-V6 for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 10:18:12 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1Uu1PE-0006uX-90 for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 10:18:09 -0400 Received: from mail-pd0-x22c.google.com ([2607:f8b0:400e:c02::22c]:42667) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1Uu1PE-0006u2-2f for emacs-orgmode@gnu.org; Tue, 02 Jul 2013 10:18:08 -0400 Received: by mail-pd0-f172.google.com with SMTP id z10so3654537pdj.17 for ; Tue, 02 Jul 2013 07:18:07 -0700 (PDT) In-Reply-To: <87k3l9kq78.wl%jamshark70@dewdrop-world.net> (James Harkins's message of "Tue, 02 Jul 2013 22:10:35 +0800") 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: James Harkins Cc: orgmode M-x org-odt-convert RET or (org-odt-convert ......) James Harkins writes: > 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