-
By wmoore I decided to use the exchange powershell and Excel 2007 to accomplish this task and below are the two scripts I used to accomplish it. First, the Exchange 2007 Powershell script:. #create the output file #$file = new-item -itemtype file ... Read More
-
By Chad Miller Since SSRS reports can use DataTables as a data sources I thought this would make a nice way to export the output of any Powershell command/script to a number of different formats natively supported by SSRS including Excel, PDF, ... Read More
Posted to
General
(Forum)
by
ps2
on
04-17-2009
Filed under: Output, PDF, Excel, Image File
-
Hi all! May problem is: I have a scirpt, that read out the data from an excel file: Quote: $excel = New-Object -COM Excel.Application $ci = [ System.Globalization.CultureInfo ] 'en-US' $src = "path:excel.xls" $book = $excel .Workbooks.PSBase.GetType().InvokeMember( 'Open' ,...
-
Hi all! I have a little problem. I trasfer data to an excel worksheet. The data is integer, and start with 2 zeros: example: 00231441 Its working, but when the script load these numbers into the worksheet, it cut the zeros. But if the cells format is string, it is working fine. So, I would like to set...
-
I have written a script that pulls the prohibit send flag and forwards that info to an email. I would like to embed this table or excel in the email. I have not found proper formatting instructions or forum notes. Any help would be great. The script works well, I just need to pretty it up a bit Add-PSSnapin...
-
Hello, I have VBA script that allows me to export the contents of a Excel spreadsheet into a CSV file. I have been trying to figure out how to get the VBA command into a PS command and am lost on the parameters. I would like to open the spreadsheet in read-only mode and not see Excel and not prompt me...
-
office excel template .xlt -> double click = document openned (title of document="template") -> right click, select Open = document openned (title of document="template.xlt") If I double click a office excel template the title of the document has the file name without the file...
-
Hello, friends ... I created a script that opens Excel using examples from the Internet, as follows: $objExcel = new-object -comobject excel.application $objExcel.Visible = $True $objWorkbook1 = $objExcel.Workbooks.Open("C:\MyFile.xlsm") This script works perfectly: it opens the workbook that...
-
Fatbeard wrote a script to get all VMs and populate an Excel spreadsheet. Read More