Re: Excel and Ruby

http://rubyonwindows.blogspot.com/search/label/excel


On Oct 14, 2:23=A0pm, Daniel Navarro <[e-mail]> wrote:
> Thank you very much! :) Like I said I am new, I found an example this
> morning like that but haven't had time to play with it. Again thank you s=
o
> much.
>
>
>
> On Thu, Oct 14, 2010 at 1:19 PM, dtolj <[e-mail]> wrote:
> > Why do you have a nested loop?
> > You can do this in two ways
> > 1) with activecell and offset to imitate moving around Excel sheet
> > with a cursor
> > 2) or something like this:
> > line=3D1
> > while worksheet.range("q#{line}").value
> > =A0worksheet.range("q#{line}").value
> > =A0line=3Dline+1
> > end
>
> > On Oct 13, 1:37 pm, Daniel Navarro <[e-mail]> wrote:
> > > oops sorry I initialized alot of Constants there.
>
> > > anyways here is my updated code
>
> > > it works fine except it is returning multiple values of the result. A=
ny
> > > Ideas?
>
> > > =A0 require 'win32ole'
> > > xl =3D WIN32OLE.connect('Excel.Application')
> > > wb =3D xl.ActiveWorkbook
> > > ws =3D xl.ActiveSheet
> > > ws.Range('N2').each do |cell|
> > > ws.Range('P3501:V3501').each do |days|
> > > =A0 contentsN =3D cell.value
> > > =A0 cellContentsN =3D contentsN.scan(/\w+/)
> > > =A0 dayofweek =3D %w{Monday Tuesday Wednesday Thursday Friday Saturda=
y
> > Sunday}
> > > =A0 month =3D %w{Janurary Feburary March April May June July August S=
eptember
> > > October November December}
> > > =A0 comparedayofweek =3D dayofweek & cellContentsN
> > > =A0 comparemonth =3D month & cellContentsN
>
> > > =A0 p comparedayofweek
> > > =A0 p comparemonth
>
> > > end
> > > end
>
> > > On Wed, Oct 13, 2010 at 3:19 AM, Dan Sr. <[e-mail]> wrote=
:
> > > > Hello all,
>
> > > > I'm just doing some data entry work and thought it would be fun to
> > > > automate my work with Ruby.(yes I could do this in VB but what fun =
is
> > > > that?)
>
> > > > What I am doing is putting column N into an Array. And then compari=
ng
> > > > the array to an already specified array to get the value. If that v=
alue
> > > > is present then I want to put an X in column P-V, Time in w-x and d=
ates
> > > > in y-z. so far I have got everything that I have coded to work
> > correctly
> > > > but haven't put classes or any structure to it. Just wanted to see =
if
> > > > what I was doing was ruby~esque so far and if anyone had any cool
> > tricks
> > > > or see something I am doing wrong. (My first program automating exc=
el
> > or
> > > > really anything in ruby) I have automated some files with tutorials=
 but
> > > > this is my first attempt on automating anything for any relevant
> > > > purpose. It's only half 1/4 or 1/8 written so far.
> > > > My goal is to loop through the items one by one, incrementing +1 to=
 the
> > > > next cell until I reach the end of the file.
> > > > if __FILE__ =3D=3D $0
> > > > =A0# TODO Generated stub
> > > > =A0require 'win32ole'
> > > > xl =3D WIN32OLE.connect('Excel.Application')
> > > > wb =3D xl.ActiveWorkbook
> > > > ws =3D xl.ActiveSheet
> > > > ws.Range('N1').each do |cell|
> > > > ws.Range('P1:V1').each do |days|
> > > > =A0ContentsN =3D cell.value
> > > > =A0CellContentsN =3D ContentsN.scan(/\w+/)
> > > > =A0Dayofweek =3D %w{Monday Tuesday Wednesday Thursday Friday Saturd=
ay
> > > > Sunday}
> > > > =A0Month =3D %w{Janurary Feburary March April May June July August
> > > > September October November December}
> > > > =A001.upto(31){|Day|}
> > > > =A0Comparedayofweek =3D Dayofweek & CellContentsN
> > > > =A0Comparemonth =3D Month & CellContentsN
> > > > =A0Compareday =3D Day & CellContentsN
> > > > =A0end
> > > > end
> > > > end
>
> > > > --
> > > > Posted viahttp://www.ruby-forum.com/.
>
> > > --
> > > Daniel Navarro
> > > 9035612340
>
> --
> Daniel Navarro
> 9035612340