spreadsheet column width

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View
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");

Re: spreadsheet column width

sumithar wrote:
Quoted text here. Click to load it

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:

Re: spreadsheet column width

Quoted text here. Click to load it

OK- I will try those forums.  Come to think of it, there is no php
factor in this apart from the headers, I guess.

Site Timeline