ImportExcel.psd1
|
@{ # Assemblies that must be loaded prior to importing this module RequiredAssemblies = @('.\EPPlus.dll') # Script module or binary module file associated with this manifest. RootModule = 'ImportExcel.psm1' # Version number of this module. ModuleVersion = '7.8.2' # ID used to uniquely identify this module GUID = '60dd4136-feff-401a-ba27-a84458c57ede' # Author of this module Author = 'Douglas Finke' # Company or vendor of this module CompanyName = 'Doug Finke' # Copyright statement for this module Copyright = 'c 2020 All rights reserved.' # Description of the functionality provided by this module Description = @' PowerShell module to import/export Excel spreadsheets, without Excel. Check out the How To Videos https://www.youtube.com/watch?v=U3Ne_yX4tYo&list=PL5uoqS92stXioZw-u-ze_NtvSo0k0K0kq '@ # Functions to export from this module FunctionsToExport = @( 'Add-ConditionalFormatting', 'Add-ExcelChart', 'Add-ExcelDataValidationRule', 'Add-ExcelName', 'Add-ExcelTable', 'Add-PivotTable', 'Add-Worksheet', 'BarChart', 'Close-ExcelPackage', 'ColumnChart', 'Compare-Worksheet', 'Convert-ExcelRangeToImage', 'ConvertFrom-ExcelData', 'ConvertFrom-ExcelSheet', 'ConvertFrom-ExcelToSQLInsert', 'ConvertTo-ExcelXlsx', 'Copy-ExcelWorksheet', 'DoChart', 'Enable-ExcelAutoFilter', 'Enable-ExcelAutofit', 'Expand-NumberFormat', 'Export-Excel', 'Export-ExcelSheet', 'Get-ExcelColumnName', 'Get-ExcelFileSummary', 'Get-ExcelSheetDimensionAddress', 'Get-ExcelSheetInfo', 'Get-ExcelWorkbookInfo', 'Get-HtmlTable', 'Get-Range', 'Get-XYRange', 'Import-Excel', 'Import-Html', 'Import-UPS', 'Import-USPS', 'Invoke-AllTests', 'Invoke-ExcelQuery', 'Invoke-Sum', 'Join-Worksheet', 'LineChart', 'Merge-MultipleSheets', 'Merge-Worksheet', 'New-ConditionalFormattingIconSet', 'New-ConditionalText', 'New-ExcelChartDefinition', 'New-ExcelStyle', 'New-PivotTableDefinition', 'New-Plot', 'New-PSItem', 'Open-ExcelPackage', 'PieChart', 'Pivot', 'Read-Clipboard', 'Read-OleDbData', 'ReadClipboardImpl', 'Remove-Worksheet', 'Select-Worksheet', 'Send-SQLDataToExcel', 'Set-CellStyle', 'Set-ExcelColumn', 'Set-ExcelRange', 'Set-ExcelRow', 'Set-WorksheetProtection', 'Test-Boolean', 'Test-Date', 'Test-Integer', 'Test-Number', 'Test-String', 'Update-FirstObjectProperties' ) # Aliases to export from this module AliasesToExport = @( 'Convert-XlRangeToImage', 'Export-ExcelSheet', 'New-ExcelChart', 'Set-Column', 'Set-Format', 'Set-Row', 'Use-ExcelData' ) # Cmdlets to export from this module CmdletsToExport = @() FileList = @( '.\EPPlus.dll', '.\Export-charts.ps1', '.\GetExcelTable.ps1', '.\ImportExcel.psd1', '.\ImportExcel.psm1', '.\LICENSE.txt', '.\README.md', '.\Plot.ps1', '.\Private', '.\Public', '.\en\ImportExcel-help.xml', '.\en\Strings.psd1', '.\Charting\Charting.ps1', '.\InferData\InferData.ps1', '.\Pivot\Pivot.ps1', '.\Examples', '.\Testimonials' ) # Private data to pass to the module specified in RootModule/ModuleToProcess PrivateData = @{ # PSData is module packaging and gallery metadata embedded in PrivateData # It's for rebuilding PowerShellGet (and PoshCode) NuGet-style packages # We had to do this because it's the only place we're allowed to extend the manifest # https://connect.microsoft.com/PowerShell/feedback/details/421837 PSData = @{ # The primary categorization of this module (from the TechNet Gallery tech tree). Category = "Scripting Excel" # Keyword tags to help users find this module via navigations and search. Tags = @("Excel", "EPPlus", "Export", "Import") # The web address of an icon which can be used in galleries to represent this module #IconUri = "http://pesterbdd.com/images/Pester.png" # The web address of this module's project or support homepage. ProjectUri = "https://github.com/dfinke/ImportExcel" # The web address of this module's license. Points to a page that's embeddable and linkable. LicenseUri = "https://github.com/dfinke/ImportExcel/blob/master/LICENSE.txt" # Release notes for this particular version of the module #ReleaseNotes = $True # If true, the LicenseUrl points to an end-user license (not just a source license) which requires the user agreement before use. # RequireLicenseAcceptance = "" # Indicates this is a pre-release/testing version of the module. IsPrerelease = 'False' } } # Minimum version of the Windows PowerShell engine required by this module # PowerShellVersion = '' # Name of the Windows PowerShell host required by this module # PowerShellHostName = '' # Minimum version of the Windows PowerShell host required by this module # PowerShellHostVersion = '' # Minimum version of Microsoft .NET Framework required by this module # DotNetFrameworkVersion = '' # Minimum version of the common language runtime (CLR) required by this module # CLRVersion = '' # Processor architecture (None, X86, Amd64) required by this module # ProcessorArchitecture = '' # Modules that must be imported into the global environment prior to importing this module # RequiredModules = @() # Script files (.ps1) that are run in the caller's environment prior to importing this module. # ScriptsToProcess = @() # Type files (.ps1xml) to be loaded when importing this module # TypesToProcess = @() # Format files (.ps1xml) to be loaded when importing this module # FormatsToProcess = @() # Modules to import as nested modules of the module specified in RootModule/ModuleToProcess # NestedModules = @() # List of all modules packaged with this module # ModuleList = @() # List of all files packaged with this module # Variables to export from this module #VariablesToExport = '*' # HelpInfo URI of this module # HelpInfoURI = '' # Default prefix for commands exported from this module. Override the default prefix using Import-Module -Prefix. # DefaultCommandPrefix = '' } |