PSScriptAnalyzer
ImportExcel
PSScriptAnalyzer | ImportExcel | |
---|---|---|
15 | 98 | |
1,781 | 2,361 | |
1.0% | - | |
7.4 | 5.3 | |
7 days ago | 15 days ago | |
C# | PowerShell | |
MIT License | Apache License 2.0 |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
PSScriptAnalyzer
-
Using PSScriptAnalyzer to check PowerShell version compatibility - Building custom compat profiles
I am looking to build a custom profile for a ws2019 with ps 7.2 + to use to check my scripts, i have tried using the compat collector https://github.com/PowerShell/PSScriptAnalyzer/tree/development/PSCompatibilityCollector and running the build.ps1 script there but I do not see an output for my commands and the script text doesn't provide much clarify to me at least.
-
What open source tools do you use to check the security of your PowerShell scripts?
PSScriptAnalyze is a static code analysis tool that checks PowerShell scripts for best practices and potential security issues. It is available on GitHub and can be installed as a module in PowerShell. https://github.com/PowerShell/PSScriptAnalyzer
-
PSScriptAnalyzer
PSScriptAnalyzer is a static code checker for PowerShell modules and scripts. Runs a set of rules that test the quality of PowerShell code against best practice, then warns about potential code defects and suggests potential solutions. xXxLinuxUserxXx likes this linter "to get unified codestyle in the scripts."
-
I made a Dell Command Script for Intune, thought others may find it helpful.
Not a windows admin and more like a programmer but i would suggest to use some linter (https://github.com/PowerShell/PSScriptAnalyzer) to get unified codestyle in the scripts :)
-
Azure Guest Invitation
It’s best practice to keep $null on the left side of comparisons https://github.com/PowerShell/PSScriptAnalyzer/blob/development/RuleDocumentation/PossibleIncorrectComparisonWithNull.md
- Dangerous and Insecure PowerShell Code in the Enterprise
-
Smarter autocomplete
This one is a real problem. When I reference a type which is defined in another file in a class, I get an error in my vscode. the class works but the PSScriptAnalyzer doesn't know that the type is imported. I found this github issue which is about supressing the issue, I tried that and couldnt get it to work but I'd rather that it just recognized the type from the other file https://github.com/PowerShell/PSScriptAnalyzer/issues/1041
-
Who uses Visual Studio Code for PowerShell Scripting?
I would definer not autoformat on save with bugs such was this still outstanding: https://github.com/PowerShell/PSScriptAnalyzer/issues/1580
-
help with add-newuser profile names
That's some sloppy code. Wmic is deprecated. You shouldn't put unencrypted passwords in scripts. You shouldn't use write-host anymore. $null goes in front, etc. Try using https://github.com/PowerShell/PSScriptAnalyzer to ensure decent code. Also write code in vscode. Also read https://docs.microsoft.com/en-us/powershell/module/microsoft.powershell.localaccounts/new-localuser?view=powershell-5.1
-
Module workflow in VS Code?
I discovered the Invoke-Build build system, PSScriptAnalyzer for linting, and Pester for testing/mocking. I wrote a GitLab CI/CD pipeline that takes advantage of all of this to push releases to our company's PSRepo. I also discovered the Plaster template system for scaffolding new projects, and created a custom company template for standardizing our repo structures.
ImportExcel
- Show HN: Query Your Sheets with SheetSQL
-
Is there a function similar to VLOOKUP in Excel?
Examples here that are similar to what you are trying to accomplish - https://github.com/dfinke/ImportExcel
- Automate Excel with only powershell?
-
PS Module "ImportExcel" - Output is faulty
Did you visit the GitHub repo and read the docs & examples? https://github.com/dfinke/ImportExcel
-
ImportExcel and conditional formatting inconsistancies
If you can create a reproducible example with sample data and code that re-creates the issue from nothing, post it to the project's issues on Github. The module's authors have been very quick to resolve the issues I've had, usually fixing the problem in a week or two.
- How do I ingest data from a daily CSV report into a 'main' report?
-
Create multiple tables from a single table based on a column?
If you're using scripting, I have to recommend ImportExcel for Powershell.
-
update csv cell without new export
You might be able to use https://github.com/dfinke/ImportExcel to alter single cells in a csv file but I'm not 100% sure.
-
PowerShell Export-Excel Pivot Table Issue
Have you looked at the examples? Examples
-
Powershell & MSWord: Pulling AD Information and making it look “nice”?
Maybe look at ImportExcel, it allows to put any list of objects right into Excel sheets, with insane customization capabilities.
What are some alternatives?
Pester - Pester is the ubiquitous test and mock framework for PowerShell.
PSWriteHTML - PSWriteHTML is PowerShell Module to generate beautiful HTML reports, pages, emails without any knowledge of HTML, CSS or JavaScript. To get started basics PowerShell knowledge is required.
vscode-powershell - Provides PowerShell language and debugging support for Visual Studio Code
sqlite-utils - Python CLI utility and library for manipulating SQLite databases
PSReadLine - A bash inspired readline implementation for PowerShell
WinPython - A free Python-distribution for Windows platform, including prebuilt packages for Scientific Python.
nvim-lsp-installer - Further development has moved to https://github.com/williamboman/mason.nvim!
psPAS - PowerShell module for CyberArk Privileged Access Security REST API
jtbl - CLI tool to convert JSON and JSON Lines to terminal, CSV, HTTP, and markdown tables
PoshBot - Powershell-based bot framework
libxo - The libxo library allows an application to generate text, XML, JSON, and HTML output using a common set of function calls. The application decides at run time which output style should be produced.
platform-compat - Roslyn analyzer that finds usages of APIs that will throw PlatformNotSupportedException on certain platforms.