Pentaho

 View Only

 PDI: Microsoft Excel Writer via Stream XLSX Data - always generates 1048576 rows

  • Pentaho
  • Kettle
  • Pentaho
  • Pentaho Data Integration PDI
Oksana Sukhorukova's profile image
Oksana Sukhorukova posted 10-03-2019 09:26

Hello,

I use option Stream XLSX Data in Microsoft Excel Writer(without template) for generating xlsx files. When I hit "Ctrl End" in xlsx output file the cursor moves to row 1048576, but last row with data in this file is at row 225 and I want to move to the last row with data. Can I do something to fix this issue?

When I don't use Stream XLSX Data in Microsoft Excel Writer everything is OK, but I need to use this option.

image_2019_10_03T09_09_07_134Z

 


#Kettle
#Pentaho
#PentahoDataIntegrationPDI
Sergio Ribeiro's profile image
Sergio Ribeiro

Hello @Oksana Sukhorukova​;

 

What OS and version are you using?

I've tried the KTR that you attached and couldn't reproduce what you state: the generated Excel file "ends", as expected, at row 255...

 

Regards,

 

Sérgio Ribeiro

Porto - Portugal

 

Oksana Sukhorukova's profile image
Oksana Sukhorukova

Hi @Sergio Ribeiro​ ,

 

I'm a bit confused. It was my mistake PDI works correctly.