ML
    • Recent
    • Categories
    • Tags
    • Popular
    • Users
    • Groups
    • Register
    • Login

    Powershell Help Part 3

    Scheduled Pinned Locked Moved IT Discussion
    6 Posts 3 Posters 540 Views
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • LakshmanaL
      Lakshmana
      last edited by Lakshmana

      I am having having 3 Excel sheets where A file is the master copy where B and C are duplicate copy.The master copy Excel has 3 pages and duplicate copy has only one page.I need to copy B Excel file in page 2 of Master Copy and copy C Excel file in Page 3 of Master copy.These things to be done in Powershell is it possible?The first page content in Master copy should not be deleted and the other two pages can be deleted before copying the data

      1 Reply Last reply Reply Quote 0
      • DashrenderD
        Dashrender
        last edited by

        Why Excel, why not put this data in a DB?

        1 Reply Last reply Reply Quote 1
        • LakshmanaL
          Lakshmana
          last edited by

          Downloading the production level tickets in Excel file which needs to be copied to master copy

          1 Reply Last reply Reply Quote 0
          • Mike DavisM
            Mike Davis
            last edited by

            Does this help:
            https://social.technet.microsoft.com/Forums/scriptcenter/en-US/2a0dc55d-66c4-4228-a834-0389a32e52b0/how-can-i-use-powershell-to-copy-an-excel-worksheet-from-one-workbook-to-the-second-sheet-of-another?forum=ITCG

            1 Reply Last reply Reply Quote 2
            • LakshmanaL
              Lakshmana
              last edited by

              Checking on the same

              1 Reply Last reply Reply Quote 0
              • LakshmanaL
                Lakshmana
                last edited by

                Unexpected token 's' in expression or statement.
                + CategoryInfo : ParserError: (:) [], ParentContainsErrorRecordException
                + FullyQualifiedErrorId : UnexpectedToken

                1 Reply Last reply Reply Quote 0
                • 1 / 1
                • First post
                  Last post