From: "Hal E. Fulton" Date: 2002-07-20T05:35:41+09:00 Subject: Re: Now to skip processing of first line in a file....and reading an Excel file? ----- Original Message ----- From: "Berger, Daniel" To: "ruby-talk ML" Sent: Friday, July 19, 2002 2:17 PM Subject: RE: Now to skip processing of first line in a file....and reading an Excel file? > > -----Original Message----- > > From: Hal E. Fulton [mailto:hal9000@hypermetrics.com] > > > > From: Kurt Euler [mailto:keuler@portal.com] > > 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. > ^^^^^^^^^^^^^^^^ > > That's the big problem with this approach, I think (I don't know COM, but > I'm guessing it doesn't work on *nix). Pardon me, but I assumed you were working on Windows... I meant you wouldn't have to port any Perl code if you used RubyCOM on Windows. Are you parsing Excel files on Unix? Is there actually and Excel that runs on Unix? > One other problem. Spreadsheets created by WriteExcel cannot be parsed by > ParseExcel. That may be something to consider dealing with from the start > for anyone considering a port. Ah, another write-only format. Hal