Loading CSV/text files with more than a million rows into Excel

1. The Problem If you usually load a very large CSV (comma-separated values) file or text file into Excel, you might run into the dreaded "File not loaded completely" message: As the message explains, the file you are trying to load is too large for Excel to handle. For me, it typically happens with large … Continue reading Loading CSV/text files with more than a million rows into Excel →

Splitting logs with PowerShell

I did some work to aggregate some logs from a group of servers for the whole month of February. This took a while, but I ended up with a nice CSV file that I was ready to load into Excel to create some Pivot Tables. See more on Pivot Tables at: Using PowerShell and Excel … Continue reading Splitting logs with PowerShell →

Tips for Excel Services Beta 2

I just wanted to share some things that I learned while implementing a proof of concept on Microsoft Office SharePoint Services (MOSS) 2007 beta 2 and more specifically regarding the Excel Services feature. First of all, if you got the beta for MOSS, Excel Services will be available as soon as you configure a Shared … Continue reading Tips for Excel Services Beta 2 →