I have tried retrieving data from Excel sheet cells. I could retrieve the general text from each cell. but I couldn't get hyperlink address from the cell. I used spreadsheet gem with Ruby. I have used below code to read excel sheet.
book = Spreadsheet.open('C:\Downloads\CallStreetData.xls') sheet1 = book.worksheet(0) rowArray = Array.new sheet1.each do |row| puts row.join(',') rowArray.push(row.join(',').href) end puts rowArray
I need a solution with Ruby and Spreadsheet gem