Sha256: d22d3ca45f3ffeda67d2913c14f145ff0e1d421e1069fca11923c811f3b255a2
Contents?: true
Size: 1.38 KB
Versions: 8
Compression:
Stored size: 1.38 KB
Contents
require 'roo/excelx/extractor'
module Roo
class Excelx
class Comments < Excelx::Extractor
def comments
@comments ||= extract_comments
end
private
def extract_comments
return {} unless doc_exists?
doc.xpath('//comments/commentList/comment').each_with_object({}) do |comment, hash|
value = (comment.at_xpath('./text/r/t') || comment.at_xpath('./text/t')).text
hash[::Roo::Utils.ref_to_key(comment['ref'].to_s)] = value
end
end
end
end
end
# xl/comments1.xml
# <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
# <comments xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
# <authors>
# <author />
# </authors>
# <commentList>
# <comment ref="B4" authorId="0">
# <text>
# <r>
# <rPr>
# <sz val="10" />
# <rFont val="Arial" />
# <family val="2" />
# </rPr>
# <t>Comment for B4</t>
# </r>
# </text>
# </comment>
# <comment ref="B5" authorId="0">
# <text>
# <r>
# <rPr>
# <sz val="10" />
# <rFont val="Arial" />
# <family val="2" />
# </rPr>
# <t>Comment for B5</t>
# </r>
# </text>
# </comment>
# </commentList>
# </comments>
Version data entries
8 entries across 8 versions & 2 rubygems