{"id":30130,"date":"2021-01-06T10:51:44","date_gmt":"2021-01-06T09:51:44","guid":{"rendered":"https:\/\/sl-p.brentex.ch\/?page_id=30130"},"modified":"2023-03-24T09:11:05","modified_gmt":"2023-03-24T08:11:05","slug":"excel-integration","status":"publish","type":"page","link":"https:\/\/www.sl-p.ch\/en\/winrep\/excel-integration\/","title":{"rendered":"Excel Integration"},"content":{"rendered":"
\n\t\t\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

WINREP\u00ae<\/h1>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\tUnsere Software zur Steuerung und Konsolidierung. \t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

WINREP\u00ae<\/h1>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\tUnsere Software zur Steuerung und Konsolidierung. \t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t\t
<\/div>\n\t\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

WINREP\u00ae<\/h1>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\tUnsere Software zur Steuerung und Konsolidierung. \t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tWINREP\u00ae<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tFeatures<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tExcel Integration<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tKunden<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\n\t\t\t\t\t\t\n\t\t\t\t\t\t\t\t\tTechnische Daten<\/span>\n\t\t\t\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t

Excel Integration<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t

Die WINREP\u00ae-Software verf\u00fcgt \u00fcber eine dynamische Excel-Schnittstelle (Add-in).<\/p>

Sie ist so konzipiert, dass Daten vom Excel in die Datenbank eingelesen werden k\u00f6nnen (z. B. Daten des monatlichen Reportings, die Jahresabschlussdaten etc.), womit die manuelle Dateneingabe beinahe \u00fcberfl\u00fcssig wird. Der gew\u00fcnschte Datenbereich wird mit der Maus markiert. Auf «Knopfdruck» werden die Daten dann in die WINREP\u00ae-Datenbank auf die gew\u00fcnschte Firma eingelesen.<\/p>

Andererseits dient die Schnittstelle der individuellen Output-Erstellung (mit Ausnahme der Standardprotokollierungen). \u00dcber die dynamische Schnittstelle werden die Daten ins Excel gelesen, wo sie in ihrer Darstellung beliebig weiter verarbeitet werden k\u00f6nnen (MIS, Abweichungsanalysen, Grafiken etc.). Wenn Sie Excel kennen, ist die Erstellung von individuellen Outputs f\u00fcr Sie eine einfache Sache.<\/p>

Die dynamische Schnittstelle erm\u00f6glicht es, einmal erstellte Output-files f\u00fcr jede Firma, jede Periode und jede W\u00e4hrung auf «Knopfdruck» zu aktualisieren.<\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t

\n\t\t\t
\n\t\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\"\"\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t<\/div>","protected":false},"excerpt":{"rendered":"

WINREP\u00ae Unsere Software zur Steuerung und Konsolidierung. WINREP\u00ae Unsere Software zur Steuerung und Konsolidierung. WINREP\u00ae Unsere Software zur Steuerung und Konsolidierung. WINREP\u00ae Features Excel Integration Kunden Technische Daten Excel Integration Die WINREP\u00ae-Software verf\u00fcgt \u00fcber eine dynamische Excel-Schnittstelle (Add-in). Sie ist so konzipiert, dass Daten vom Excel in die Datenbank eingelesen werden k\u00f6nnen (z. B. Daten […]<\/p>","protected":false},"author":4,"featured_media":34230,"parent":28920,"menu_order":2,"comment_status":"closed","ping_status":"closed","template":"elementor_header_footer","meta":{"footnotes":""},"class_list":["post-30130","page","type-page","status-publish","has-post-thumbnail","hentry"],"yoast_head":"\nExcel Integration - Lorenz + Partner AG<\/title>\n<meta name=\"description\" content=\"Unsere Software zur Steuerung und Konsolidierung. Die WINREP\u00ae-Software verf\u00fcgt \u00fcber eine dynamische Excel-Schnittstelle (Add-in). Sie ist...\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.sl-p.ch\/en\/winrep\/excel-integration\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Excel Integration - Lorenz + Partner AG\" \/>\n<meta property=\"og:description\" content=\"Unsere Software zur Steuerung und Konsolidierung. Die WINREP\u00ae-Software verf\u00fcgt \u00fcber eine dynamische Excel-Schnittstelle (Add-in). Sie ist...\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.sl-p.ch\/en\/winrep\/excel-integration\/\" \/>\n<meta property=\"og:site_name\" content=\"Lorenz + Partner AG\" \/>\n<meta property=\"article:modified_time\" content=\"2023-03-24T08:11:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2021\/12\/lorenz.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"1024\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data1\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/\",\"url\":\"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/\",\"name\":\"Excel Integration - Lorenz + Partner AG\",\"isPartOf\":{\"@id\":\"https:\/\/www.sl-p.ch\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2021\/12\/lorenz.jpg\",\"datePublished\":\"2021-01-06T09:51:44+00:00\",\"dateModified\":\"2023-03-24T08:11:05+00:00\",\"description\":\"Unsere Software zur Steuerung und Konsolidierung. Die WINREP\u00ae-Software verf\u00fcgt \u00fcber eine dynamische Excel-Schnittstelle (Add-in). Sie ist...\",\"breadcrumb\":{\"@id\":\"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#primaryimage\",\"url\":\"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2021\/12\/lorenz.jpg\",\"contentUrl\":\"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2021\/12\/lorenz.jpg\",\"width\":1024,\"height\":1024},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.sl-p.ch\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Winrep\",\"item\":\"https:\/\/www.sl-p.ch\/winrep\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"Excel Integration\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.sl-p.ch\/#website\",\"url\":\"https:\/\/www.sl-p.ch\/\",\"name\":\"Lorenz + Partner AG\",\"description\":\"Home\",\"publisher\":{\"@id\":\"https:\/\/www.sl-p.ch\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.sl-p.ch\/#organization\",\"name\":\"Lorenz + Partner AG\",\"url\":\"https:\/\/www.sl-p.ch\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.sl-p.ch\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2020\/10\/Zeichenflaeche-1Lorenz-Partner-AG.png\",\"contentUrl\":\"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2020\/10\/Zeichenflaeche-1Lorenz-Partner-AG.png\",\"width\":7037,\"height\":1584,\"caption\":\"Lorenz + Partner AG\"},\"image\":{\"@id\":\"https:\/\/www.sl-p.ch\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Excel Integration - Lorenz + Partner AG","description":"Unsere Software zur Steuerung und Konsolidierung. Die WINREP\u00ae-Software verf\u00fcgt \u00fcber eine dynamische Excel-Schnittstelle (Add-in). Sie ist...","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.sl-p.ch\/en\/winrep\/excel-integration\/","og_locale":"en_US","og_type":"article","og_title":"Excel Integration - Lorenz + Partner AG","og_description":"Unsere Software zur Steuerung und Konsolidierung. Die WINREP\u00ae-Software verf\u00fcgt \u00fcber eine dynamische Excel-Schnittstelle (Add-in). Sie ist...","og_url":"https:\/\/www.sl-p.ch\/en\/winrep\/excel-integration\/","og_site_name":"Lorenz + Partner AG","article_modified_time":"2023-03-24T08:11:05+00:00","og_image":[{"width":1024,"height":1024,"url":"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2021\/12\/lorenz.jpg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/","url":"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/","name":"Excel Integration - Lorenz + Partner AG","isPartOf":{"@id":"https:\/\/www.sl-p.ch\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#primaryimage"},"image":{"@id":"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#primaryimage"},"thumbnailUrl":"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2021\/12\/lorenz.jpg","datePublished":"2021-01-06T09:51:44+00:00","dateModified":"2023-03-24T08:11:05+00:00","description":"Unsere Software zur Steuerung und Konsolidierung. Die WINREP\u00ae-Software verf\u00fcgt \u00fcber eine dynamische Excel-Schnittstelle (Add-in). Sie ist...","breadcrumb":{"@id":"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.sl-p.ch\/winrep\/excel-integration\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#primaryimage","url":"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2021\/12\/lorenz.jpg","contentUrl":"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2021\/12\/lorenz.jpg","width":1024,"height":1024},{"@type":"BreadcrumbList","@id":"https:\/\/www.sl-p.ch\/winrep\/excel-integration\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.sl-p.ch\/"},{"@type":"ListItem","position":2,"name":"Winrep","item":"https:\/\/www.sl-p.ch\/winrep\/"},{"@type":"ListItem","position":3,"name":"Excel Integration"}]},{"@type":"WebSite","@id":"https:\/\/www.sl-p.ch\/#website","url":"https:\/\/www.sl-p.ch\/","name":"Lorenz + Partner AG","description":"Home","publisher":{"@id":"https:\/\/www.sl-p.ch\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.sl-p.ch\/#organization","name":"Lorenz + Partner AG","url":"https:\/\/www.sl-p.ch\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.sl-p.ch\/#\/schema\/logo\/image\/","url":"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2020\/10\/Zeichenflaeche-1Lorenz-Partner-AG.png","contentUrl":"https:\/\/www.sl-p.ch\/wp-content\/uploads\/2020\/10\/Zeichenflaeche-1Lorenz-Partner-AG.png","width":7037,"height":1584,"caption":"Lorenz + Partner AG"},"image":{"@id":"https:\/\/www.sl-p.ch\/#\/schema\/logo\/image\/"}}]}},"_links":{"self":[{"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/pages\/30130"}],"collection":[{"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/comments?post=30130"}],"version-history":[{"count":116,"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/pages\/30130\/revisions"}],"predecessor-version":[{"id":34226,"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/pages\/30130\/revisions\/34226"}],"up":[{"embeddable":true,"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/pages\/28920"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/media\/34230"}],"wp:attachment":[{"href":"https:\/\/www.sl-p.ch\/en\/wp-json\/wp\/v2\/media?parent=30130"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}