Paul W. Roach III on 3 Jul 2008 10:25:25 -0700

[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]

Re: [PLUG] Text file to Excel, automated

The PERL libraries are great -- I'm currently running an automated process that receives excel files via email/procmail then parses them together into a single spreadsheet and sends out the results.  It's working very very well.

On Thu, Jul 3, 2008 at 11:02 AM, Kyle R. Burton <> wrote:
On Thu, Jul 3, 2008 at 9:54 AM, Jon Bringhurst <> wrote:
> How about formatting the result of the query to csv and using
> something like this...
> On Thu, Jul 3, 2008 at 9:50 AM, Julien Mills <> wrote:
>> I'm looking for a way to put the text output of some
>> sql queries into an excel document which I can email
>> to others in the company.
>> What I do now is run the query, import it into OO,
>> save it as an excel document and then email it.
>> I'd like to automate the whole process.  I believe
>> I can create a .slk file and then excel will read
>> that.  Anyone have any experience doing that or is
>> there a niftier way to do it?

I have used a few libraries for doing this.

Apache Jakarta's POI:

Perl libraries:

For Ruby there is spreadsheet-excel, which I've used in a rails app:

All these can run under Linux (or windows), and don't require any
external libraries.  There is even a Java lib for MS Access
files:, as well as a c-library,
mdbtools.  The C library doesn't handle as many cases as the Java
library though (at least not the last time I used it).

Any of those should allow you automate your task...if you're willing,
I'm sure we can even help you work through using any of these over the


Philadelphia Linux Users Group         --
Announcements -
General Discussion  --

Philadelphia Linux Users Group         --
Announcements -
General Discussion  --