Re: MySQL -> PHP -> MS Excel?

In message <m1skpf7fgy.fsf@xxxxxxxxxxx>, Sherm Pendley <spamtrap@xxxxxxxxxxx> writes
me <noemail@xxxxxxxxxxx> writes:

On Tue, 25 Nov 2008 19:56:06 +0100, Luuk <luuk@xxxxxxxxxxx> wrote:

most simple would be (i think) to create a CSV file...

That was my preferred choice too, but the customer wants it directly
in MS-Excel format - they don't want to have to do an import of any
sort.

Give the CSV file a .xls extension so it gets the right desktop icon,
and they'll probably never notice the difference. :-)

My PC uses the Excel icon for CSV files as well, but your idea is a good one. The only problem I can think of is if there is data where leading zeros are significant - I've tried several times to create a CSV where they get retained but without success. And of course if the spread*** needs several sheets and/or formulae.

--
Surfer!
Email to: ramwater at uk2 dot net
.

Loading