tags

excel

3 wpisów

Wszystkie terminy Kategorie Tagi Blog
Tagi
Kategorie

3 wpisów

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
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