I couldn’t find a decent way online to convert ICS files into an Excel type format for easy manipulation, or adding to documents etc. So I’ve built a simple one that is now available online: http://csv2sql.evandavey.com/ical2csv.php This takes an iCal URL and provides you with a CSV file as a download. Makes it much easier [...]
This is really easy, but something I never knew until I just tried this: Copy the cells you want to flip Right-Click “Paste Special” Tick the Transpose checkbox You’re done! Best Excel trick ever!
I’ve been working on a data import recently that required me to pull in the contents of a folder full of excel documents, all with the same structure containing data that needed to be collated into a single file. There really isn’t an easy way to read Excel (xls files) in PHP so I’ve reverted [...]