in reply to Re^2: Excel::SpreadSheet : Can't call method "set_column" on an undefined value
in thread Excel::SpreadSheet : Can't call method "set_column" on an undefined value

With sheets() you get a list (or one) existing worksheet, you can't use it to create one. (I guess)

Try adding a worksheet, and then using the sheets() method, then it will probably work.