How to read, write and update data from an excel file using ruby

How to read data from an excel file using ruby Spreadsheet gem file

Pre Requisite : make sure spreadsheet gem file is installed at your machine. if not then installed it using below command

gem install spreadsheet

Link of previous video - how to read data from an excel file in details

Code to read an excel file :-

require 'rubygems'
require 'spreadsheet'

row[2] = row[2] * 2
row[3] = 'passed'
end