Difference between revisions of "SmartSimple OData Feed to Excel"
From SmartWiki
(→See Also) |
|||
| Line 1: | Line 1: | ||
=Overview= | =Overview= | ||
| + | There are different ways to import OData Feed into Excel: Excel Data Tab, Power Pivot or Power Query. | ||
Example below shows how to pull OData feed via the Excel Data Tab. | Example below shows how to pull OData feed via the Excel Data Tab. | ||
| − | = | + | =Using Excel Data Tab= |
| + | 1. Go to the '''Data''' tab | ||
| + | 2. Click '''From Other Sources''' | ||
| + | 3. Choose '''From OData Feed''' from the dropdown list | ||
| + | |||
| + | [[Image:OData-Excel1.PNG]] | ||
| + | |||
| + | 4. | ||
Revision as of 12:17, 22 May 2018
Overview
There are different ways to import OData Feed into Excel: Excel Data Tab, Power Pivot or Power Query. Example below shows how to pull OData feed via the Excel Data Tab.
Using Excel Data Tab
1. Go to the Data tab 2. Click From Other Sources 3. Choose From OData Feed from the dropdown list
4.
