Ruby/Watir/Rasta: Pass the Value from the Excel/Rasta to an Array in Ruby

Adding duplicate tiles from different arrays PIXI.js

If I understood the code correctly, with quick check:

Sprites can have only one parent. If you check the Sprite object, it actually has a parent property. So slotArr1 and slotArr2 have identical Sprites and that fact doesn't change id you slice them. Then when you are assigning them to different containers, they get moved from one container to the other. You can reuse textures sure, but one Sprite can only have on parent.

Creating an array in ruby from excel spreadsheet (2 columns)

Please check the following code,

require 'spreadsheet'
a=Array.new
b=Array.new
Spreadsheet.open('abc.xls') do |book|
  book.worksheet('Sheet1').each do |row|        
    a.push(row[0])
    b.push(row[1])
  end
end

This Will return two array a, b. Please check it

How to put arrays from Roo excel sheet in two dimensional array

Just declare the array outside the each block. You're resetting it to [] every time the block is run. In that case, you will only append to one array.

two_dimensional = []
xls = Roo::Spreadsheet.open('test_work.xls')
xls.each do |row|
  two_dimensional << row
  p two_dimensional
end

How can I pass a long array through to another page?

You can do it in multiple ways, two listed below.

First way, Store your session in table.
Then you can set @lines in session and use that session in next request.

sessions['lines'] = @lines

Second way, If URL not important for your application. Then you can directly represent last 10 lines using render instaed of redirect.

def process_file
  file_path = params[:file].path
  @lines = Roo::Excelx.new(file_path).first(10).to_a # Returns array of first ten lines of file
  ? # Somehow save value of @lines for "view_lines" method
  render '/path/to/view'
end

Passing Values Through Excel sheet in Ruby-watir

Issue

In the line

 b.text_field(:id, "Email").set("username1")

You are passing a string "username1" to the set method. This is why that is the value that is typed into the text field.

Solution

What you actually want to do is pass the value of the variable username1. This is done by making it the parameter of the set method.

b.text_field(:id, "Email").set(username1)

Notice that there are no quotations around the username1. Similar would be required for the password1 variable.

Ruby Rails Excel Format Array Manipulation

For example, try that:

@records.each do |client|

  client_info  = Report.get_client_info(client)
  client_address = Report.get_client_address(client)

  client_records = []

  line = [client_info.id, client_info.full_name]

  [client_address.count, client_contact.count].max.times do |i|
    if @include_address == "1" && client_address[i]
      line << client_address[i].full_address << client_address[i].address_type
    else
      line << '' << ''
    end

    if @@include_contact == "1" && client_contact[i]
      line << client_contact[i].value << client_contact[i].label
    else
      line << '' << ''
    end

    client_records << line.clone
    line = ['', '']
  end
end

Passing an array into Ruby Excel Document Generator

You didn't need to try convert array to string. But you should use different array format and use write_col method:

def initialize(data:, path:)
  @data = data
  @path = path
  @array = [
    ['name', 'dob', 'city'],
    ['Dima', '27/02', 'Berlin'], 
    ['Conor', '23/04','Berlin']
  ]
end

...

def write_new_worksheet
  worksheet.write_col('A1', @array)
end

You can found more information here http://writeexcel.web.fc2.com/en/doc_en.html#write_col

---

Related Topics