Question

http://spreadsheet.rubyforge.org“rel=“nofollow noreferer” http://spreadsheet.rubyforge.org,以生成一个电子表格,而Im则有麻烦。 I m 开设现有工作手册并增加数据。

我已要求在一定程度上进行编号格式工作,至少要看到这种数据是数字,但(如非常不重要)客户希望把数字与中心一致:

我目前的法典就是这样:

nfmt = Spreadsheet::Format.new :number_format =>  0.00 
row = sheet.row(1)
row[0] = "Result"
row[1] = 45.55
row.set_format 1, nfmt

也许没有什么可贵之处,但想知道是否有任何人能够提供帮助?

Spreadsheet does not modify Formatting at present. That means in particular that if you set the Value of a Cell to a Date, it can only be read as a Date if its Format was set correctly prior to the change.

www.un.org/Depts/DGACM/index_spanish.htm Edit for Trevoke

为此提供帮助。我曾尝试过你的法典,并做了罚款。我猜测这一差异是编辑现有的电子表格,在这种情况下,格式被忽略。为此:

require  rubygems 
require  spreadsheet 

Spreadsheet.client_encoding =  UTF-8 

book = Spreadsheet.open "edit_me.xls" # Blank spreadsheet

sheet1 = book.worksheet 0

format = Spreadsheet::Format.new :horizontal_align => :centre
sheet1.row(0).default_format = format
sheet1.row(0).push  I rule 2! , 43.56

book.write  edited_you.xls

Answer 1

这里是关于图书馆格式方法的法典:。最后,我使用了这一格言,它没有很好地格式,但自那时起,它就认为情况已经更新。

你可以尝试:

  54     # Horizontal alignment    
  55     # Valid values: :default, :left, :center, :right, :fill, :justify, :merge,    
  56     #               :distributed    
  57     # Default:      :default    
  58     enum :horizontal_align, :default, :left, :center, :right, :fill, :justify,    
  59                             :merge, :distributed,    
  60          :center      => :centre,    
  61          :merge       => [ :center_across, :centre_across ],    
  62          :distributed => :equal_space

<EDIT! 补充资料

require  rubygems 
require  spreadsheet 

Spreadsheet.client_encoding =  UTF-8 

book = Spreadsheet::Workbook.new
sheet1 = book.create_worksheet :name =>  test 

format = Spreadsheet::Format.new :horizontal_align => :centre
sheet1.row(0).default_format = format
sheet1.row(0).push  I rule! 

book.write  test.xls

这为我工作。 Try it - with both :centre and :center. 让我知道。

友情链接