[lnkForumImage]
TotalShareware - Download Free Software
Confronta i prezzi di migliaia di prodotti.
Asp Forum
 Home | Login | Register | Search 


 

Forums >

comp.lang.ruby

reading values from an excel spreadsheet

Krishna Vutukuru

10/10/2007 11:50:00 PM

does anybody know how to open a spreadsheet and read the values in the
cells and store them into an array using ruby?
--
Posted via http://www.ruby-....
3 Answers

Krishna Vutukuru

10/10/2007 11:58:00 PM

0

Krishna Vutukuru wrote:
> does anybody know how to open a csv and read the values in the
> cells and store them into an array using ruby?

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

Krishna Vutukuru

10/10/2007 11:58:00 PM

0

Krishna Vutukuru wrote:
> Krishna Vutukuru wrote:
>> does anybody know how to open a csv and read the values in the
>> cells and store them into an array using ruby?


I actually need it for csv files not xls files...

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

Liang He

10/11/2007 3:32:00 AM

0

Krishna Vutukuru wrote:
> does anybody know how to open a spreadsheet and read the values in the
> cells and store them into an array using ruby?

xl=WIN32OLE.new('Excel.Application')
book = xl.Workbooks.Open('test.xls')
v=xl.Cells(1,1).value
xl.Cells(1,2).value=v
......
--
Posted via http://www.ruby-....