#!/usr/bin/env ruby -w -s # -*- coding: utf-8 -*- $LOAD_PATH.unshift "#{File.dirname(__FILE__)}/../lib" require 'axlsx' Axlsx::Worksheet.class_eval do def add_row_with_position(values = [], options = {}) values = Array.new(options[:start_at] || 0) + values add_row(values, options) end end p = Axlsx::Package.new wb = p.workbook wb.add_worksheet do |ws| ws.add_row_with_position [1,2,3,4,5] ws.add_row_with_position [1,2,3,4,5], :start_at => 5 end p.validate.each { |e| puts e.message } p.serialize("stack.xlsx")