From: Arup Rakshit <lists@...>
Date: 2013-01-24T21:24:23+09:00
Subject: Re: Reading and looping through Excel

cristian cristian wrote in post #1093477:
> Hi all!
>
> I have a question regarding reading excel files and looping through the
> worksheets within a workbook.
>
> I have approx 12 excel files. Each file(workbook) has different amount
> of worksheets. These files are created by a system that exports
> transactions for each month. The problem is that it exports in an old
> version of excel and the workbook is divided in several worksheets
> (65000 rows per worksheet). The labels are in the first worksheet.

You can use Ruby1.9.3 standard library for that - "win32ole" and "CSV" .


Thanks

-- 
Posted via http://www.ruby-forum.com/.