PhilipCubix opened a new issue, #7449: URL: https://github.com/apache/hop/issues/7449
### Apache Hop version? 2.17 ### Java version? 21.0.11 ### Operating system Windows ### What happened? Hi, The Excel XLSX (using Streaming) engine has trouble reading streamed files correctly. After switching a file written using the Microsoft Excel Writer Transform from batch to streaming (xlsx [Excel 2007 and above]) an error popped up, because values were read into the wrong fields. The excel file itself is correct: when viewed in Excel there is no difference between the 2 modes of writing the excel file. However when the file is read again by Hop, the F column which contains (mostly) empty cells in my flow, got swapped with the subsequent G column. This only happened for the file written in streaming mode. I haven't tested if another reading engine handles this better: it makes no sense to write larger excel files using streaming mode in order to subsequently read those larger files using the batch reading mode. My workaround is simply to write a smaller excel file in batch mode, and read it using streaming mode. ### Issue Priority Priority: 2 ### Issue Component Component: Transforms -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
