Author Posts

July 1, 2016 at 7:30 pm

Hey all, I'm fairly new to powershell and I'd really appreciate some help.

I have a ton of really simple csv files that I need to do the following with:

1) paste a csv into a specific sheet (ex. sheet1) of an existing excel template (so sheet1, into B4)
2) then, I need to copy a chunk of data in a different sheet
3) and finally save the copied data to brand new excel sheet

I've figured out how to do step 3 but step 1 and 2 are throwing me off really badly – any help or direction would be great!

Thanks!

October 3, 2016 at 6:03 pm

Hello I am fairly new to powershell as well. I did come across this article from the Scripting Guy that might be of help to you.

https://blogs.technet.microsoft.com/heyscriptingguy/2010/09/09/copy-csv-columns-to-an-excel-spreadsheet-by-using-powershell/