search

mjul / docjure

Read and write Office documents from Clojure
MIT License
622 stars 129 forks source link

Can we select columns by custom column name ? #52

Closed ghost closed 8 years ago

ghost commented 8 years ago

Thanks for great library. I tried select-column with custom name in excel but it doesn't seem to work. Is there anyway to make it work ? I'm happy to contribute, I need some direction since I'm not familiar with the java lib.

mjul commented 8 years ago

Thanks for getting in touch. It would be great if you could help extend the library.

select-columns uses the standard Excel column names :A, :B, :C etc.

The select-name function provides support for named ranges. Maybe you could use that as inspiration for updating select-columns (possibly extending it to a multi-method if necessary).

The documentation for named ranges in the POI library is here: http://poi.apache.org/spreadsheet/quick-guide.html#NamedRanges

ghost commented 8 years ago

@mjul sorry for late update. I just found out that my file xlsx was read as EXCEL97, I'm not sure if it's a cause or not. I will investigate on this further, for now select-columns works just fine. Thanks for helping.