I use excel['Visible']=false to hide the excel window while running. Be
sure to close the window with workbook.Close(0) and excel.Quit
or the excel processes don't terminate. For reading data, I use a loop
to go through all the rows upto some keyword planted in the excel file
like "END" or until 10 consecutive blank lines are read.
Also instead of reading from excel as ['value'] try using ['text']. The
Ruby win32ole is buggy when it comes to reading numbers from excel
files. It seems to have a mind of its own with the amount of decimals
digits.
otestStep.action=worksheet.Range("D#{startRow +
readRow}")['Text'].strip.to_s
To write to the excel file use
worksheet.Range("F#{startRow + readRow}").value=accountNumber
_______________________________________________
Wtr-general mailing list
[email protected]
http://rubyforge.org/mailman/listinfo/wtr-general
