ImportExcel
ImportExcel copied to clipboard
dfinke
PowerShell module to import/export Excel spreadsheets, without Excel
I am exporting a worksheet from an existing package to a final package. It works great except for columns with formulas. For those, it is blank. Here is the command...
Loving this module. Have just starting looking into conditional formatting. I have successfully applied conditional formatting to a cell in column L if it has a value of NO. How...
This isn't an issue but more of a feature request! It would be great to be able to read in the comments of a cell as well as the contents.
The `EndRow` and `EndColumn` parameters are ignored in the `Import-Excel` function because the first mention within said function is hardcoded to set them to 0. This subsequently causes them to...
When using `Import-Excel' to retrieve the content of a specific worksheet that is not available there are two errors thrown while only one is expected. ### Example ```powershell $params =...
This is a re-open of a previous issue (https://github.com/dfinke/ImportExcel/issues/513), asking if other users have managed to overcome it differently? We're using ImportExcel to (amongst other things) stick together reports rendered...
I fully except this may be a user error. [SimplifiedIssueFormattingFiles.txt](https://github.com/dfinke/ImportExcel/files/9072354/SimplifiedIssueFormattingFiles.txt) I've been using the ImportExcel module to combine results from several files into one. I have this working, but spotted...
Hi When trying to create an already existing worksheet in a workbook, PS returns an error Is there any way to force to overwrite the worksheet or check for a...
Hi, I found an issue when testing out the API. When running the below I end up with the default series name and not 'sin(x)'. `PS> $trigdef = New-ExcelChartDefinition -Title...
Hello, I use PowerShell in Version 7.2.6 in Constrained Language Mode. In the Constrained Language Mode I cannot set the TabColor and I get this error message:  Is there...
