Make XLS with PHP : PHP -> XLS File Generator : Create spreadsheets for MS Excel using PHP : Projects : Paggard.com : web programming technologies

You can Order all of the listed products on-line.

*We live in times of mail-filtering, spam-blocking and black-lists - because of this your possible mail can miss me. The most reliable way is to use my feedback form.

XLS Generator 1.3.2.1

Create binary XLS "on the fly" using PHP

[General Information] [Full Documentation] [on-line demo] [how to order]

News

XLS Generator Version 1.3.2 is released. Several bugs related to parsing complicated formula structures were fixed. All registered users can receive this updated version upon request.

Version 1.3 is released with full formulas support, also now you can use over 350 build in Excel functions. For more information refer to the documentation page.

Description

XLS Generator is a PHP script, that makes it possible to create binary XLS files (used by MS Excel) using PHP only. Using this script you will be able to create spreadsheets on UNIX-based systems, or on Windows systems without any dependant on the software installed - the only thing that is required for the script to work - is PHP 4.x (or later) installed.

The script is using user-friendly input format, which is actually XML template. This template can be generated dynamically (like dynamic php web-pages) and then passed to the XLS Generator (or stored for future use) - and XSL Generator will convert this XML template into binary XLS file, which could be opened by any version of MS Excel (from Excel 95). This means that you will be able to convert data from database tables, user input or from any other sources into Excel spreadsheets, creating price-lists, reports, product listings etc.

XLS Generator has many features which will help you to make your generated spreadsheets look individual: font styles, border and color settings, background, foreground and border colors and styles, text orientation and in-cell alignment settings. Also you can use formulas and over 350 build in Excel functions.

Besides, you will be able to tune the printed look of the generated spreadsheet: paper size, page orientation, printed margins, header and footer which can include page numbers and other kind of technical information.

XLS Generator also provides many other features including the possibility to lock certain spreadsheets with a password.

Using the form below you can test the work of the XLS generator. Just create your XML template (or use the given one), insert it into the form and push the "Create" button.

Only mind that XML has certain rules:

All templates must have <?xml version="1.0"?> at the very beginning.
All element tags must be closed like this: <Workbook> … </Workbook> or like this <Workbook />
Attributes must always be quoted:
<worksheet name="First Sheet"> … </worksheet>
<orientation landscape="1" />
All elements must be properly nested:
wrong: <row><cell> </row></cell>
correct: <row><cell> … </cell></row>
Document can contain comments:
All colors can be only named:
wrong: #FF0000
correct: red
all the available color names are listed here

NOTE! If during generation you will get some "XML ... " error - this means that you made an error in your XML template (did not close some tag or something).

>> show the example template in a separate window
>> show used configuration file

<?xml version="1.0"?>
<Workbook>
<Styles>

	<style name="main_h" font="Times New Roman" bold="1" size="14" color="navy" valign="middle" align="center" bg_color="whitesmoke" bottom="medium" />
	<style name="heading" font="Arial" bold="1" size="12" color="royalblue" bottom="double" border_color="royalblue" valign="bottom" />
	<style name="date" num_format=" d mmmm yyy hh:mm:ss" />
	<style name="currency" num_format=" $#,##0.00" />
	<style name="percent" num_format=" 0.00%" />
	<style name="rotation" rotation="2" text_wrap="0" />
	<style name="border" align="center" border="dashed" />
	<style name="url" color="dodgerblue" underline="1" />
</Styles>
<Worksheet name="Main Sheet">
		<Print>
			<papersize index="0" />
			<orientation landscape="1" />
			<margin top="0.50" right="0.50" bottom="0.50" left="0.50" />
			<Header margin="0.1">Upper Header [Page &P of &N]</Header>
			<Footer>lower footer</Footer>
		</Print>
		<Password>secret</Password>
	<Table>
		<Row height="25">
			<cell style="main_h">XLS Generator</cell>
			<cell style="main_h"> PHP 2 EXCEL TOOL</cell>
		</Row>
		<Row>
			<cell width="35">Introduction</cell>
			<cell width="60">XLS Generator is a PHP script, that makes it possible to create binary XLS files (used by MS Excel) using PHP only. Using this script you will be able to create spreadsheets on UNIX-based systems, or on Windows systems using PHP.</cell>
		</Row>
		<Row index="+1" width="20">
			<cell style="heading">Features</cell>
			<cell style="heading"> </cell>
		</Row>
		<row>
			<cell>Plain text</cell>
			<cell>This is just a text  - up to 255 characters</cell>
		</row>
		<row>
			<cell>Date (in different formats) 
			When this file was generated</cell>
			<cell style="date">&NOW</cell>
		</row>
		<row>
			<cell>Numbers</cell>
			<cell>1400.345</cell>
		</row>
		<row>
			<cell>Currency</cell>
			<cell style="currency">1400.345</cell>
		</row>
		<row>
			<cell>Percent</cell>
			<cell style="percent">0.999</cell>
		</row>
		<row>
			<cell>Web links</cell>
			<cell style="url">http://www.paggard.com</cell>
		</row>
		<row>
			<cell>Mailto links</cell>
			<cell style="url">mailto:paggard@paggard.com</cell>
		</row>
		<Row index="+1">
			<cell style="heading">Formulas</cell>
			<cell style="heading"> </cell>
		</Row>
		<Row>
			<cell width="35">Basic Operations [3+8*4] = </cell>
			<cell width="60">= 3 + 7 * 4</cell>
		</Row>
		<Row>
			<cell>Cell references [B14 + 5] = </cell>
			<cell>=  B14 + 5</cell>
		</Row>
		<Row>
			<cell>Arythmetic functions [PI()] = </cell>
			<cell>= PI()</cell>
		</Row>
		<Row>
			<cell>And other 351 functions [ROUND(SUM(B14:B16),2)] = </cell>
			<cell>=ROUND(SUM(B14:B16),2)</cell>
		</Row>

<row index="+1">
			<cell>Different other settings:</cell>
		</row>
		<row>
			<cell index="+1" style="border">border settings</cell>
		</row>
		<row>
			<cell index="+1" style="rotation">rotation</cell>
		</row>
		<row index="+1">
			<cell index="+1">Many features responsible fot the printed look of the document (press "Print Preview" button)</cell>
		</row>
		<row index="+1">
			<cell index="+1">XLS Generator also provides many other features including the possibility to lock certain spreadsheets with a password.</cell>
		</row>
		<row>
			<cell>This page is protected by password:</cell>
			<cell style="border">"secret"</cell>
		</row>
		<row index="+1">
			<cell align="right" top="double" border_color="darkgreen" color="black">This script is commersial, the price is:</cell>
			<cell num_format="$#,##0.00" top="double" border_color="darkgreen">99</cell>
		</row>
	</Table>
</Worksheet>
<Worksheet name="Second Sheet">
	<Table>
		<Row height="30">
			<cell width="30">Hey!</cell>
			<cell width="40">Here is another sheet here</cell>
			<cell>!!!</cell>
		</Row>
	</Table>
</Worksheet>

</Workbook>

If you will have any questions - you can contact me any time.