473,325 Members | 2,774 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,325 software developers and data experts.

Exporting to Excel 2003

I had a PHP script that used to successfully output to Excel 2000. I
used the header statements
header ('Content-type: application/vnd.ms-excel');
header ('Content-disposition: inline; filename=output.htm');

Last year I upgraded to Excel 2003, and now the output is just a table
that shows up in the browser.

Does anybody know what might be problem?

Thanks in advance.

Sep 17 '05 #1
2 3189
In article <11*********************@z14g2000cwz.googlegroups. com>,
"bobkaku" <bo*****@yahoo.com> wrote:
I had a PHP script that used to successfully output to Excel 2000. I
used the header statements
header ('Content-type: application/vnd.ms-excel');
header ('Content-disposition: inline; filename=output.htm');

Last year I upgraded to Excel 2003, and now the output is just a table
that shows up in the browser.

Does anybody know what might be problem?

Thanks in advance.


change the name of the file to output.xls

The browser is interpreting the file extension as a HTML file. You want
it to interpret it as an excel file. It all depends on how you have
your MIME types setup. Don't know your OS or browser config but try
this.

--
DeeDee, don't press that button! DeeDee! NO! Dee...

Sep 17 '05 #2
Michael Vilain said the following on 17/09/2005 19:27:
In article <11*********************@z14g2000cwz.googlegroups. com>,
"bobkaku" <bo*****@yahoo.com> wrote:

I had a PHP script that used to successfully output to Excel 2000. I
used the header statements
header ('Content-type: application/vnd.ms-excel');
header ('Content-disposition: inline; filename=output.htm');

Last year I upgraded to Excel 2003, and now the output is just a table
that shows up in the browser.

Does anybody know what might be problem?

Thanks in advance.

change the name of the file to output.xls


The file-name is irrelevant assuming you are sending the correct MIME-type.

Try "Content-disposition: attachment" instead.

--
Oli
Sep 17 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
by: Chris | last post by:
Could someone please provide me an effective means of exporting data from a data set (or data grid) to Excel?
3
by: sridevi | last post by:
Hello How to export data from ms-access database to excel worksheet using ASP. mainly i need to export data to multiple worksheets. it is very urgent to us. i have a sample code which works...
5
by: Neil | last post by:
Hi I'm currently exporting my datagrid to excel, taking advantage of the fact that excel can render html, the problem is that when i click the button to export it opens in browser, I want the button...
2
by: Michael | last post by:
I need to be able to export data from a web form into MS Excel. I know you can do it with a VB.net windows application, but how can you do it with an asp.net application using vb.net? Any help...
1
by: ad | last post by:
I use the code below to export the content of a data set to Excel, the code come form http://www.dotnetjohn.com/articles.aspx?articleid=36 But it always use the web form's name as the default...
1
by: Mustufa Baig | last post by:
I have an ASP.NET website where I am showing off crystal reports to users by exporting them to pdf format. Following is the code: ---------------- 1 Private Sub ExportReport() 2 Dim oStream...
2
by: Snozz | last post by:
The short of it: If you needed to import a CSV file of a certain structure on a regular basis(say 32 csv files, each to one a table in 32 databases), what would be your first instinct on how to...
7
by: semijoyful | last post by:
OS: Win XP SP2 Access version: 2003 Excel version: 2003 I am new at this, as I am sure you have gathered from this post title:) I am working on a form where users can input data in Access and...
1
by: John Overton | last post by:
I have a new requirement to Import and Export Excel tables into and out of Access 2003. The Excel tables are located on a remote server but I know the path to the Excel Files. Can you please help...
2
by: eskelies | last post by:
Hello all, I have data, which is separated into account numbers (ie. 10, 20, 30), but it exists in one query. Right now, I have an access macro "transferspreadsheet," which is exporting all the...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.