powershell tips, ccna tips, tech videos, learn tech
In the morning to all you Techjunkies out there. I ran into an issue at work today as I was creating a bunch of excel sheets for my boss. The issue I was running into was that as I was entering columns into Excel. I started noticing I had to scroll all the way to [...]
I was going nuts trying to find how to center my values in a excel spreadhseet. I finally found it at this site. here is the code: $Sheet.Range(“A1″, “B1″).MergeCells = $True $Sheet.Range(“A1″, “B1″).horizontalalignment = -4108 $Sheet.Cells.Item(1,1) = “november” What gets me is that we have to remember the value -4108 Let me know what you [...]
Question: How do you use Powershell to edit an excel file automatically? That is the question I asked myself when my boss asked me for a dynamic monthly report from a couple systems. I query a database and capture the results. Then I put in the excel file with the correct formatting and save it. [...]
Convert Hexadecimal to Decimal