From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.1.3 (2006-06-01) on yquem.inria.fr X-Spam-Level: X-Spam-Status: No, score=0.0 required=5.0 tests=AWL autolearn=disabled version=3.1.3 Received: from mail3-relais-sop.national.inria.fr (mail3-relais-sop.national.inria.fr [192.134.164.104]) by yquem.inria.fr (Postfix) with ESMTP id 00BDFBC6B for ; Wed, 7 Nov 2007 20:29:01 +0100 (CET) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AgAAAFKgMUfAXQInh2dsb2JhbACOfQIBCAop X-IronPort-AV: E=Sophos;i="4.21,386,1188770400"; d="scan'208";a="5557923" Received: from concorde.inria.fr ([192.93.2.39]) by mail3-smtp-sop.national.inria.fr with ESMTP; 07 Nov 2007 20:29:01 +0100 Received: from mail1-relais-roc.national.inria.fr (mail1-relais-roc.national.inria.fr [192.134.164.82]) by concorde.inria.fr (8.13.6/8.13.6) with ESMTP id lA7JSwOo009819 (version=TLSv1/SSLv3 cipher=RC4-SHA bits=128 verify=OK) for ; Wed, 7 Nov 2007 20:29:01 +0100 X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: Ao8CAAahMUdQRFuw/2dsb2JhbAA X-IronPort-AV: E=Sophos;i="4.21,386,1188770400"; d="scan'208";a="4164541" Received: from furbychan.cocan.org ([80.68.91.176]) by mail1-smtp-roc.national.inria.fr with ESMTP; 07 Nov 2007 20:28:58 +0100 Received: from rich by furbychan.cocan.org with local (Exim 3.35 #1 (Debian)) id 1Ipqa8-0007De-00; Wed, 07 Nov 2007 19:28:56 +0000 Date: Wed, 7 Nov 2007 19:28:56 +0000 To: Jon Harrop Cc: caml-list@inria.fr Subject: Re: [Caml-list] Re: OT: Commercial Support and Programming Languages Message-ID: <20071107192855.GA22099@furbychan.cocan.org> References: <200711041201.10255.jon@ffconsultancy.com> <200711050504.26680.jon@ffconsultancy.com> <4731E008.9060605@marseda.com> <200711071607.51274.jon@ffconsultancy.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200711071607.51274.jon@ffconsultancy.com> User-Agent: Mutt/1.5.13 (2006-08-11) From: Richard Jones X-Miltered: at concorde with ID 473211FA.000 by Joe's j-chkmail (http://j-chkmail . ensmp . fr)! X-Spam: no; 0.00; ocaml:01 ocaml:01 motion-twin:01 ocamole:01 camlzip:01 routes:98 wrote:01 caml-list:01 caml:02 module:03 languages:03 programming:03 library:03 usefulness:04 manipulate:04 On Wed, Nov 07, 2007 at 04:07:51PM +0000, Jon Harrop wrote: > Another subject that I have discovered from my work on F# is the usefulness of > interoperability, specifically being able to manipulate Excel spreadsheets > from F#. I'm writing web analytics software for our company in OCaml and I'd > like to inject the results into OpenOffice's spreadsheet. Any idea how to do > that? It's funny you should mention these, because all three are possible under OCaml (and I've done two and a half of them). You can manipulate Excel using http://tech.motion-twin.com/ocamole.html (only OCaml on Windows, mind you). You can write Excel spreadsheets via a number of routes. Probably easiest is to use the CSV library from http://merjis.com/developers/csv to write CSV files, which is exactly what we did for web log analysis (http://merjis.com/developers/weblogs). Another alternative is to go via perl4caml & use the Perl module which does this. Writing OpenOffice spreadsheets is easier because you can write ODF directly, and put it into a ZIP file in the right format using something like CamlZip. I did this for OO writer documents, and have some code if you want to take a look at it. Rich. -- Richard Jones Red Hat