Feature request - access workbook definedNames

[harmon25]

Great library!
One feature that would be nice, is the ability to extract the named ranges, or definedNames from an xlsx workbook or - xl\workbook.xml from the zip archive.

They are defined like this:

<definedNames>
 <definedName name="named_range_test1">Sheet1!$A$2:$C$40</definedName>
 <definedName name="named_range_test2">Sheet2!$G$2:$G$5</definedName>
</definedNames>

I use this to guide extraction of data from an excel sheet, rather than having ranges or references defined in the code - it is extracted from the workbook itself to guide parsing of cell values.

This is the openpyxl documentation of the feature for reference.

I am just learning go or would try making a pull request... am happy to help with testing though!

Thanks! 😃

[harmon25]

whooops just notices the method on the workbook interface - closing.