It’s taken me about five hours to work out that it doesn’t look like it’s possible for PHP to convert Excel files (xlsx or xls) to XML, or any other plain text and then to XML. I can see why some projects take much longer than they should, and why programming only takes up a little more than half of that time. The hours I’ve spent around Google today are probably going to be reflected in most days.
Anyway, I found a C library that does that, so I’m going to have to use it. That shouldn’t confuse the PHP code too much, but it makes me feel uncomfortable. Do different languages often overlap like that? Scrap that. Looks like that library creates XLS files, the exact opposite of what I want… (I got excited when someone linked to it in IRC, so I assumed.) Back to square one, eh?
The annoying thing is that if I was using ASP, I could totally do it from within the language. That doesn’t make me want to start using ASP though, to be honest.