locked
Trying to install ImportExcel module in Powershell RRS feed

  • Question

  • I am completely new to this but I am following the instructions on 

    https://www.youtube.com/watch?v=YyAEsZG21ao&index=1&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq

    How ever when I try to install ImportExcel from the powershell gallery using  find-module importexcel

    I get the following error

    PackageManagement\Find-Package : No match was found for the specified search criteria and module name 'importexcel'.
    Try Get-PSRepository to see all available registered module repositories.
    At C:\Program Files\WindowsPowerShell\Modules\PowerShellGet\1.0.0.1\PSModule.psm1:1360 char:3
    +         PackageManagement\Find-Package @PSBoundParameters | Microsoft ...
    +         ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
        + CategoryInfo          : ObjectNotFound: (Microsoft.Power...ets.FindPackage:FindPackage) [Find-Package], Exceptio
       n
        + FullyQualifiedErrorId : NoMatchFoundForCriteria,Microsoft.PowerShell.PackageManagement.Cmdlets.FindPackage

    Any help appreciated.




    • Edited by JaK82 Wednesday, May 2, 2018 1:38 PM
    Wednesday, May 2, 2018 1:33 PM

Answers

  • Hi Jak82,

    You just need to run these commands from a Powershell with administrative rights:

    Save-Module -Name ImportExcel -Path <path>
    Install-Module -Name ImportExcel
    

    Regards

    Simon


    If you find that my post has answered your question, please mark it as the answer. If you find my post to be helpful in anyway, please click vote as helpful. Regards Simon Disclaimer: This posting is provided AS IS with no warranties or guarantees, and confers no rights.

    • Marked as answer by JaK82 Thursday, May 3, 2018 10:19 AM
    Wednesday, May 2, 2018 2:22 PM
  • As an elevated administrator type the following:

    find-module importexcel | Install-Module

    Be sure the PSGallery is registered:

    Get-PsRepository


    \_(ツ)_/

    • Marked as answer by JaK82 Thursday, May 3, 2018 10:19 AM
    Wednesday, May 2, 2018 6:29 PM
  • Try the following command:

    Register-PSRepository -Name "PSGallery" –SourceLocation "https://www.powershellgallery.com/api/v2/" -InstallationPolicy Trusted
    as it is specified it this thread: https://social.msdn.microsoft.com/Forums/en-US/30e7e8fe-ba48-4f1c-8d75-36b54af502ae/installpackageprovider-no-match-was-found?forum=windowscontainers

    • Marked as answer by JaK82 Thursday, May 3, 2018 10:19 AM
    Thursday, May 3, 2018 8:44 AM

All replies

  • Hi Jak82,

    You just need to run these commands from a Powershell with administrative rights:

    Save-Module -Name ImportExcel -Path <path>
    Install-Module -Name ImportExcel
    

    Regards

    Simon


    If you find that my post has answered your question, please mark it as the answer. If you find my post to be helpful in anyway, please click vote as helpful. Regards Simon Disclaimer: This posting is provided AS IS with no warranties or guarantees, and confers no rights.

    • Marked as answer by JaK82 Thursday, May 3, 2018 10:19 AM
    Wednesday, May 2, 2018 2:22 PM
  • As an elevated administrator type the following:

    find-module importexcel | Install-Module

    Be sure the PSGallery is registered:

    Get-PsRepository


    \_(ツ)_/

    • Marked as answer by JaK82 Thursday, May 3, 2018 10:19 AM
    Wednesday, May 2, 2018 6:29 PM
  • Try the following command:

    Register-PSRepository -Name "PSGallery" –SourceLocation "https://www.powershellgallery.com/api/v2/" -InstallationPolicy Trusted
    as it is specified it this thread: https://social.msdn.microsoft.com/Forums/en-US/30e7e8fe-ba48-4f1c-8d75-36b54af502ae/installpackageprovider-no-match-was-found?forum=windowscontainers

    • Marked as answer by JaK82 Thursday, May 3, 2018 10:19 AM
    Thursday, May 3, 2018 8:44 AM
  • You are not required to use Administrator privileges like everyone is posting. You can scope the install of the module to your user profile without elevated privileges.

    Install-Module ImportExcel -Scope User

    This will install the module under: $env:USERPROFILE\Documents\WindowsPowerShell\

    Thursday, May 3, 2018 1:21 PM