platform-compat
Roslyn analyzer that finds usages of APIs that will throw PlatformNotSupportedException on certain platforms. (by dotnet)
ImportExcel
PowerShell module to import/export Excel spreadsheets, without Excel (by dfinke)
| platform-compat | ImportExcel | |
|---|---|---|
| 23 | 99 | |
| 249 | 2,552 | |
| - | 1.4% | |
| 1.2 | 6.5 | |
| over 4 years ago | 5 months ago | |
| C# | PowerShell | |
| MIT License | Apache License 2.0 |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
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.
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.
platform-compat
Posts with mentions or reviews of platform-compat.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2023-05-17.
-
KeePass flaw allows retrieval of master password
DotNet offers the SecureString class to keep a string encrypted in Memory, but as long as the OS does not natively support this concept, the only advantage is that it resides in memory for a shorter time, the disadvantage is that SecureStrings are easier to search for.
- System.Net.Mail.SmtpClient is not recommended anymore; what is the alternative?
-
Bitwarden PINs can be brute-forced
Note the KeePass's resistance to the attack mentioned depends on the security of .NET's secure string, which, here's what Microsoft has to say about it (https://github.com/dotnet/platform-compat/blob/master/docs/D...)
As for KeePassXC, last I checked it didn't even bother.
-
Ever Find A Dead Man's Switch On A Network/Domain?
TIL. Looks like the deprecation note recommends MailKit.
-
Disabilities and Windows Passwords
Well of course, but it does have to be passed to the module that generates the hashes AD uses in the first place. And as I said, the standard password reset screen is bound to store the password in plain text somewhere as well.
-
Embedded logo in HTML email sent from PowerShell
This won’t help you with your question, but I figured I should warn against using send-mailmessage.
-
Alternative to PowerShell cmdlet 'send-mailmessage'
points you here.
-
API pagination help?
Some of the reasons for not using Hashtable or other non-generic collection types are outlined here. That's why Microsoft doesn't recommend their usage in new implementations across all of its API documentation.
- How to deal with credentials in automated scripts?
-
pfSense configuration backup
And if you really want to be secure you need to something better than a SecureString: https://github.com/dotnet/platform-compat/blob/master/docs/DE0001.md
ImportExcel
Posts with mentions or reviews of ImportExcel.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2024-03-13.
-
PSExcel: Excel automation without Excel Overview (2015)
Doug Finke's module became ImportExcel (which can also export): https://github.com/dfinke/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
What are some alternatives?
When comparing platform-compat and ImportExcel you can also consider the following projects:
MailKit - A cross-platform .NET library for IMAP, POP3, and SMTP.
PSScriptAnalyzer - Download ScriptAnalyzer from PowerShellGallery
envconsul - Launch a subprocess with environment variables using data from @HashiCorp Consul and Vault.
EZLog - A very easy and pragmatic log module for admins in a hurry.
dotfiles - Home directory with an absurd amount of tweaks
sqlite-utils - Python CLI utility and library for manipulating SQLite databases