powershell tips, ccna tips, tech videos, learn tech
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. [...]
How do you send a file using Powershell 2.0 and a gmail account? Answer: $filename = “c:\scripts_scott\test9999.xls” $smtpserver = “smtp.gmail.com” $msg = new-object Net.Mail.MailMessage $att = new-object Net.Mail.Attachment($filename) $smtp = new-object Net.Mail.SmtpClient($smtpServer ) $smtp.EnableSsl = $True $smtp.Credentials = New-Object System.Net.NetworkCredential(“username”, “password_here”); # Put username without the @GMAIL.com or – @gmail.com $msg.From = “username@gmail.com” $msg.To.Add(”boss@job.com”) $msg.Subject [...]