Php code to convert .xml to .xls(Basically from xmlExcel to Excel spreadsheet)

Question

Is there a way to convert .xml file to .xls using php code?

John Conde · Accepted Answer · 2010-04-01 20:10:25Z

3

1) Read in the XML file using [simplexml_load_file()][1]

2) Loop through each XML element representing one line item in the XLS file

3) Use [fputcsv()][2] to create a comma separated file with the data from step 2

4) Save the file with a .csv extension and it will open in excel.

If you want to create an Excel spreadsheet I think you need to work with COM objects. Not my forté so I can't help you with that.

answered Apr 1, 2010 at 20:10

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Richard JP Le Guen · Accepted Answer · 2010-04-01 19:11:55Z

2

Dunno about converting XML to XSL, but in the book PHP Hacks there is a hack for generating excel spreadsheets most of which is available on Google Books, in its chapter on XML no less!

So that would be a good place to start looking if nobody's got the answer here.

answered Apr 1, 2010 at 19:11

28.8k8 gold badges93 silver badges121 bronze badges