You can't use excel to get json data from dhis2 web api. At least not directly.
You could possibly write an excel macro to "get" the data through the web api (I am really not sure - it is far too many years since i wrote an excel macro), but you are still left with the problem of consuming what you have got (json) into cells in a spreadsheet. I believe all (or certainly almost all) of the data which is available as json is also available as csv. If you are looking at getting dhsi2 data into excel in general, I would look at csv rather than json if you want to minimize the processing/transformation that would otherwise have to happen in between getting the data and consuming it. https://www.dhis2.org/doc/snapshot/en/developer/html/dhis2_developer_manual.html On 23 June 2015 at 07:47, channara rin <rin.chann...@gmail.com> wrote: > Hi all DHIS2 developer, > Do you know can i use Microsoft Excel to get json data from DHIS2 web API? > > thank you > channara > > _______________________________________________ > Mailing list: https://launchpad.net/~dhis2-devs > Post to : dhis2-devs@lists.launchpad.net > Unsubscribe : https://launchpad.net/~dhis2-devs > More help : https://help.launchpad.net/ListHelp > _______________________________________________ Mailing list: https://launchpad.net/~dhis2-devs Post to : dhis2-devs@lists.launchpad.net Unsubscribe : https://launchpad.net/~dhis2-devs More help : https://help.launchpad.net/ListHelp
