reading values from an excel spreadsheet

Discussion in 'Ruby' started by Krishna Vutukuru, Oct 11, 2007.

  1. 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-forum.com/.
    Krishna Vutukuru, Oct 11, 2007
    #1
    1. Advertising

  2. 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-forum.com/.
    Krishna Vutukuru, Oct 11, 2007
    #2
    1. Advertising

  3. 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-forum.com/.
    Krishna Vutukuru, Oct 11, 2007
    #3
  4. Krishna Vutukuru

    Liang He Guest

    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-forum.com/.
    Liang He, Oct 11, 2007
    #4
    1. Advertising

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. FSD
    Replies:
    0
    Views:
    1,183
  2. =?Utf-8?B?bGFuZW0=?=

    Reading an excel spreadsheet using ado.net

    =?Utf-8?B?bGFuZW0=?=, Jun 21, 2006, in forum: ASP .Net
    Replies:
    1
    Views:
    739
    Mark Rae
    Jun 21, 2006
  3. nicelily

    reading input from excel spreadsheet

    nicelily, Mar 5, 2007, in forum: C Programming
    Replies:
    0
    Views:
    343
    nicelily
    Mar 5, 2007
  4. =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=

    Problem with Excel reports ::::Excel 2003 Migration To Excel 2007

    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=, Oct 5, 2007, in forum: ASP .Net
    Replies:
    15
    Views:
    1,482
    =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?=
    Oct 24, 2007
  5. S_K
    Replies:
    4
    Views:
    676
    Juan T. Llibre
    Mar 26, 2008
Loading...

Share This Page