exporting to an excel sheet

[El Bucanero]

Hey all,

I've created a MySQL database with lots of names, addresses and other
info in it and I'd like to write a little script that puts some selected
info in an excel file.
Anyone know how? Maybe there are some small programs I can buy?

Thanks,
Tim

[Chris Hope]

El Bucanero wrote:

> I've created a MySQL database with lots of names, addresses and other
> info in it and I'd like to write a little script that puts some selected
> info in an excel file.
> Anyone know how? Maybe there are some small programs I can buy?

Use the PEAR package:
[url]http://pear.php.net/package-info.php?package=Spreadsheet_Excel_Writer[/url]

You can also just write the data out into an HTML file as a table and save
it with an .xls extension and Excel will open it as a spreadsheet. This
isn't the best way but it's a quick 'n dirty approach.

--
Chris Hope
The Electric Toolbox - [url]http://www.electrictoolbox.com/[/url]

[El Bucanero]

>
> Use the PEAR package:
> [url]http://pear.php.net/package-info.php?package=Spreadsheet_Excel_Writer[/url]
>
> You can also just write the data out into an HTML file as a table and save
> it with an .xls extension and Excel will open it as a spreadsheet. This
> isn't the best way but it's a quick 'n dirty approach.
>

Quick n Dirty sounds good :)
it's just text, no calculations neccesary.
I can import this in excel and then save it as a proper file?

Thanks,
Tim

[Colin McKinnon]

El Bucanero spilled the following:

>>
>> Use the PEAR package:
>> [url]http://pear.php.net/package-info.php?package=Spreadsheet_Excel_Writer[/url]
>>
>> You can also just write the data out into an HTML file as a table and
>> save it with an .xls extension and Excel will open it as a spreadsheet.
>> This isn't the best way but it's a quick 'n dirty approach.
>>

>
> Quick n Dirty sounds good :)
> it's just text, no calculations neccesary.
> I can import this in excel and then save it as a proper file?
>

Proper file? Proper File? You mean a proprietary format that has a facility
for building in virus and trojans! Tread carefully El.

I was going to suggest that you skip PHP altogether and use MyODBC to import
the data directly to Excel. But I don't think I will now.

C.

[Chris Hope]

El Bucanero wrote:

>> Use the PEAR package:
>> [url]http://pear.php.net/package-info.php?package=Spreadsheet_Excel_Writer[/url]
>>
>> You can also just write the data out into an HTML file as a table and
>> save it with an .xls extension and Excel will open it as a spreadsheet.
>> This isn't the best way but it's a quick 'n dirty approach.
>>

>
> Quick n Dirty sounds good :)
> it's just text, no calculations neccesary.
> I can import this in excel and then save it as a proper file?

Yeah it works. The only catch is if any of your cells have leading zeros
they'll be removed when you open up the file. If they don't then this isn't
a problem.

IIRC you can even format the colour of cells using the bgcolor attributes of
the tr and td tags.

--
Chris Hope
The Electric Toolbox - [url]http://www.electrictoolbox.com/[/url]

[Daniel Molina Wegener]

On Tue, 15 Jun 2004 13:54:15 +0200
El Bucanero <american_discoPANTS@hotmail.com> wrote:

> Hey all,

Hi...

> I've created a MySQL database with lots of names, addresses
> and other info in it and I'd like to write a little script
> that puts some selected info in an excel file.

Try the PEAR extension listed in [http]://pear.php.net

> Anyone know how? Maybe there are some small programs I can
> buy?

Why to buy?

> Thanks,
> Tim

Regards...
--
Daniel Molina Wegener <dmw[@]unete.cl>
Developer | FreeBSD User
"Swift as the wind, Quiet as the forest,
Fierce as fire, Immovable as a mountain"

[eclipsboi]

Alternatively to the other suggestions, you can easily use PHP to
export everything out into a Comma Seperated Values (CSV) format,
and then open it up in Excel. Tabs and spaces could also be used
as seperators, just remember to enclose your data in quotes, escaping
any quotes in the data with a backslash (\) so it doesn't get
interpreted as the end of a field.

On Tue, 15 Jun 2004 13:54:15 +0200, El Bucanero
<american_discoPANTS@hotmail.com> wrote:

>Hey all,
>
>I've created a MySQL database with lots of names, addresses and other
>info in it and I'd like to write a little script that puts some selected
>info in an excel file.
>Anyone know how? Maybe there are some small programs I can buy?
>
>Thanks,
>Tim

[El Bucanero]

> Yeah it works. The only catch is if any of your cells have leading zeros
> they'll be removed when you open up the file. If they don't then this isn't
> a problem.
>
> IIRC you can even format the colour of cells using the bgcolor attributes of
> the tr and td tags.
>

Whoopdeedoo, it works.
Thanks all. Yes you too colin :P

T