PhilipCubix commented on issue #7449: URL: https://github.com/apache/hop/issues/7449#issuecomment-4924821423
Dag Hans, I've created 2 test pipelines to demonstrate, please find them attached (zipped). Here are the 2 excel files produced by **test-writeExcelfile.hpl**: when viewed in Excel, they are shown correctly. [batchWritten.xlsx](https://github.com/user-attachments/files/29847444/batchWritten.xlsx) [streamed.xlsx](https://github.com/user-attachments/files/29847443/streamed.xlsx) When I run **test-readFile.hpl** (on Hop 18.1 in the meantime), this is the output, values of column B and C are inverted (because B was an empty string): `2026/07/09 13:57:40 [Basic] Write to log Streamed.0 - ------------> Linenr 1------------------------------ 2026/07/09 13:57:40 [Basic] Write to log Streamed.0 - colA = valA 2026/07/09 13:57:40 [Basic] Write to log Streamed.0 - colB = valC 2026/07/09 13:57:40 [Basic] Write to log Streamed.0 - colC = null 2026/07/09 13:57:40 [Basic] Write to log Streamed.0 - colD = valD 2026/07/09 13:57:40 [Basic] Write to log Streamed.0 - 2026/07/09 13:57:40 [Basic] Write to log Streamed.0 - ==================== 2026/07/09 13:57:40 [Basic] Write to log Batch.0 - 2026/07/09 13:57:40 [Basic] Write to log Batch.0 - ------------> Linenr 1------------------------------ 2026/07/09 13:57:40 [Basic] Write to log Batch.0 - colA = valA 2026/07/09 13:57:40 [Basic] Write to log Batch.0 - colB = 2026/07/09 13:57:40 [Basic] Write to log Batch.0 - colC = valC 2026/07/09 13:57:40 [Basic] Write to log Batch.0 - colD = valD 2026/07/09 13:57:40 [Basic] Write to log Batch.0 - 2026/07/09 13:57:40 [Basic] Write to log Batch.0 - ====================` [test.zip](https://github.com/user-attachments/files/29847448/test.zip) -- 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]
