Read comment from an excel specific cell

[Eric Chang]

Hello guys,

It's my first time to use roo gem, and I have some problem when I use comment method to read put a comment from an excel cell

1.when I try to read out the comment from a cell of sheet2, it will be fine only if there is also at least one comment in sheet1, why?

I assign sheet[1], which is my second sheet that contains comments in several cells, but read result will be fail, only when I change it to

s.default_sheet = s.sheets[0] 

could be fine... anyone knows what cause it?

2.when I try to read out the comment words from a cell, if the font is Tahoma, it could not be read out, and if I change it into others(Arial, 明細體,新明細體...) it would be finely read out,

but Tahoma is default font from excel, I need to read out from some existed excel files, so it's not possible to correct all the comments font, is there any solution to fix this problem?

Please see my attached file as example, thank you :D

------------------------code-----------------------

require 'roo'

s = Roo::Excelx.new('C:\Users\Eric\Dropbox\babe\projects\test\test.xlsx')

s.default_sheet = s.sheets[1] #=> need to be changed to s.default_sheet = s.sheets[0] and  be okay...

puts s.comment('A',1)

puts s.comment('B',1)

puts s.comment('C',1)

puts s.comment('D',1)