WvdS Doku - en:int:dbgway:anwender:excel https://www.wvds.it/wiki/ 2026-05-22T16:46:40+00:00 WvdS Doku https://www.wvds.it/wiki/ https://www.wvds.it/wiki/lib/exe/fetch.php?media=wiki:dokuwiki.svg text/html 2026-01-29T23:22:38+00:00 Anonymous (anonymous@undisclosed.example.com) 1.1 Import Data into Excel https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:excel:daten-importieren&rev=1769728958&do=diff 1.1 Import Data into Excel Step-by-step guide. Prerequisites * Excel 2016 or newer * Network access to Gateway server Instructions * Data -> Get Data -> From Other Sources -> From OData Feed * Enter URL: <http://server:5000/odata/demo> * Click OK * Select table (e.g., text/html 2026-01-29T23:22:42+00:00 Anonymous (anonymous@undisclosed.example.com) 1.2 Filter and Sort https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:excel:filter-sortierung&rev=1769728962&do=diff 1.2 Filter and Sort Filter data during import. In Power Query Editor After connecting: * Choose Transform instead of Load * Apply filters to columns * Remove/rename columns * Close and Load Advantages * Only required data is transferred text/html 2026-01-29T23:22:56+00:00 Anonymous (anonymous@undisclosed.example.com) 1.3 Pivot Tables https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:excel:pivot-tabellen&rev=1769728976&do=diff 1.3 Pivot Tables Use data from the Gateway in Pivot Tables. Procedure * Import data (see Import Data) * Select a cell in the table * Insert -> PivotTable * Select and arrange fields Tips * Filter large datasets first * Refresh regularly for current numbers text/html 2026-01-29T23:22:28+00:00 Anonymous (anonymous@undisclosed.example.com) 1. Excel https://www.wvds.it/wiki/doku.php?id=en:int:dbgway:anwender:excel:start&rev=1769728948&do=diff 1. Excel