Importing blank rows from excel spreadsheets
Mac OS X 10.7.1
I am creating a scientific database. To start I need to import the last 35 years of data from excel spreadsheets. However, whenever I import a spreadsheet, the blank rows at the bottom of each spreadsheet are also imported. This is adding over 100 blank records for each spreadsheet.
Any idea how to fix this without having to go into every spreadsheet and delete the blank rows?
Are the cells in these rows truly empty or is there data in them (such as spaces or other non printing characters) that isn't visible?