Does Pentaho Data Integration has Excel 2007 (.xlsx) ouput in a transformation? I'm using PDI 4.1.0 Stable
Use Microsoft Excel Writer Step. It can generate xls file in xls or xlsx extension