Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming,microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Import from html web page of index list to spreadsheet | Excel Discussion (Misc queries) | |||
how do you drop an HTML spreadsheet into excel | Excel Worksheet Functions | |||
How to make cell width different than the column width it lies in | Excel Discussion (Misc queries) | |||
HTML controls in spreadsheet | New Users to Excel | |||
Spreadsheet Width | Setting up and Configuration of Excel |