Convert any CSV to Formatted Excel file

Many of my scripts I created in the past required to have a Excel report instead of plain CSV, as these reports are for different Technical/Management/Leadership teams. Today We got one such requirement where excel report is required therefore to make it easy for future I wrote a powershell code that takes CSV as input…

PowerShell TIP – CSV to EXCEL

Sharing a tip that will guide many of you in converting CSV to EXCEL in a fast manner. We have some scripts where the creator has got the large data in a variable or exported to CSV and than called excel to write data one row at a time which was taking around 10 to…

Connect Excel to SQL

Hi All, Today I am sharing a method that We can use –> connect Excel to SQl server database. Steps to follow:- 1. open excel 2. From data Tab select –>From other Sources –>From SQL server 3.  Enter server Name & authentication mechanism 4.  Select database & then select the table 5.  Click finish 6. click…