From: Kurt Euler <keuler@...>
Date: 2002-07-15T07:16:45+09:00
Subject: Now to skip processing of first line in a file....and reading an 	Excel file?

All-

Please advise as to how to skip the reading of first line in a file during an iteration.

I use the following construction to read a line at a time in a text file:

	IO.foreach("./control/packages.txt") { |x|
		field = x.chop.split('\t')
		content2 = content.dup
		...etc.

However, the file that I'm reading from is a tab-delimited text file that I exported from Excel. This Excel file has column titles which, of course, get exported too. (I could add a "while" statement to skip processing of a line if it includes a title line string, but testing with each iteration
seems too expensive.)


On a related note, is there a way read in the rows of an Excel file as one would read in the lines of a text file? If so, please advise how. Or, perhaps there's a method for reading an Excel file into a 2D array. Again, please advise.

Thanks all!

-Kurt Euler