Smartstaff
1,385
edits
Changes
→Using Excel Data Tab
1. Go to the '''Data''' tab<br/>
2. Click '''From Other Sources'''<br/>
3. Choose '''From OData Feed''' from the dropdown list<br/>
[[Image:OData-Excel1.PNG|400px]]
[[Image:OData-Excel2.PNG|400px]]
5. Select the report (collection) to import.<br/>
[[Image:OData-Excel3.PNG|400px]]
6. Click '''Next''' and then '''Finish'''<br/>
[[Image:OData-Excel4a.PNG|400px]]
[[Image:OData-Excel4b.PNG|400px]]
7. Data from report will be imported into Excel.<br/>
Maximum number of rows per pull is 1024.
