tags

excel

6 entries

All terms Categories Tags Blog
Tags
Categories

6 entries

Two colleagues reviewing an operational workbook dashboard and marking a follow-up

Build an Excel operational dashboard from PowerShell

Build a multi-sheet Excel dashboard from PowerShell that people can filter, review, and continue editing after it is generated.

powershellpswriteofficeofficeimoexceldashboard
Analyst reviewing a workbook while data moves between two database systems

Move data between databases, CSV, and Excel with DbaClientX and PSWriteOffice

Move database rows through CSV or Excel, bring reviewed changes back safely, and choose the right PowerShell data shape for each step.

dbaclientxpswriteofficeofficeimoexcelsql-servermailozaurr
PSWinDocumentation – Export to Word, Excel, SQL of AD, AWS, Exchange, O365 Exchange, O365 Azure AD

PSWinDocumentation – Export to Word, Excel, SQL of AD, AWS, Exchange, O365 Exchange, O365 Azure AD

Today I’m pushing forward with PSWinDocumentation project. I’ve fixed some bugs but I also added a couple of new features. I did lie a bit…

awsexcelexchangeexportoffice 365powershell
PSWinDocumentation – Version 0.1 with Word / Excel export

PSWinDocumentation – Version 0.1 with Word / Excel export

A few weeks ago I’ve released my first version of PSWinDocumentation. It was simple, one command module where you start it and get some bas…

active directoryadexcelpowershellscriptswindows
Analyst selecting a useful web table beside an editable workbook version

Turn HTML tables into Excel workbooks with PSParseHTML and PSWriteOffice

Parse useful tables from an HTML page and turn them into native Excel workbooks from either PowerShell or C#.

powershellpsparsehtmlpswriteofficehtmltinkerxofficeimoexcel
What do we say to writing Active Directory documentation?

What do we say to writing Active Directory documentation?

Document Active Directory with PowerShell using PSWinDocumentation, Dashimo, Documentimo, and Excelimo to keep environment knowledge curren…

dashimodocumentationdocumentimoexcelexcelimopowershell