ImportExcel
PoshBot
Our great sponsors
| ImportExcel | PoshBot | |
|---|---|---|
| 98 | 4 | |
| 2,361 | 527 | |
| - | 0.6% | |
| 5.3 | 0.0 | |
| 11 days ago | almost 2 years ago | |
| PowerShell | PowerShell | |
| Apache License 2.0 | MIT License |
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.
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.
PoshBot
-
Looking for advice in creating event-driven PowerShell Scripts
5) You might want to have some reporting whenever your service triggers. For that you can use Slack or MS Teams, there's a PowerShell module that helps here, it's called PoshBot (you could also trigger your API through Slack). This is referred to as ChatOps.
-
Azure Functions bot | PowerShell
If you really want to build this yourself, then I applaud you, however, PoshBot exists and we use it at work. https://github.com/poshbotio/PoshBot
-
Script for end user to restart a service on a remote server.
If you use Teams or Slack, you could trigger this with Poshbot. https://github.com/poshbotio/PoshBot
-
PowerShell/Automation Ideas
GitHub - poshbotio/PoshBot: Powershell-based bot framework
What are some alternatives?
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.
awesome-chatops - :robot: A collection of awesome things about ChatOps – managing operations through a chat
sqlite-utils - Python CLI utility and library for manipulating SQLite databases
BotFramework-Emulator - A desktop application that allows users to locally test and debug chat bots built with the Bot Framework SDK.
WinPython - A free Python-distribution for Windows platform, including prebuilt packages for Scientific Python.
tentools - 💙 tenable.sc / nessus / acas powershell module
psPAS - PowerShell module for CyberArk Privileged Access Security REST API
botly-chatbot - Botly Chat Nodejs
PSScriptAnalyzer - Download ScriptAnalyzer from PowerShellGallery
gort - Gort is a chatbot framework designed from the ground up for chatops.
platform-compat - Roslyn analyzer that finds usages of APIs that will throw PlatformNotSupportedException on certain platforms.
Eventful - Easy Eventful PowerShell