Import data from Excel using Excel's COM interface.
Data Wrangling\Import-Excel.ps1
Import-Excel [-FullName] <Object> -SheetName <String>
Import-Excel [-FullName] <Object> -SheetNumber <Int32>
Converts the Excel file to a temporary .csv file and imports the same using Import-Csv. Works only with default delimiter since no paramenter is implemented so far.
$excelFile | Import-Excel
The Path to the Excel file to be imported.
Type: Object
Parameter Sets: (All)
Aliases:
Required: True
Position: 1
Default value: None
Accept pipeline input: True (ByPropertyName, ByValue)
Accept wildcard characters: FalseThe name of the sheet to be imported from the Excel file.
Type: String
Parameter Sets: ByName
Aliases:
Required: True
Position: Named
Default value: None
Accept pipeline input: False
Accept wildcard characters: FalseThe number of the sheet to be imported from the Excel file.
Type: Int32
Parameter Sets: ByNumber
Aliases:
Required: True
Position: Named
Default value: 0
Accept pipeline input: False
Accept wildcard characters: False