# Spreadsheet gem

**URL:** <https://www.ruby-forum.com/t/spreadsheet-gem/197380>\
**Category:** Ruby\
**Created:** [October 13, 2010, 3:59pm UTC](https://www.ruby-forum.com/t/spreadsheet-gem/197380 "2010-10-13T15:59:06Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![okkezSS](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/o/85f322/32.png) [@okkezSS](https://www.ruby-forum.com/u/okkezSS)\
**Post date:** [October 13, 2010, 3:59pm UTC](https://www.ruby-forum.com/t/spreadsheet-gem/197380/1 "2010-10-13T15:59:06Z")

</div>

Hi,

Here is a newbie question on the spreadsheet gem.

I have the following simple test code in a controller action :

```
require "spreadsheet"

@csd = cns_period_conv(params[:date][:year],params[:period_start])
book = Spreadsheet::Workbook.new
sheet1 = book.create_worksheet #default sheet name Worksheet1
sheet1.name = 'My First Worksheet'
sheet2 = book.create_worksheet :name => 'My Second Worksheet'
sheet1.row(0).concat %w{Name Country Acknowlegement}
sheet1[1,0] = 'Japan' #get the Cell at row 1, column 0
sheet1.row(0).height = 40
format_1 = Spreadsheet::Format.new :rotation=> 90, :vertical_align 

```

=\> :center, :horizontal\_align=\>:center  
sheet1.row(0).set\_format(0, format\_1);  
sheet1.row(2).push ‘One’,‘Two’,‘Three’

```
sheet1.column(2).width = "Acknoledgements".length
format_2 = Spreadsheet::Format.new :horizontal_align=> :center
sheet1.row(0).set_format(2, format_2);

book.write 'Excel.xls'

```

I would like to open this file in Excel instead of saving it to the  
harddisk. What have I missed?

Best regards,

Johan