I am trying to create a spreadsheet from mysql data via a php page. 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 retrieved
data formatted in an HTML table. Each <tdblah</td corresponds to a
cell in the spreadsheet

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 specify the width?

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

Have you tried something like

<td style="width: 200px"content</td

?

You might also consider using an XML file (obtained by saving a "template"
report in XML format from Excel) and then inserting your queried content
into that file (eg. by replacing a piece of placeholder text).

Tim


"sumithar" wrote in message
...
I am trying to create a spreadsheet from mysql data via a php page. 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 retrieved
data formatted in an HTML table. Each <tdblah</td corresponds to a
cell in the spreadsheet

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 specify the width?

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

On Jun 22, 6:46*pm, "Tim Williams" <timjwilliams at gmail dot com
wrote:
Have you tried something like

<td style="width: 200px"content</td

?

You might also consider using an XML file (obtained by saving a "template"
report in XML format from Excel) and then inserting your queried content
into that file (eg. by replacing a piece of placeholder text).

Tim

"sumithar" wrote in message

...



I am trying to create a spreadsheet from mysql data via a php page. *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 retrieved
data formatted in an HTML table. *Each <tdblah</td corresponds to a
cell in the spreadsheet

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 specify the width?

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");- Hide quoted text -

- Show quoted text -

Thanks for the XML tip. Turns out the problem I had was 'cos I didn't
realise I was trying to open the spreadsheet w/ Open Office calc. It
works the way I want it to with Excel. The width attribute in <td
does control the width of the Excel column as well.