RE: FN-FORUM: Re: Editing Word and excel docs on a hosted ISP server

date posted 26th July 2005 00:05

I'm talking about programatically using excel from within code. IT's the
licencing issue more than anything.=20

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of
Anthony Cartmell
Sent: Tuesday, July 26, 2005 12:35 AM
To: Andy Macnaughton-Jones
Subject: Re: FN-FORUM: Re: Editing Word and excel docs on a hosted ISP
server


> I'd say you're largely buggered on the excel front.

Actually Excel is easy to interface to from a web server.

If you're excel is reasonably recent, simply output an HTML table with
what you want, and give it the extension.xls - Excel will read the HTML
and turn it into a spreadsheet quite happily.

You can do formatting and equations too - try outputting an Excel =20
spreadsheet as HTML to see how MS store the equation info in the HTML.

It's not pretty but it works fine!

colspan and rowspan even work to merge cells together in the spreadsheet
:)

Cheers!

Anthony
--
www.fonant.com - hand-crafted web sites


--=20
Freelancers, contractors earn more with Prosperity4
Call 0870 870 4414 or visit www.prosperity4.com
and benefit from Inland Revenue approved expenses today.

To advertise here: http://www.freelancers.net/advertising.html