I solved it by changing the Excel file extension from xlsx to xls, and in Kettle, in Microsoft Excel Writer, I also changed the extension to xls.