could roo also deliver the defined names in the excel sheet

18 views
Skip to first unread message

Bernhard Weichel

unread,
Mar 13, 2014, 12:24:03 PM3/13/14
to ruby...@googlegroups.com
Hi

I am using roo to pull data out a given excel sheet. The maintainer of this sheet wants re relayout the same, but could specify names for the cells of interest. But I could not find a way how I can read these names with roo.

Is there a way to get the name definitions e.g. 

mysheet.names yield a hash with name definitions.

:myrst_name => {:sheet => "the tab", :start => {:row => 1, :col => "A"} :end=> {:row => 10, :col => "C"}}
}

Bernhard
Reply all
Reply to author
Forward
0 new messages