Description. The Excel Output step allows you to write data to one or more Excel files. The following sections describe the features available for configuring the. It's probably not the excel writer consuming all the memory then. (I tested it personally with hundreds of columns and 1M rows) You need to copy the rows (employee names) into memory and then loop it across the excel file to generate multiple sheets with employee names. Jens Bleuel added a comment - 09/Aug/12 6:37 AM Similar to PDI-6560 , a couple of questions: a) Did you tried to higher the memory? b) Does this only happen with xlsx? I have scheduled a job which has series of transformation writing query output in Excel 2007 using excel writer and mailing them to users. The memory usage seems to. An Engagement Mechanism. Participate in the Pentaho Community: By using Pentaho CE, you become part of an active and engaging Community and benefit from its open. Pentaho Data Integration - Kettle; PDI-6560; Microsoft Excel Writer - Memory Error. Agile Board; Export. XML; Word; Printable; Details. Type: Bug Status: Closed. Pentaho is a company that offers Pentaho Business Analytics, a suite of open source Business Intelligence (BI) products which provide data integration, OLAP services. Choose from 3 ways to test drive the power of Pentaho Business Analytics with our data or yours. Experience comprehensive business analytics now. Microsoft Excel Writer step writes incoming rows into an MS Excel file. It supports both the xls and xlsx file formats. The xlsx format is usually a good choice when.