[LRUG] Reading a "large" spreadsheet

[Adam Ludgate]

Another option I might suggest would be to use Apache POI Java libraries if
you have the ability to use JRuby

-----Original Message-----
From: chat-bounces at lists.lrug.org [mailto:chat-bounces at lists.lrug.org] On
Behalf Of Andrew Stewart
Sent: March-15-13 07:53
To: London Ruby Users Group
Subject: Re: [LRUG] Reading a "large" spreadsheet


On 15 Mar 2013, at 14:47, David Burrows wrote:
> One of the tricks i've used lately with temperamental Excel files is
importing them into Google Docs and then exporting back from there. Fixes no
end of problems including some weird Excel encoding problems.

An interesting idea but I'm not sure I can do that programatically.

> Is there any reason your not just using CSV?

Yes - I don't have any control over the spreadsheet generation.  My customer
is sent the spreadsheet by one of their suppliers; they (my customer) then
uploads it into my webapp which reads the spreadsheet and extracts the data.

Thanks,
Andy
_______________________________________________
Chat mailing list
Chat at lists.lrug.org
http://lists.lrug.org/listinfo.cgi/chat-lrug.org