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

AzureAdventCalendar.com AzureAdventCalendar.com

Azure Advent Calendar About three months ago @Pixel_Robots and @gregor_suttie has invited the community to participate in Azure Advent Calendar. Working with Azure? Join the 2019 Azure Advent Calendar and showcase your knowledge where others can benefit, help the Azure Community and help each other.#azurefamily #azureadventcalendar https://t.co/s0U6SFh97zplease retweet pic.twitter.com/nTUcD3rIzG — Gregor Suttie – in Prague (@gregor_suttie)…

Read More Azure Advent Calendar 2019: Azure Data Studio