ImportExcel VS powershell

Examples here that are similar to what you are trying to accomplish - https://github.com/dfinke/ImportExcel

Did you visit the GitHub repo and read the docs & examples? https://github.com/dfinke/ImportExcel

If you can create a reproducible example with sample data and code that re-creates the issue from nothing, post it to the project's issues on Github. The module's authors have been very quick to resolve the issues I've had, usually fixing the problem in a week or two.

If you're using scripting, I have to recommend ImportExcel for Powershell.

You might be able to use https://github.com/dfinke/ImportExcel to alter single cells in a csv file but I'm not 100% sure.

Have you looked at the examples? Examples

Maybe look at ImportExcel, it allows to put any list of objects right into Excel sheets, with insane customization capabilities.

Here is my Module that includes my functions on Azure Extension Properties. It uses the PnP.PowerShellmodule instead of the Graph SDK.

# Use system-assigned managed identity # https://mmsharepoint.wordpress.com/2023/05/04/authentication-in-azure-automation-with-managed-identity-on-sharepoint-and-microsoft-graph/ # https://pnp.github.io/powershell/articles/azureautomationrunbook.html # Connect to multiple sites # https://github.com/pnp/powershell/issues/1748 # https://robdy.io/multiple-pnp-connections/ # Prod $SourceStr = Get-AutomationVariable -Name 'SharePointSourceFolders' $Target = Get-AutomationVariable -Name 'SharePointTargetFolder' #$SourceList = $SourceStr.Split([System.Environment]::NewLine,[System.StringSplitOptions]::RemoveEmptyEntries) $SourceList = $SourceStr.Split("\n") # Commmon Foreach($Source in $SourceList){ Try{ Write-Output "Source Folder: $Source" #Dev #$SourceSiteConnection = Connect-PnPOnline -Url $SourceSiteURL -Interactive -ReturnConnection #Prod $SourceSiteConnection = Connect-PnPOnline -Url $SourceSiteURL -ManagedIdentity -ReturnConnection #Get the total Size of the folder - with versions $SourceFolder = Get-PnPFolder -Url $Source -Includes ListItemAllFields -Connection $SourceSiteConnection $SourceFolderSize = $([Math]::Round(($SourceFolder.ListItemAllFields.FieldValues.SMTotalSize.LookupId/1KB),2)) Write-Output "Source Folder Size: $Source : $SourceFolderSize" $job = Move-PnPFile -SourceUrl $Source -TargetUrl $Target -NoWait -Overwrite -AllowSchemaMismatch -AllowSmallerVersionLimitOnDestination -Force -Connection $SourceSiteConnection $jobStatus = Receive-PnPCopyMoveJobStatus -Job $job -Wait -Connection $SourceSiteConnection if($jobStatus.JobState -eq 0){ Write-Output "Job finished" $jobStatus.JobState $jobStatus.Logs $SourceFolder = Get-PnPFolder -Url $Source -Includes ListItemAllFields -Connection $SourceSiteConnection -ErrorAction SilentlyContinue if($SourceFolder){ Write-Output "Second Try because folder: $SourceFolder.Name remains" $SourceFolderSize = $([Math]::Round(($SourceFolder.ListItemAllFields.FieldValues.SMTotalSize.LookupId/1KB),2)) Write-Output "Second Try Source Folder Size: $Source : $SourceFolderSize" $job = Move-PnPFile -SourceUrl $Source -TargetUrl $Target -NoWait -Overwrite -AllowSchemaMismatch -AllowSmallerVersionLimitOnDestination -Force -Connection $SourceSiteConnection $jobStatus = Receive-PnPCopyMoveJobStatus -Job $job -Wait -Connection $SourceSiteConnection if($jobStatus.JobState -eq 0){ Write-Output "Second TryJob finished" $jobStatus.JobState $jobStatus.Logs } else{ Write-Error "Second Try Status: $jobStatus" } } } else{ Write-Error "$jobStatus" } } catch { Write-Error "An error occurred: ${Source}: $_" } # Dispose the connnection variables $SourceSiteConnection = $null Write-Output "Sleep for 2 seconds" Start-Sleep -Milliseconds 2000 }

Reading - https://github.com/pnp/powershell/issues/277

The PnP PowerShell module is the one I would recommend for accessing SharePoint: https://pnp.github.io/powershell/

PnP is the module - it is amazing. The SP cli is a painful (but powerful) nightmare. https://pnp.github.io/powershell/