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…
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…
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…
Tech Wizard 