View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
sumithar sumithar is offline
external usenet poster
 
Posts: 4
Default Spreadsheet column width from html

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