Powershell sript to read the multiple columns from excell sheet and search in sharepoint document library which in folder hirachy

Reply

manil2310@gmail.com Posted: 05-09-2012 2:40 AM

rated by 0 users

I need to read the multiple columns from excel sheet with that data need to search in sharepoint document library which is in folder hirachy.

Ex: In excel  

AccountName, EffectiveDate are two columns in excel sheet

In Sharepoint Document library

AccountName is a root folder and EffectiveDate is a subfolder in this folder i need to check for a perticular document if it is found need to extract it to a excel sheet.

Please suggest me

Is it possiable to do it in MOSS 2007 by using windows powershell.

Thanks

Reply

RSiddaway replied on 05-13-2012 3:29 PM

rated by 0 users

MOSS 2007 doesn't have cmdlets available.  You will need to work directly with the .NET classes in a PowerShell script

Reply

manil2310@gmail.com replied on 05-14-2012 3:23 AM

rated by 0 users

Hi Siddaway,

Thanks for your response,

Actually i am new to powershell, according to my requirement can u give me a breef idea how to work on powershell script by using .Net classes.

Thanks in advance