Using XSLT to Transform PS Query w/ Excel
Use Case: I'd like to use an XSLT Transformation on a PS Query to manipulate results going into excel (XLSX).
When you define a transformation in a PS Query, XLSX is a valid option. However it's not clear what a transform would look like in this case. If I output something w/ an HTML body w/ table rows, that fails as not a valid XML format.
Can anyone share an example?