View Only

 Help with Excel Writer Compatibility errors

Chiara Gucciardi's profile image
Chiara Gucciardi posted 07-26-2022 11:57
Hi there,
I'm facing an issue while working with PDI 9.1. I'm trying to generate Excel Files with Excel Writer step with XLSX template. The transformation works ok and the file is correctly created, but when you open in Excel (no matter with version) it shows a sort of compatibility error and asks to recover the document.
Does anyone know how to solve this?
Thank you
java - ResultSet to Excel (*.xlsx) Table Using Apache POI - Stack Overflow
Carlos Lopez's profile image
Carlos Lopez
Can you share a screenshot of the options you have selected on the Excel Writer Step; if you are able to share a sample transformation that produces this behavior I can give this a test?
Chiara Gucciardi's profile image
Chiara Gucciardi
Hi there, i'm attaching a few screenshots and files.
This is a basic transformation actually. table input and excel writer:

Attachment  View in library
r1tab.xlsx 12 KB