I want to implement a support for Excel files, both .xls and .xlsx, through Apache POI which will give me access to Java objects including column names, column values and it will expose the set of types supports.
(I recorded this issue here: https://issues.apache.org/jira/browse/DRILL-3738) In other words, I will be doing file I/O and column r/w through POI, so I will need to write an adapter in Drill for storage and read/write. What is the best way to do this? Which classes should I extend or interfaces implement in order to support Excel files in Drill? I could probably still go with easy storage approach because POI makes it easy and the data is tabularly oriented just as csv, but with extended types (ints, floats, numerics). Please give me some guidance in form of a "you need to implement x,y and z to make this work". Thank you in advance, Edmon
