Closed
Description
Import-Excel .\sample.xlsx | Format-YAML
Only prints the Category
. The "numbers" don't get emitted for the others.
- OrderId:
Category: Cosmetics
Sales:
Quantity:
Discount:
- OrderId:
Category: Grocery
Sales:
Quantity:
Discount:
- OrderId:
Category: Apparels
Sales:
Quantity:
Discount:
- OrderId:
Category: Electronics
Sales:
Quantity:
Discount:
- OrderId:
Category: Electronics
Sales:
Quantity:
Discount:
- OrderId:
Category: Apparels
Sales:
Quantity:
Discount:
- OrderId:
Category: Electronics
Sales:
Quantity:
Discount:
- OrderId:
Category: Cosmetics
Sales:
Quantity:
Discount:
- OrderId:
Category: Grocery
Sales:
Quantity:
Discount:
- OrderId:
Category: Grocery
Sales:
Quantity:
Discount: