Write
280
edits
Difference between revisions of "Linking your OData Feed to a OdataLink Standard Excel Report Template"
Linking your OData Feed to a OdataLink Standard Excel Report Template (view source)
Revision as of 19:44, 28 October 2024
, 28 Octoberchanged title, changed content
m (Ash moved page Linking your data to a Standard Microsoft Excel Report to Linking your Odata Feed to a OdataLink Standard Excel Report Template: changes suggested by Jeff - Keywords OdataLink, report, template) |
(changed title, changed content) |
||
| Line 1: | Line 1: | ||
[[File:Excel_DataSourceSettings.png|300px|thumb|right|Select the existing OData feed url]] | [[File:Excel_DataSourceSettings.png|300px|thumb|right|Select the existing OData feed url]] | ||
OdataLink provides a set of downloadable | OdataLink provides a set of downloadable Excel Report templates which are linked to [[OData Feed URLs | Odata Feeds]] of a demo company file. | ||
In order to replace the existing demo company data with your data in the report, replace the existing OData feed as a Data Source to your own [[OData Feed URLs|OData feed url]]. | |||
The following guide will assist in linking your data to the report template. | |||
The following guide will assist linking your data to the | |||
| Line 18: | Line 16: | ||
Before beginning, ensure you have [[Copying the OData feed URL|copied the OData Feed URL]]. | Before beginning, ensure you have [[Copying the OData feed URL|copied the OData Feed URL]]. | ||
# | # Open '''Excel''' on your desktop and select the '''Data''' tab. | ||
# Click on the '''Get Data''' button, then select '''Data Sources Setting'''. | # Click on the '''Get Data''' button, then select '''Data Sources Setting'''. | ||
#: Note that on some version Excel, the '''Get Data''' button is called '''New Query''' instead. | #: Note that on some version Excel, the '''Get Data''' button is called '''New Query''' instead. | ||
# In the ''Data Source Settings'' dialogue, select the [[OData Feed URLs|OData feed url]] and click on '''Change Source'''. | # In the ''Data Source Settings'' dialogue, select the [[OData Feed URLs|OData feed url]] and click on '''Change Source'''. | ||
# In the next dialogue, paste the [[Copying the OData feed URL|OData Feed URL copied previously]] and click '''OK'''. | # In the next dialogue, paste the [[Copying the OData feed URL|OData Feed URL copied previously]] and click '''OK'''. | ||
# The report would refresh and download your company data into the report. | |||