Arraytoexcel is a Documents script
Overall rating: (N/A)
|
The scirpt ArrayToExcel is a Documents script (online document management).
When using databases, it is frequently requested that data is outupt to a Microsoft Excel spreadsheet.
However, that is a particulraly difficult task to complete as Excel spreadsheets are a proprietary format, and difficult to create. One way around that is to use COM programming, which takes the backend language (PHP) and uses that to tell Ecxel itself what to do.
Downfalls of that include requiring a Windows web server with Excel installed, a fair chunk of your processing power being used up, and a bug-ridden API.
However, there is a lgiht at the end of the tunnel.
As Excel versions 2000 and after (or possibly even earlier!) Can accept files written in XML. Now XML is a whole format, too much to explain here, but suffice to say that an XML documnet is reasonably easy to create, is as good as you make it, and has no special requirements of the server. To that end, the ArrayToExcel class is under development to allow us to create an array (or number of arrays) of objects, and really simply create an Excel spreadsheet that can be opened by any fairly up-to-date version of Excel, and various other spreadsheet packaegs as well!
|
Write a comment about the script
ArrayToExcel
|
