Please note a bright example of how OData in Acumatica can be used by Excel based reports.
This demo also discusses a new Excel feature Dynamic Array, that is something worth to look at.
So, please take a look at Velixo, which is Excel based Acumatica tailored reporter (and not only).
They have recently added Single Sign On (SSO).
All the Best,