DataSlugger
diff --git a/‎InvokePowerShellNotebook.ps1‎
Lines changed: 15 additions & 5 deletions b/‎InvokePowerShellNotebook.ps1‎
Lines changed: 15 additions & 5 deletions
diff --git a/‎__tests__/InvokePowerShellNotebook.tests.ps1‎
Lines changed: 4 additions & 0 deletions b/‎__tests__/InvokePowerShellNotebook.tests.ps1‎
Lines changed: 4 additions & 0 deletions
@@ -2,7 +2,8 @@ function Invoke-PowerShellNotebook {
     param(
         [Parameter(ValueFromPipelineByPropertyName)]
         $NoteBookFullName,
-        [Switch]$AsExcel
+        [Switch]$AsExcel,
+        [Switch]$Show
     )
 
     Process {
@@ -12,21 +13,30 @@ function Invoke-PowerShellNotebook {
             if ($AsExcel) {
                 if ($idx -eq 0) {
                     $xlfile = $NoteBookFullName -replace ".ipynb", ".xlsx"
+                    $xlfile = "$PSScriptRoot\$xlfile"
                     Remove-Item $xlfile -ErrorAction SilentlyContinue
                 }
 
                 $uniqueName = "Sheet$($idx+1)"
-                $targetCode |
-                    Invoke-Expression |
-                    Export-Excel -Path $xlfile -WorksheetName $uniqueName -AutoSize -TableName $uniqueName
+                foreach ($dataSet in , @($targetCode | Invoke-Expression)) {
+                    Export-Excel -InputObject $dataSet -Path $xlfile -WorksheetName $uniqueName -AutoSize -TableName $uniqueName
+                }
+
+                # $targetCode | Invoke-Expression |
+                # Export-Excel -Path $xlfile -WorksheetName $uniqueName -AutoSize -TableName $uniqueName
             }
             else {
                 , @($targetCode | Invoke-Expression)
             }
         }
 
         if ($AsExcel) {
-            Invoke-Item $xlfile
+            if ($Show) {
+                Invoke-Item $xlfile
+            }
+            else {
+                $xlfile
+            }
         }
     }
 }
@@ -39,4 +39,8 @@ Describe "Test Invoke PS Notebook" {
         $actual[2].Count | Should Be 10
     }
 
+    # It "Should export this to an Excel file from the testPSExcel.ipynb" {
+    #     $actual = Invoke-PowerShellNotebook "$PSScriptRoot\GoodNotebooks\testPSExcel.ipynb" -AsExcel
+    #     #$actual | Should Be ""
+    # }
 }
Original file line number	Diff line number	Diff line change
`@@ -2,7 +2,8 @@ function Invoke-PowerShellNotebook {`
`2`	`2`	`param(`
`3`	`3`	`[Parameter(ValueFromPipelineByPropertyName)]`
`4`	`4`	`$NoteBookFullName,`
`5`		`- [Switch]$AsExcel`
	`5`	`+ [Switch]$AsExcel,`
	`6`	`+ [Switch]$Show`
`6`	`7`	`)`
`7`	`8`
`8`	`9`	`Process {`
`@@ -12,21 +13,30 @@ function Invoke-PowerShellNotebook {`
`12`	`13`	`if ($AsExcel) {`
`13`	`14`	`if ($idx -eq 0) {`
`14`	`15`	`$xlfile = $NoteBookFullName -replace ".ipynb", ".xlsx"`
	`16`	`+ $xlfile = "$PSScriptRoot\$xlfile"`
`15`	`17`	`Remove-Item $xlfile -ErrorAction SilentlyContinue`
`16`	`18`	`}`
`17`	`19`
`18`	`20`	`$uniqueName = "Sheet$($idx+1)"`
`19`		`- $targetCode \|`
`20`		`- Invoke-Expression \|`
`21`		`- Export-Excel -Path $xlfile -WorksheetName $uniqueName -AutoSize -TableName $uniqueName`
	`21`	`+ foreach ($dataSet in , @($targetCode \| Invoke-Expression)) {`
	`22`	`+ Export-Excel -InputObject $dataSet -Path $xlfile -WorksheetName $uniqueName -AutoSize -TableName $uniqueName`
	`23`	`+ }`
	`24`	`+`
	`25`	`+ # $targetCode \| Invoke-Expression \|`
	`26`	`+ # Export-Excel -Path $xlfile -WorksheetName $uniqueName -AutoSize -TableName $uniqueName`
`22`	`27`	`}`
`23`	`28`	`else {`
`24`	`29`	`, @($targetCode \| Invoke-Expression)`
`25`	`30`	`}`
`26`	`31`	`}`
`27`	`32`
`28`	`33`	`if ($AsExcel) {`
`29`		`- Invoke-Item $xlfile`
	`34`	`+ if ($Show) {`
	`35`	`+ Invoke-Item $xlfile`
	`36`	`+ }`
	`37`	`+ else {`
	`38`	`+ $xlfile`
	`39`	`+ }`
`30`	`40`	`}`
`31`	`41`	`}`
`32`	`42`	`}`
Original file line number	Diff line number	Diff line change
`@@ -39,4 +39,8 @@ Describe "Test Invoke PS Notebook" {`
`39`	`39`	`$actual[2].Count \| Should Be 10`
`40`	`40`	`}`
`41`	`41`
	`42`	`+ # It "Should export this to an Excel file from the testPSExcel.ipynb" {`
	`43`	`+ # $actual = Invoke-PowerShellNotebook "$PSScriptRoot\GoodNotebooks\testPSExcel.ipynb" -AsExcel`
	`44`	`+ # #$actual \| Should Be ""`
	`45`	`+ # }`
`42`	`46`	`}`