search

jsonkenl / xlsxir

Xlsx parser for the Elixir language.
MIT License
215 stars 85 forks source link

Sheet name #78

Closed alex88 closed 5 years ago

alex88 commented 6 years ago

Is there a way to get the sheet name when extracting data?

jsonkenl commented 6 years ago

Hey @alex88, yes there is but Xlsxir is not currently capable of capturing it. The information is located in the xl/workbook.xml file within the .xlsx document. I'll need to parse that file anyway to fix the 1904 date issue from #75, so I'll add this as an enhancement to add to that one. Feel free to take a stab at it if you have any interest.

norpan commented 6 years ago

I made a quick implementation of a parser that puts worksheet names into an ets table. However, I'm not sure how to incorporate it into the API. Also, I used mix format so the diff is bigger than it should be. See https://github.com/norpan/xlsxir/commit/456a6cf8d7d295590f94bf58ebfa7cb233c07a39

jsonkenl commented 5 years ago

This has been implemented via PR #82