{"type":"doc","content":[{"type":"extension","attrs":{"layout":"default","extensionType":"com.atlassian.confluence.macro.core","extensionKey":"toc","parameters":{"macroParams":{},"macroMetadata":{"macroId":{"value":"4f4e0431-4c49-4d0c-b498-c8aff67d8ee8"},"schemaVersion":{"value":"1"},"title":"Table of Contents"}},"localId":"d5b4efeb-00fb-45a0-8f94-8b8c1a5d236f"}},{"type":"rule"},{"type":"paragraph","content":[{"text":"Über die ExcelData-Schnittstelle kann auf Excel-Dateien zugegriffen werden.","type":"text"}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Konfiguration","type":"text"}]},{"type":"paragraph","content":[{"text":"Neben der ","type":"text"},{"text":"Mapping","type":"text","marks":[{"type":"code"}]},{"text":"- und ","type":"text"},{"text":"SearchParameters","type":"text","marks":[{"type":"code"}]},{"text":"-Konfiguration, welche alle ","type":"text"},{"text":"DataProvider","type":"text","marks":[{"type":"code"}]},{"text":" der ","type":"text"},{"type":"inlineCard","attrs":{"url":"https://primesoft-group.atlassian.net/wiki/spaces/PDT/pages/63537333"}},{"text":" benötigen, kann der ","type":"text"},{"text":"ExcelDataProvider","type":"text","marks":[{"type":"code"}]},{"text":" im ","type":"text"},{"text":"Options","type":"text","marks":[{"type":"code"}]},{"text":"-Element noch weiter konfiguriert werden:","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \\\\fileshare\\addressdata.xlsx\n true\n Data\n \n ...\n","type":"text"}]},{"type":"heading","attrs":{"level":3},"content":[{"text":"Inhalte für","type":"text"},{"text":" ","type":"text","marks":[{"type":"strong"}]},{"text":"Options","type":"text","marks":[{"type":"code"}]},{"text":" in ","type":"text"},{"text":"ExcelDataProvider","type":"text","marks":[{"type":"code"}]}]},{"type":"table","attrs":{"width":760.0,"localId":"d034b2f8-e39c-4856-9735-c175d6358986"},"content":[{"type":"tableRow","content":[{"type":"tableHeader","attrs":{"colspan":1,"background":"var(--ds-background-accent-gray-subtlest, #F4F5F7)","rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"Elementname","type":"text","marks":[{"type":"strong"}]}]}]},{"type":"tableHeader","attrs":{"colspan":1,"background":"var(--ds-background-accent-gray-subtlest, #F4F5F7)","rowspan":1,"colwidth":[588.0]},"content":[{"type":"paragraph","content":[{"text":"Beschreibung","type":"text","marks":[{"type":"strong"}]}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"FilePath","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[588.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text","marks":[{"type":"em"}]},{"text":", Pfad zur XLSX Datei","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"HasHeader","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[588.0]},"content":[{"type":"paragraph","content":[{"text":"bool","type":"text","marks":[{"type":"em"}]},{"text":", Angabe ob die erste Zeile eine Kopfzeile ist","type":"text"},{"type":"hardBreak"},{"text":"Wenn keine Header vorhanden sind, werden die Spalten wie in Excel hochgezählt (A, B, …) (wichtig für ","type":"text"},{"text":"SearchParameters","type":"text","marks":[{"type":"code"}]},{"text":" und ","type":"text"},{"text":"Mapping","type":"text","marks":[{"type":"code"}]},{"text":").","type":"text"}]}]}]},{"type":"tableRow","content":[{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[172.0]},"content":[{"type":"paragraph","content":[{"text":"SheetName","type":"text","marks":[{"type":"code"}]}]}]},{"type":"tableCell","attrs":{"colspan":1,"rowspan":1,"colwidth":[588.0]},"content":[{"type":"paragraph","content":[{"text":"string","type":"text","marks":[{"type":"em"}]},{"text":", Angabe des Tabellenblatt","type":"text"}]}]}]}]},{"type":"heading","attrs":{"level":1},"content":[{"text":"Beispiel-XML-Konfiguration","type":"text"}]},{"type":"codeBlock","attrs":{"language":"xml"},"content":[{"text":"\n \n \\\\fileshare\\addressdata.xslx\n true\n Data\n \n \n \n \n \n \n \n \n \n \n \n \n","type":"text"}]}],"version":1}