Whoever thought this was a good bloody idea? At some point, mate, you're going to have to stop fucking coding in Excel and migrate over to another language. Any language. You've proven your point in Excel and it's time to make an application, making best use of the language, rather than just parsing the output and creating some rought PHP.
It's so dirty, it makes me want to wash my eyes out with caustic soda.
Comments
Actually, that would be really useful for me.
There are a lot of times when I can provide a report that meets business requirements simply by whipping up a spreadsheet for a couple of managers, rather than go through the entire process of getting the same report onto SAP. If I could get the same reports accessible online that would be rather handy, and stil haven't wasted any developer time.
Applications are OK for high usage, but quite often you get a handful of managers who want reports that mean nothing to anyone else...for those reports Excel is a godsend. You can keep them happy, while saving days of development time.
Erm, why not link the XLS? Why do you have to use the business logic from inside the XLS? You need to do programming to make use of the business logic... and you will need to program if the business logic changes but why would you parse it from the spreadsheet? That's just filthy.