Replies: 3 comments 2 replies
-
|
There have been updates to the Import-Excel function. Do you know what version it started to take 15 minutes? |
Beta Was this translation helpful? Give feedback.
-
|
Thank you for responding. 7.5.0 is when slowness started. I tested in each version released since 7.4.2. |
Beta Was this translation helpful? Give feedback.
-
|
Quick look. I'm guessing this PR #1161 I did to "improve" things caused a performance problem. |
Beta Was this translation helpful? Give feedback.
-
|
Hello, would you be able to let me know if slowness issue will be resolved in the near future? Thank you, we truly appreciate your work! |
Beta Was this translation helpful? Give feedback.
-
|
Not soon. I've created this as an issue and will lock the discussion. #1299 |
Beta Was this translation helpful? Give feedback.
-
I was tasked to import Excel file with 3 columns and about 100,000 records.
$FileContentXLS = Import-Excel -Path $FileName -WorksheetName $WorkSheetName
Version 7.4.2 performs task in 20 seconds, while every new version completes task in 15 minutes.
Would anyone know reason for such discrepancy? Can same optimization be applied to newer versions?
Beta Was this translation helpful? Give feedback.
All reactions