Any advice on adding support for data frame in xll8 (like what's in R and Python)

May 6, 2015 at 7:21 PM
Hi Keith,

How are you doing? We exchanged email a while ago.

I have been following your xll, xll8, and other derived projects for some time. Thanks for sharing all these good libraries! However, due to my limited C++ knowledge and experience, I haven't used them in my projects. Now I am seriously thinking about writing an add-in based on xll8 at work. Could you please point me to any examples that I can base on to add some database query support? I would also like to add some data frame functionality like what's in R and Python, so that we can search, filter, sort, and slice the result set. I would also like to create such data structure based on existing data on the sheet, and the use the handle to get a subset of the data and use it elsewhere in the sheet. Your input would be greatly appreciated.

BTW, do you plan to move your projects to GitHub? I think it's easier for collaboration. I saw you have a placeholder for XLL for QuantLib. I am very interested in it, and can help you with it. I implemented one function for calculating business day today and it works. However, I have a long way to go to fully understand your advanced xll8 library, and to unleash its full power.
Jan 30, 2016 at 10:34 PM
Hi, grandtiger,

You may want to take a look at
soci https://github.com/SOCI/soci
odb http://www.codesynthesis.com/products/odb/
for pulling data from database.

candy