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.
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:
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).
If you will have any questions - you can contact me any time.