LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
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");
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Import from html web page of index list to spreadsheet Shazza Excel Discussion (Misc queries) 0 September 10th 07 01:42 PM
how do you drop an HTML spreadsheet into excel Luddist Excel Worksheet Functions 0 September 13th 06 01:07 AM
How to make cell width different than the column width it lies in John Excel Discussion (Misc queries) 2 September 11th 06 10:41 PM
HTML controls in spreadsheet michael sharpe New Users to Excel 0 September 6th 06 08:15 PM
Spreadsheet Width Tom Setting up and Configuration of Excel 3 April 6th 05 07:29 AM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"