Practical Data Migration by Johny Morris

This is a great reference book for data migrations. I thoroughly recommend it for any migration project

http://www.amazon.co.uk/Practical-Data-Migration-John-Morris/dp/1902505719

The author has a somewhat abandoned blog but a useful website

http://www.bcs.org/content/conBlogPost/1852

http://dataqualitypro.com/

Perl utilities, patterns and one liners

are stored here

Counting Excel sheets and rows

To count the number of individual sheets in an Excel workbook using VBA

[Excel 2010] Go to VBA, by pressing ALT + F11. Activate the Immediate window by Pressing CTRL + G

Enter the following line and press enter.

?activeworkbook.Sheets.Count


To count number of rows in a named worksheet enter the following:

?Sheets("Sheet1").UsedRange.Rows.Count



The total number of rows across an entire Excel workbook can also be calculated using VBA. But this is how to do it using Perl.