DOWST.DEV

Automate the Admin – YouTube (youtube.com)
A fun presentation I did for the NYC user group showing you how to automate the boring tasks using

PowerShell.

(+)
By: Matthew Dowst submitted:Jun 16 2022

Convert specific table of excel sheet to JSON using PowerShell (devblogs.microsoft.com)
This posts explains how to Convert Specific Table of Excel Sheet to JSON
By: Sonam Rastogi submitted:Apr 14 2023

Cut and Paste Between Worksheets in Excel using Powershell (reddit.com)
Yesterday I posted here asking if anyone knew how to cut and paste between two worksheets in an

excel file. I never really got a response with a solution. I finally figured it out and wanted to share.

...>more
By: u/gregj529 submitted:Jun 16 2022

Excel Charts from PowerShell data (powershell.city)
Looking to make Reports more sharing friendly? Script Time!!!!
By: Xajuan Smith submitted:Jun 15 2022

How do you read word document files using powershell? (reddit.com)
Compared to text files when I use Get-Content on a word document it shows some weird symbols as if

it was obfuscated. How can I properly make powershell display the contents of a word document without downloading anything?

(+)
By: u/RallyAngelo submitted:Jan 20 2023

How to add pictures to Excel with PowerShell? (bronowski.it)
Spreadsheets' main purpose is data: storing, manipulating and analyzing them. We can add some

colours or charts to make the data more friendly, but sometimes we may want to add something else - like a logo or picture and all that can be achieved with PowerShell.

...>more
By: Mikey Bronowski submitted:Jun 16 2022

How to import/export data between SQL Server and Excel using PowerShell? (bronowski.it)
ImportExcel is a powerful tool to manage MS Excel, however, the user is not limited to data stored

in worksheets. We can import from and export to SQL Excel data using a combination of ImportExcel and dbatools modules.

...>more
By: Mikey Bronowski submitted:Jun 16 2022

How to Read Outlook Emails with PowerShell (woshub.com)
Let's look at how to open, read, and parse emails in a connected Outlook mailbox from within a

PowerShell script. Outlook MAPI allows you to directly access the mailbox, list...

(+)
By: Windows OS Hub submitted:Apr 26 2024

Learn to Automate Excel like a Pro with PowerShell (dfinke.github.io)
Everyone wants to produce slick looking reports. Want to impress management? Use PowerShell

and Install-Module -Name ImportExcel.

...>more
By: submitted:Jun 15 2022

Mass Upgrade .doc .xls and .ppt files to their relative .x file format (reddit.com)
Posting here after helping someone from this subreddit, and hoping that this may help save others

some headaches as well. The below updates .doc to .docx .xls to .xlsx and .ppt to .pptx, optionally deletes the old files if you un-comment the remove-item lines

(+)
By: u/oneAwfulScripter submitted:Jun 16 2022

Microsoft Office 2016 to O365 script (reddit.com)
Hello PowerShell users I would like to share my script today. At work I was tasked with uninstalling

O2016 and upgrading to O365 and created an interactive .ps1 script to auto uninstall O2016. Here she is:

(+)
By: u/green-avocado submitted:Jun 17 2022

Module Monday: ImportExcel (youtube.com)
This Monday, I looked at ImportExcel. ImportExcel is a PowerShell module for manipulating Excel

files. You don't even need Excel installed. It's super cool!

...>more
By: Adam Driscoll submitted:Jun 16 2022

Monitoring with PowerShell: Monitoring Outlook offline mode and OST Sizes, and active PSTS (cyberdrain.com)
Todays blog I'm going to be showing how to monitor if outlook has been set to offline mode by the

user, and if the OST size is nearing it's maximum size, as a bonus I'm also giving you the option of alerting on active PST files. The offline mode is just a handy gizmo to notify users that they might've misclicked - It still happens to our users from time to time.

...>more
By: Kelvin Tegelaar submitted:Jun 16 2022

Outlook Email Mover (thedxt.ca)
The way I manage my email might seem a bit strange. Due to working in IT, I get lots of emails. Some

emails need action, some are regular emails, and some are notifications I want to know about as soon as they happen. I feel like a normal person would make an Outlook rule to...

(+)
By: Daniel Keer submitted:Sep 27 2024

PoshTaskbarItem: module to make simple UIs on the Windows taskbar (reddit.com)
Some months ago, I shared a script here that notifies you of unread Outlook emails by badge

notifications on the taskbar. I got some positive comments and decided to make a module for the taskbar handling part so that anyone can quickly make their tools.

(+)
By: u/mdgrs-mei submitted:Aug 19 2022

PowerShell Import-Excel (github.com)
This PowerShell Module allows you to read and write Excel files without installing Microsoft Excel

on your system. No need to bother with the cumbersome Excel COM-object. Creating Tables, Pivot Tables, Charts and much more has just become a lot easier. It has recently been updated to run much faster.

...>more
By: submitted:Jun 15 2022

QuickFix: Cannot Start Microsoft Outlook. The set of Folder cannot be opened, using PowerShell (powershellcenter.com)
Outlook users may face an issue when trying to connect to Exchange Server, where Outlook won't start

and instead shows the following error message "Cannot Start Microsoft Outlook. Cannot open the Outlook Window. The set of folders cannot be opened. The attempt to log on to Microsoft Exchange has failed"

(+)
By: Faris Malaeb submitted:Jul 14 2023

Removing Outlook Add-ins From Mailboxes with PowerShell (office365itpros.com)
The Share to Teams Outlook add-in posts an email to a Teams chat or channel conversation. I was

asked how to disable the add-in for some mailboxes. Here's how to do the job using PowerShell to find a set of target mailboxes and then turn off Send to Teams for each mailbox.

(+)
By: Tony Redmond submitted:May 3 2024

Saving PowerPoint Deck as a PDF – with PowerShell 7 (tfl09.blogspot.com)
This week, I got into a twitter discussion about a presenter posting their slides for delegates. My

personal preference is to always share the slides. Often, especially when I was working for an employer, I'd share a PDF of the file rather than the slides. Some decks had had a LOT of effort put in (some by inhouse graphics guys) and giving those animations away was sub-optimal for IP reasons.

(+)
By: Thomas Lee submitted:Jun 16 2022

Send a mail using the current outlook user account without to provide credentials with PowerShell (systanddeploy.com)
In this post I will show you how to send a mail using the current outlook user account without to

provide credentials....

...>more
By: Damien Van Robaeys submitted:Jun 16 2022

Turn PowerShell Into Your Excel Automation Machine (youtube.com)
Get ready to see how PowerShell can transform the way you work with Excel.
By: Doug Finke submitted:Sep 13 2024

Use PowerShell to change your Office ProPlus theme (cloudappie.nl)
Switching back for Windows was made easy by Lumos, but I also use Office. So it made sense to try

and set the Office theme using PowerShell as well.

...>more
By: submitted:Jun 15 2022

Using the new PowerShell profiler to profile `Export-Excel` (twitter.com)
Using the new PowerShell profiler to profile `Export-Excel` and then use `Export-Excel` to export

the trace, and apply a data bar

...>more
By: Doug Finke submitted:Jun 16 2022

Office

PowerShell Weekly – Your weekly round up of all things PowerShell

Categories

Archive