I am trying to create a spreadsheet from mysql data. I 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="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=report.xls");
header("Pragma: no-cache");
header("Expires: 0");

sumithar wrote:
>I am trying to create a spreadsheet from mysql data. I 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="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=report.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.microsoft.com/en-us/libr...ffice.10).aspx

On Jun 22, 5:17pm, "Paul Lautman" <paul.laut...@btinternet.com>
wrote:
> sumithar wrote:
> >I am trying to create a spreadsheet from mysql data. I 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="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=report.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.microsoft.com/en-us/libr...ffice.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