Matthew Gray
Matthew Gray
I created my own "Today" button. It is also useful to have a button "Cancel"
I did not dig enough deep but inserting expression `if ($StartRow -eq $EndRow) {$rows = 0}` after line 182 would resolve the issue and would give some hints to further...
Try to comment setting `powershell.powerShellDefaultVersion`. It worked for me on several computers.
@EdCallahan The value of `Windows PowerShell (x64)` does not work (dont know why) and causes the PS extension never start.
> I know that this setting says it "has no effect on Windows" _but_ I can reproduce the hang when it's set to its default (true) and it stops hanging...
Test snippet for whom it may concern ```powershell function Use-Culture { param ( [System.Globalization.CultureInfo]$culture = (throw "USAGE: Use-Culture -Culture culture -Script {scriptblock}"), [alias('sb')][ScriptBlock]$scriptblock = (throw "USAGE: Use-Culture -Culture culture -Script...
`EPPlus` does not update `app.xml` file in openxml definition, that's why Excel can see `ps_created_name` range name which is present in `workbook.xml` file, but `EPPlus` cannot. This is definitely a...
At shallow sight `Open-ExcelPackage` does not utilize `useStream` property that is why `stream` property is empty.
The problem is with illegal chars in filepath because the module uses default `-path` parameter which `Resolve-Path` treates brackets `[]()` as a regular expression. There should be introduced a new...
The work around would be to rename the file removing brackets `[]()` before using `Import-Excel` ```powershell $newname = Rename-Item -LiteralPath -NewName (split-path ( -replace '[\[\]\(\)]') -leaf) -PassThru Import-Excel $newname.fullname ```