25% off Hosting at HostGator.com:
Use Code techbits25

How can I export data to an Excel file (xls)

Last updated: 02/22/2012

I found this great library to handle the whole thing:

http://blog.leenix.co.uk/2009/04/lightweight-php -class-to-export-to.html

This creates an xls file, rather than a csv. A CSV file can be opened by excel, but in some cases a csv is preferable because it can be used by other scripts or loaded to a database, etc.

blog comments powered by Disqus

Have your own Tech-bit to contribute? Submit it here

Other questions in this category:

	What causes an Error 400 when running php on IIS?
	Function to handle string substitution in php
	What causes array problems with php from one host to another?
	My php installation can't write to the Save Session Path - how do I fix it?
	how can I output my php arrays in a readable html format using print_r?
	How can I get mysql table definitions in my php script?
	How can I execute commands on mysql using a php script?
	How can I capture the contents of an included file?
	How can I slash out a price to denote a sale price in html and php?
	php session id keeps changing on every reload - how can I fix this?
	How can I get php errors to show in the browser?
	How can I keep leading zeros when building a CSV file?
	When I try adding text to images in php, the color does not match what I want. How can I fix this?
	How can I get bounced emails from my email CGI or PHP script?
	How can I modify a script that relies on register globals being turned on?
	Configuring htmleditor to do file uploads using php
	How can I format my php print_r statements to be more readable in html?
	How can I make a state drop down list for my forms?
	Why doesn't ftp_connect work in my php script?
	How can I force my php scripts to run php5 ?
	Why isn't my ioncube installation not working?
	How can I remove strange characters from a string in php?
	How can I test a portion of my php code without everyone seeing it?
	How can I turn off the + / - that shows up in my oscommerce product listing?
	How can I authenticate a user in my vbulletin database from a php script?
	My php scripts aren't registering $HTTP_GET_VARS variables anymore!
	How do I get rid of "Fatal error: Allowed memory size of 8388608 bytes exhausted" in my php scripts?
	Resizing images in php doesn't work
	I need a php function to put all rows from a mysql query into an array
	What's a php regex to grab text from an html document
	How can I run a remote web script or page from php?
	How can I load a mysql query into a hash in php?
	How can I check if a php script is running on SSL?
	How to match a mysql datetime field for a specific day
	Why does my php script give this error - "Call to undefined function: hash()"
	Some of my pages get a "Error parsing template" when generating HTML pages in Sunshop
	An overview of PHP
	How can I block spam in my forms?
	What does the error "wrong ELF class: ELFCLASS32" in regards to the ioncube loaders?
	How can I get php mail to send me bounced emails?
	I get an error connecting to MS SQL Server from my php script on windows
	How can I get rid of strange characters in my database output?
	How can I get the ioncube loaders working with GoDaddy?
	How can I use the Ioncube loaders on my iPage hosting account?
	Where can I find the ionCube Loader Wizard?
	How can I use autotagging with my codeigniter application?
	How can I obfuscate or minify my php code?

Content provided by Roberts WebForge, Inc.

Technology TidBits

How can I export data to an Excel file (xls)