Insert table into existing Excel file

Welcome Forums General PowerShell Q&A Insert table into existing Excel file

  • This topic has 5 replies, 4 voices, and was last updated 1 month ago by
    Participant
    .
Viewing 5 reply threads
  • Author
    Posts
    • #220857
      Participant
      Topics: 1
      Replies: 2
      Points: -2
      Rank: Member

      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

    • #220866
      Participant
      Topics: 3
      Replies: 11
      Points: 62
      Rank: Member

      You dont mean, append additional data to the existing file?

      Like:

      Export-Csv -Path ./Services.csv -NoTypeInformation -Append
    • #220869
      Participant
      Topics: 1
      Replies: 2
      Points: -2
      Rank: Member

      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.

    • #220875
      Participant
      Topics: 3
      Replies: 324
      Points: 1,056
      Helping Hand
      Rank: Community Hero

      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.

    • #220884
      Participant
      Topics: 1
      Replies: 2
      Points: -2
      Rank: Member

      I’m trying….

    • #220899
      Participant
      Topics: 4
      Replies: 2231
      Points: 5,414
      Helping Hand
      Rank: Community MVP

      Take a look at the great module from Doug Finke ImportExcel. That could make your life a lot easier. 😉

Viewing 5 reply threads
  • You must be logged in to reply to this topic.