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.
If you’re feeling up to the task you could port the two related Perl
modules. They would definitely be a good place to start for anyone
considering such a task.
Spreadsheet::ParseExcel for reading Excel files by Kawai Takanori
Spreadsheet::WriteExcel for creating Excel files by John McNamara
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.
If you’re feeling up to the task you could port the two related Perl
modules. They would definitely be a good place to start for anyone
considering such a task.
Spreadsheet::ParseExcel for reading Excel files by Kawai Takanori
Spreadsheet::WriteExcel for creating Excel files by John McNamara
There may be another possibility.
I’m sure Excel exposes some kind of COM interface.
Disclaimer: IANAC (I Am Not A COMmie).
You could perhaps use RubyCOM to access this
interface and query Excel about the spreadsheet
contents. No porting then.
Let me know if this does/doesn’t turn out to
be possible.
Hal Fulton
···
----- Original Message -----
From: “Berger, Daniel” djberge@qwest.com
To: “ruby-talk ML” ruby-talk@ruby-lang.org
Sent: Monday, July 15, 2002 11:55 AM
Subject: RE: Now to skip processing of first line in a file…and reading
