From: Wes Gamble <weyus@...>
Date: 2006-10-29T16:04:59+09:00
Subject: Re: Efficient parsing of large Excel documents in Ruby

M. Edward (Ed) Borasky wrote:
> Wes Gamble wrote:
>> I was definitely thinking about using win32ole/Excel to convert this 
>> spreadsheet to CSV and then process it with a CSV parser.
>> 
>> I'm currently running on Linux though, so now I have to figure out any 
>> issues around a Windows production platform.
>> 
>> Thanks,
>> Wes
>> 
>> 
> 
> Have you tried unixODBC? It seems to work fairly well, although there
> are some issues with most Linux/Unix tools when the spreadsheet has tabs
> or column headers with spaces in them.
> 
> It's fairly easy to leave the Excel spreadsheets on a Windows system and
> hack together a simple "server" for them. I think all you have to do is
> "publish them to the intranet", but I've never done it. Then you can use
> something like Hpricot to parse them.

Hpricot?  I thought that only parsed HTML?  Can you say a little more 
about this?  Would the "server" you mention above parse the Excel into 
some intermediate format that I would then process with something else 
(like Hpricot or ???)?

Thanks,
Wes

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