SharePoint Quick Tip
Thursday 22 June 2017
Wednesday 3 August 2016
Import CSV File in SharePoint list
Import CSV File in SharePoint list
$CSVData = Import-CSV -path "C:\Demo.csv" -Header("Title","Status")
$web = Get-SPWeb -identity "http://ServerName/"
$list = $web.Lists["ListName"]
foreach ($row in $CSVData)
{
$item = $list.Items.Add();
$item["Title"] = $row.Title
$item["Status"] = $row.Status
$item.Update()
}
$CSVData = Import-CSV -path "C:\Demo.csv" -Header("Title","Status")
$web = Get-SPWeb -identity "http://ServerName/"
$list = $web.Lists["ListName"]
foreach ($row in $CSVData)
{
$item = $list.Items.Add();
$item["Title"] = $row.Title
$item["Status"] = $row.Status
$item.Update()
}
Subscribe to:
Posts (Atom)