ImportExcel is a powerful tool to manage MS Excel, however, the user is not limited to data stored in worksheets. We can import from and export to SQL Excel data using a combination of ImportExcel and dbatools modules. You can read how to start with dbatools in this blog series. Preparation Let’s prepare our environment…Read More How to import/export data between SQL Server and Excel using PowerShell?
Last month we have been hiding things in Excel, so this week we are going to make sure they are protected as well. Excel offers multiple levels of password protection and its options: locking file with a password, i.e. without key phrase opening file is not possible protecting workbook’s structure lastly, protecting individual worksheets from…Read More How to protect Excel using PowerShell?
Two weeks ago I have sent out the invitation for February 2021 #tsql2sday and last week almost 30 people responded with their contributions. I would like to thank you all of the contributors (see the posts’ list below) for their time. Contributors Here is the list of all contributions to February 2021 #tsql2sday in alphabetical…Read More T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome – write-up
So far we have been working on data or worksheets, but today we will look closer at some workbook-level properties and metadata. Workbook properties Open any Excel file and go to File > Info. You should see something like that on the right side: When you look at the bottom there is a link to…Read More How to change Excel metadata using PowerShell?
Do you have a long list of the Excel sheets in one file? How do you find what you need quickly? Moving around spreadsheets and making coloured tabs might help you. Moving worksheets around When we want to place the worksheet in a different place it is simple as drag&drop or using the context menu.…Read More How to move Excel worksheets using PowerShell?
Winter Spring is coming It is February already, and the good thing is that it is the shortest month, so March is around the corner. I have a pleasure to invite the community for another edition of #TSQL2SDAY. The T-SQL Tuesday is a monthly blog party that happens on the second Tuesday of each month.…Read More T-SQL Tuesday #135: The outstanding tools of the trade that make your job awesome