Reading Excel Files in ColdFusion
I knew it was possible to read Excel files using ColdFusion because of your ability to extend java libraries and there are documented ways to do this with Java. What I didn’t know was that a java library already ships with ColdFusion to do this. And what I REALLY didn’t know is that someone wrote a CFC to easily and quickly do just that.
See it here.
I always hated the whole CSV conversion explanation (convert your Excel to CSV, then upload it so my lame parser can cut through it and choke on null columns and irritate me). Not only does this let me parse Excel documents, but it’s easier to do this than any lame CSV conversion. I love it!
