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

    Powershell Help Part 3

    IT Discussion
    3
    6
    444
    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.
    • Lakshmana
      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
      • Dashrender
        Dashrender last edited by

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

        1 Reply Last reply Reply Quote 1
        • Lakshmana
          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 Davis
            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
            • Lakshmana
              Lakshmana last edited by

              Checking on the same

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

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

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