I've really tried to search everywhere for this question, so I apologize if this has been asked before.
Do we have a timeframe when we can export to the latest version of Excel rather than the 2007 version?
It has been discussed but found that most people are using xlsx or xls. Aqua Data Studio supports both of these formats. Is there something specific that you want to see?
Honestly, my question was very self-serving. I like the newer API available to version 2016.
Are you asking for, The Excel API — a way for developers to pro-grammatically use Excel for Office 365 for doing calculations, building dashboards? We don't support this at this time. I will put this as an enhancement request to be evaluated for a future release.