{"id":131,"date":"2013-09-12T09:36:38","date_gmt":"2013-09-12T07:36:38","guid":{"rendered":"http:\/\/ps.stefanrehwald.de\/?p=131"},"modified":"2013-09-12T09:36:38","modified_gmt":"2013-09-12T07:36:38","slug":"powershell-excel-sheet-erstellen","status":"publish","type":"post","link":"https:\/\/ps.stefanrehwald.de\/?p=131","title":{"rendered":"PowerShell &#8211; Excel-Sheet erstellen"},"content":{"rendered":"<p>Mit dem folgendem Script wird ein leeres, unformatiertes Excel-Sheet erstellt und ge\u00f6ffnet. Dazu wird die COM-Schnittstelle genutzt.<\/p>\n<pre class=\"lang:ps decode:true\" title=\"Excel-Sheet Script I\">#Pfad zum Excel-Sheet\r\n$Filepath =\"D:\\Eigene Dateien\\Dokumente\\Excel\\\"\r\n\r\n#Instanzieren eines COM-Objektes f\u00fcr Excel\r\n$Excel = New-Object -ComObject excel.application\r\n#Excel-Sheet sichtbar machen, hei\u00dft, ob es im Vordergrund oder im Hintergrund geschehen soll.\r\n$Excel.Visible = $true\r\n#Arbeitsmappe laden\r\n$Workbook = $Excel.Workbooks.add()\r\n# Neues Arbeitsblatt anlegen\r\n$WorkSheet = $Excel.Worksheets.add()\r\n\r\n#COM-Objektes beenden\r\n$Excel.Quit()\r\n#COM-Objektes aus dem Speicher entfernen\r\n[System.Runtime.Interopservices.Marshal]::ReleaseComObject($excel)<\/pre>\n<p>rewe<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Mit dem folgendem Script wird ein leeres, unformatiertes Excel-Sheet erstellt und ge\u00f6ffnet. Dazu wird die COM-Schnittstelle genutzt. #Pfad zum Excel-Sheet $Filepath =&#8220;D:\\Eigene Dateien\\Dokumente\\Excel\\&#8220; #Instanzieren eines COM-Objektes f\u00fcr Excel $Excel = New-Object -ComObject excel.application #Excel-Sheet sichtbar machen, hei\u00dft, ob es im &hellip; <a href=\"https:\/\/ps.stefanrehwald.de\/?p=131\">Weiterlesen <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":8,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[2,9],"tags":[243,245,244,242,248,246,250,249,247,241],"class_list":["post-131","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-powershell","category-snippet","tag-com","tag-com-objekt","tag-com-schnittstelle","tag-excel","tag-excel-sheel-powershell","tag-excel-sheet","tag-excel-sheet-anlegen","tag-excel-sheet-erstellen","tag-excel-sheet-powershell","tag-powershell-excel"],"aioseo_notices":[],"jetpack_featured_media_url":"https:\/\/ps.stefanrehwald.de\/wp-content\/uploads\/2013\/08\/logo_powershell.jpg","jetpack_shortlink":"https:\/\/wp.me\/p3N2Ht-27","jetpack_sharing_enabled":true,"_links":{"self":[{"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=\/wp\/v2\/posts\/131","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=131"}],"version-history":[{"count":2,"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions"}],"predecessor-version":[{"id":148,"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=\/wp\/v2\/posts\/131\/revisions\/148"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=\/wp\/v2\/media\/8"}],"wp:attachment":[{"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=131"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=131"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ps.stefanrehwald.de\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=131"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}