This will limit the number of rows returned, which is especially helpful for improving performance when designing reports and visualizations. When you configure the connection, you may also want to set the Max Rows connection property. The ExcelFile, under the Authentication section, must be set to a valid Excel File. The API Server is also easy to deploy on Microsoft Azure, Amazon EC2, and Heroku.Īfter you deploy the API Server and the ADO.NET Provider for Excel, provide authentication values and other connection properties needed to connect to Excel by clicking Settings -> Connection and adding a new connection in the API Server administration console.
See the help documentation for more information and how-tos. On a Java servlet container, drop in the API Server WAR file. On Windows, you can deploy using the stand-alone server or IIS.
#Excel for mac odata how to#
This article shows how to create a chart that is always up to date.įollow the steps below to begin producing secure Excel OData services: The API Server enables connectivity to live data: dashboards and reports can be refreshed on demand.
You can use the CData API Server and the ADO.NET Provider for Excel (or any of 200+ other ADO.NET Providers) to create data visualizations based on Excel data in SAP Lumira.
0 kommentar(er)
