Jon Bringhurst on 3 Jul 2008 06:54:31 -0700


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

Re: [PLUG] Text file to Excel, automated


How about formatting the result of the query to csv and using
something like this...

http://sujitpal.blogspot.com/2007/02/python-script-to-convert-csv-files-to.html

On Thu, Jul 3, 2008 at 9:50 AM, Julien Mills <julienfmills@yahoo.com> wrote:
> Hi all,
>
> 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?
>
> Thanks,
>
> ------------------------------------------------------
> Julien Mills                    julienfmills@yahoo.com
>
>
>
> ___________________________________________________________________________
> 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
>
___________________________________________________________________________
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