How to paste CSV into existing excel sheet, then more

Tagged: , , ,

This topic contains 1 reply, has 2 voices, and was last updated by Profile photo of Matthew Holtz Matthew Holtz 2 months ago.

  • Author
    Posts
  • #45555
    Profile photo of Ayman Ali
    Ayman Ali
    Participant

    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!

  • #54842
    Profile photo of Matthew Holtz
    Matthew Holtz
    Participant

    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.

You must be logged in to reply to this topic.