Get-Children -Recurse hangs when piped to ConvertTo-Excel

EvotecIT / PSWriteExcel

PSWriteExcel is very basic (at the moment) PowerShell module to create Microsoft Excel workbooks without Microsoft Excel installed.

61 stars 12 forks source link

Get-Children -Recurse hangs when piped to ConvertTo-Excel #4

Closed WearAHelmet closed 4 years ago

WearAHelmet commented 4 years ago

Get-ChildItem -Path ./Documents | ConvertTo-Excel -FilePath /home/vern/test/t.xlsx # Works fine

Get-ChildItem -Path ./Documents -Recurse | ConvertTo-Excel -FilePath /home/vern/test/t.xlsx # Hangs

Running on: Linux casey 5.3.0-46-generic #38-Ubuntu SMP Fri Mar 27 17:37:05 UTC 2020 x86_64 x86_64 x86_64 GNU/Linux

PSWriteExcel 0.1.5

PrzemyslawKlys commented 4 years ago

Maybe there are a lot of files to process? How long have you waited?

WearAHelmet commented 4 years ago

Your question made me go back and test again. It turns out that it does finish, and I think I was underestimating how large of a file Get-ChildItem -Recurse might create. Guess it was a performance issue. Sorry.

PrzemyslawKlys commented 4 years ago

No problem :-)