TalkPHP - View Single Post

tripy · 08-26-2008, 12:20 PM

xlsfile:// is known as a protocol for your browser. Think like http://, or ftp://, or file://
Probably, it's used by IE and excel to open an excel file without having to physically create it.

But what strikes me is that you have an unix/linux/bsd file path notation in there:
/tmp/example.xls

Try maybe to look in the temp folder of your server/user, as /tmp is the regular temp place on linux.

But by the way, it's even way simpler than that...
Simply create an html table, and send an header like this:

PHP Code:


			
header("Content-Type:  application/vnd.ms-excel");
header("Expires: 0");
header("Cache-Control: must-revalidate, post-check=0, pre-check=0");

before writing the table. Excel will open the html table like it was an spreadsheet...

08-26-2008, 12:20 PM	#2 (permalink)
tripy The Wanderer Join Date: Apr 2008 Posts: 7 Thanks: 0	xlsfile:// is known as a protocol for your browser. Think like http://, or ftp://, or file:// Probably, it's used by IE and excel to open an excel file without having to physically create it. But what strikes me is that you have an unix/linux/bsd file path notation in there: /tmp/example.xls Try maybe to look in the temp folder of your server/user, as /tmp is the regular temp place on linux. But by the way, it's even way simpler than that... Simply create an html table, and send an header like this: PHP Code: `header("Content-Type: application/vnd.ms-excel"); header("Expires: 0"); header("Cache-Control: must-revalidate, post-check=0, pre-check=0");` before writing the table. Excel will open the html table like it was an spreadsheet...