|
[Date Prev] [Date Next] [Thread Prev] [Thread Next] [Date Index] [Thread Index]
|
Re: [PLUG] Text file to Excel, automated
|
Don't send an attachment! Put the CSV file (as others have is "natively"
by OO and Excel) on a webserver/ftpserver and provide them with a link.
On a slightly different not, Excel and OpenOffice can accept a filename
which is actually a URL, try one of these CSV files for a test
http://www.nyiso.com/public/market_data/load_data/load_forecast.jsp
Julien Mills 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
|
|