Difference between revisions of "SmartSimple OData Feed to Excel"

From SmartWiki
Jump to: navigation, search
(Using Excel Data Tab)
(Using Excel Data Tab)
Line 4: Line 4:
  
 
=Using Excel Data Tab=
 
=Using Excel Data Tab=
1. Go to the '''Data''' tab
+
1. Go to the '''Data''' tab<br/>
2. Click '''From Other Sources'''
+
2. Click '''From Other Sources'''<br/>
3. Choose '''From OData Feed''' from the dropdown list
+
3. Choose '''From OData Feed''' from the dropdown list<br/>
  
[[Image:OData-Excel1.PNG|500px|border]]
+
[[Image:OData-Excel1.PNG|400px]]
  
 
4.
 
4.

Revision as of 12:19, 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

OData-Excel1.PNG

4.

See Also