Tools

ImportExcel - PowerShell module ImportExcel - PowerShell module

Last week I have introduced you to ImportExcel PowerShell module and its capability to manipulate the worksheets and create pivot tables and pivot charts. This week let’s jump on some other features: conditional formatting and charts. ImportExcel – how to? If you have not installed the module before, use the below code to do so…

Read More PowerShell into Excel:ImportExcel Module Part 2

ImportExcel - PowerShell module ImportExcel - PowerShell module

While ago I needed to do some manipulation on Excel spreadsheets but had no Office installed on the server. For the specific case, I looked for a way to complete my task with the PowerShell. A quick look into Google search results and… Even though the name is not specified, both articles talk about the…

Read More PowerShell into Excel:ImportExcel Module Part 1

Post thumbnail

Last time I have joined the T-SQL Tuesday was about life hacks, and this month thanks to Kenneth Fisher’s (blog|twitter) invitation I will show you something I have used recently. While ago I had to draw some diagrams. At that time I did not have MS Visio available. Additionally, I wanted to use something I…

Read More T-SQL Tuesday #127: Non SQL Tips and tricks