|
Posted by sumithar on June 22, 2008, 5:40 pm
Please log in for more thread options wrote:
> sumithar wrote:
> >I am trying to create a spreadsheet from mysql data. =A0I have the
> > requisite headers in place for content type and all that.
> > All I am doing is executing the SQL query and displaying the data
> > formatted in an HTML table.
>
> > Whatever width I assign to the HTML table columns ( using <td
> > width=3D"nnn"> it doesn't have any impact on the width of the
> > spreadsheet column- that is always staying the same.
>
> > Any idea how to control it?
>
> > The headers I am using are as follows
> > header("Content-type: application/vnd.ms-excel");
> > header("Content-disposition: attachment; filename=3Dreport.xls");
> > header("Pragma: no-cache");
> > header("Expires: 0");
>
> This isn't really a php question. I would suggest asking it in one of :
>
> microsoft.public.excel.misc or microsoft.public.excel.programming
>
> I think you'll have more luck writing it out in XML format:http://msdn.mi=
crosoft.com/en-us/library/aa140066(office.10).aspx
OK- I will try those forums. Come to think of it, there is no php
factor in this apart from the headers, I guess.
Rgds
| 
XML Sitemap