I was wanting to user powershell to create a table around the existing data in an excel file. Any help would be greatly appreciated (new at powershell).
Thanks
You dont mean, append additional data to the existing file?
Like:
Export-Csv -Path ./Services.csv -NoTypeInformation -Append
No, I have a file that I am attaching to a sharepoint list and it needs to have a table inserted around the existing data so it lines up with the list columns.
Seems like you need to learn powershell and the excel com model all at the same time. I’m happy to try and help you, so be sure to come back and post what you try and what issues you’re facing.
I’m trying…
Take a look at the great module from Doug Finke ImportExcel. That could make your life a lot easier. 