Quick ? about Get-Content - PowerShellCommunity.org - Windows PowerShell Discussion Forums - Using PowerShell

Forums Search Members

Quick ? about Get-Content

Last Post 09 May 2008 05:52 PM by valdezdj. 3 Replies.

Sort:

	Prev Next
You are not authorized to post a reply.

Author

Messages

valdezdj

New Member
Posts:62

08 May 2008 11:23 PM
I have a spreadsheet that I want to pull data from but its in the 7th column. How do I just get the data from that column with get-content? I've looked all over and I can't find any examples or information on the topic.

halr9000

Basic Member
Posts:303

09 May 2008 12:20 AM
There's a bit of code here. Here's one on the newsgroup. The short answer is this (which came from here) $a = New-Object -comobject Excel.Application $a.Visible = $True $b = $a.Workbooks.Add() $c = $b.Worksheets.Item(1) $c.Cells.Item(1,1) = "A Value in cell A1."

halr9000

Basic Member
Posts:303

09 May 2008 12:45 AM
Duh, I knew I had read this recently--it was open in another tab. http://techstarts.wordpress.com/2008/05/05/powershell-and-excel/

valdezdj

New Member
Posts:62

09 May 2008 05:52 PM
Ok that should work, I'll try it when I get time. Thanks for the help and I'll let you know if I run into any problems.

You are not authorized to post a reply.

Active Forums 4.1