|
[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.
-P
On Thu, Jul 3, 2008 at 11:02 AM, Kyle R. Burton < kyle.burton@gmail.com> 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: http://poi.apache.org/
Perl libraries:
http://search.cpan.org/~jmcnamara/Spreadsheet-WriteExcel-2.21/lib/Spreadsheet/WriteExcel.pm
Spreadsheet::WriteExcel
Spreadsheet::WriteExcelFromXML
For Ruby there is spreadsheet-excel, which I've used in a rails app:
http://rubyforge.org/frs/?group_id=678
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:http://jackcess.sourceforge.net/, 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
list.
Regards,
Kyle
___________________________________________________________________________
Philadelphia Linux Users Group -- http://www.phillylinux.org
Announcements - http://lists.phillylinux.org/mailman/listinfo/plug-announce
General Discussion -- http://lists.phillylinux.org/mailman/listinfo/plug
|
|