DataSlugger
diff --git a/‎InvokePowerShellNotebook.ps1‎
Lines changed: 4 additions & 1 deletion b/‎InvokePowerShellNotebook.ps1‎
Lines changed: 4 additions & 1 deletion
diff --git a/‎__tests__/InvokePowerShellNotebook.tests.ps1‎
Lines changed: 3 additions & 3 deletions b/‎__tests__/InvokePowerShellNotebook.tests.ps1‎
Lines changed: 3 additions & 3 deletions
@@ -8,6 +8,7 @@ function Invoke-PowerShellNotebook {
 
     Process {
         $codeBlocks = Get-NotebookContent $NoteBookFullName -JustCode
+        $SheetCount = 0
         for ($idx = 0; $idx -lt $codeBlocks.Count; $idx++) {
             $targetCode = $codeblocks[$idx].source
             if ($AsExcel) {
@@ -21,7 +22,9 @@ function Invoke-PowerShellNotebook {
 
                 foreach ($dataSet in , @($targetCode | Invoke-Expression)) {
                     if ($dataSet) {
-                        $uniqueName = "Sheet$($idx)"
+                        #$uniqueName = "Sheet$($idx)"
+                        $SheetCount++
+                        $uniqueName = "Sheet$($SheetCount)"
                         Export-Excel -InputObject $dataSet -Path $xlfile -WorksheetName $uniqueName -AutoSize -TableName $uniqueName
                     }
                 }
 
@@ -63,9 +63,9 @@ Describe "Test Invoke PS Notebook" {
 
         $sheets.Count | Should Be 3
 
-        $sheets[0].Name | Should Be 'Sheet0'
-        $sheets[1].Name | Should Be 'Sheet1'
-        $sheets[2].Name | Should Be 'Sheet2'
+        $sheets[0].Name | Should Be 'Sheet1'
+        $sheets[1].Name | Should Be 'Sheet2'
+        $sheets[2].Name | Should Be 'Sheet3'
 
         Remove-Item $actual -ErrorAction SilentlyContinue
     }