If you want to import Excel data I recommend giving the people who toke the time to develop this module Import-Excel. It can be Read about on the PSGallery here: https://www.powershellgallery.com/packages/ImportExcel/ After reading we will try to find the module using built im module package for powershell : “find-module importexcel” we can pipe this intoContinue reading “PowerShell Importing Data from Excel”
Category Archives: Functions
Visualizing Data with Excel and Powershell
Recently I was Reading a write-up on API and transforming data with Python. I know this is a blog about PowerShell right? However I want to point out that python is a scripting environment and actually more involved to get started so the restraints of that for a beginner is constricting (Pun intended). PowerShell isContinue reading “Visualizing Data with Excel and Powershell”
User Back up function or Script
First I want to point out the $home variable for individual self initiated back ups. so if you wanted to back up specifics to the current logged in user $home is Sufficient, even if you have DFS / or SMB redirected home folders. if you are backing up all users you need to alsoContinue reading “User Back up function or Script”
PowerShell Get-TimeMachine?!
Well, I know what you’re thinking, it is just click bait. But I want to assure you it is possible. You could create this into a function but the magic is in the details of this one. “New-TimeSpan” is a tool that has existed since 2.0 and before you start-sleep ever again, consider the possibilitiesContinue reading “PowerShell Get-TimeMachine?!”
PowerShell and utilizing it’s Profile.
It may not be something we all wake up in the morning thinking about but to wake up and make your life just a bit easier is something we all think about. probably at more times through out the day. The PowerShell profile that is going to be covered are both user based profiles. OneContinue reading “PowerShell and utilizing it’s Profile.”
Comparing objects, files, and variables in PowerShell
How do you Compare objects? Most people throw things at a problem and see what sticks. Is this a true “solution” or a makeshift glue that can come unraveled at any given moment. I think that when we compare we should understand what is needed and not needed, and really understand our options. UnderstandContinue reading “Comparing objects, files, and variables in PowerShell”
Writing Functions in PowerShell
I would like to propose we should all function as adults at some point in life. maybe not 24 hours a day but enough to take care of ourselves. PowerShell is an area that need you to be functioning to preserve your sanity and time, I will cover simple & advanced functions. A function canContinue reading “Writing Functions in PowerShell”
PowerShell City 