ruby - read xls file and re-export without lose initial data -

i m using “spreadsheet”ruby gem generate xls files.

i have xls file “myfile.xls” contains many sheets: sh_01, sh_02, sh_03 … want read name of last sheet (sh_last_number) , add new sheet called “sh_last_number+1” file (myfile.xls) , write data on it.
in other words, have open (read data) , write on @ same time.

if idea can’t realized spreadsheet, gem more efficient?

in advance.

you can spreadsheet gem. since working excel files, may need require excel component of gem if using older version:

require 'spreadsheet' # may need require 'spreadsheet/excel' 

then working , writing pages simple. open workbook (xls file multiple pages) like:

@workbook = spreadsheet.open("myfile.xls") 

and add sheet workbook you've opened, simply:

new_sheet = "sh_#{@workbook.worksheets.size + 1}" @worksheet = @workbook.create_worksheet(:name => new_sheet) 

hope helps.

cheers, sean