I noticed that the current version of excel allows direct connections to json files.
https://support.office.com/en-us/articl ... 8bb53cd4c0
Was trying to load up some betfair price files and got an invalid character error (the last character in every row was invalid)...
Has anyone tried this out and had some success?
JSON files (betfair data)
The files themselves aren’t valid json, they are separate json data structures with a carriage return on the end.sionascaig wrote: ↑Sat Aug 03, 2019 11:27 amI noticed that the current version of excel allows direct connections to json files.
https://support.office.com/en-us/articl ... 8bb53cd4c0
Was trying to load up some betfair price files and got an invalid character error (the last character in every row was invalid)...
Has anyone tried this out and had some success?
-
sionascaig
- Posts: 1072
- Joined: Fri Nov 20, 2015 9:38 am
Thanks Linus )LinusP wrote: ↑Sun Aug 04, 2019 8:17 pmThe files themselves aren’t valid json, they are separate json data structures with a carriage return on the end.sionascaig wrote: ↑Sat Aug 03, 2019 11:27 amI noticed that the current version of excel allows direct connections to json files.
https://support.office.com/en-us/articl ... 8bb53cd4c0
Was trying to load up some betfair price files and got an invalid character error (the last character in every row was invalid)...
Has anyone tried this out and had some success?