Updated: 06/10/2004

ArrayToExcel

When using databases, it is frequently requested that data is output to a Microsoft Excel spreadsheet. However, this is a particularly difficult task to complete as Excel spreadsheets are a proprietary format, and difficult to create. One way around this is to use COM programming, which takes the backend language (PHP) and uses that to tell Excel itself what to do. Downfalls of this 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 light at the end of the tunnel. as Excel versions 2000 and later (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 document is reasonably easy to create, is as good as you make it, and has no special requirements of the server. To this end, the ArrayToExcel class is under development to allow us to create an array (or number of arrays) of objects, and very simply create an Excel spreadsheet that can be opened by any fairly up-to-date version of Excel, and various other spreadsheet packages as well!

• Categories
  • PHP →
  • Scripts and Programs →
  • Documents
• Tags
  • class to xml,
  • class xml,
  • create document xml,
  • create xml,
  • create xml document,
  • create xml files,
  • document to xml,
  • document xml,
  • excel 2000 xml,
  • excel and,
  • in xml document,
  • include xml,
  • include xml document,
  • include xml files,
  • include xml in xml,
  • language xml,
  • server com,
  • uses of xml,
  • using xml,
  • web xml,
  • web xml include,
  • what is the use of xml,
  • what is xml document,
  • xml backend,
  • xml class,
  • xml development,
  • xml document,
  • xml document is,
  • xml excel,
  • xml excel 2000,
  • xml files,
  • xml include,
  • xml include files,
  • xml server,
  • xml spreadsheet,
  • xml spreadsheet excel,
  • xml spreadsheets,
  • xml version,
  • xml versions,
  • xml web,
  • xml web development
  • ...
• Platforms
  • Linux
• Licenses
  • Freeware