Using the Excel Writer Step

transformation

The Excel Writer plugin offers support for Excel template files that can be filled in a variety of ways using Kettle a.k.a. PDI. In this post I would like to show how to fill an Excel report template file that has pre-styled cells, formulas and charts on different sheets. The entire report is filled within a . . . → Read More: Using the Excel Writer Step

Releasing Excel Writer Plugin for Kettle

excel_screen

In this post I would like to announce the release of my Excel Writer Plugin for Kettle 3.2.x and 4.0.x, 4.1.x Grab it at the Excel Writer Plugin page.

The plugin allows to easily write and modify Excel files in xls and xlsx format based on template files. . . . → Read More: Releasing Excel Writer Plugin for Kettle

Writing to multiple Excel Sheets with Kettle

screenshot_blocking

Note: If you can use the Excel Writer plugin there are more convenient possibilities to write to multiple sheets, or even into the same sheet but different places. Check out this article.

Every now and then the question about filling multiple sheets of a single Excel file pops up on the Pentaho Kettle forums, so I gathered . . . → Read More: Writing to multiple Excel Sheets with Kettle