rvirgolireply opened a new issue, #7250:
URL: https://github.com/apache/hop/issues/7250

   ### Apache Hop version?
   
   2.16
   
   ### Java version?
   
   java 21.0.6
   
   ### Operating system
   
   Windows
   
   ### What happened?
   
   ### Summary:
   Excel Input fails to read an .xlsx file from a Windows UNC network path when 
using the default Excel XLSX, XLS reader. The same file exists and can be read 
when the pipeline is configured like other working imports using Excel XLSX 
(Streaming) with directory + filemask.
   
   Input file: \\some.network.folder\my_excel.xlsx
   Hop Variable: NETWORK_PATH=\\some.network.folder
   
   ### Hypothesis:
   The issue seems related to path/URI normalization in the classic POI Excel 
reader path. The UNC path is converted to:
   file:////some.network.folder/...
   and then appears to be passed to POI/Java as:
   
   file:\some.network.folder\...
   which is treated as a literal local path instead of a network UNC path.
   
   ### Additional note:
   Other Excel Input pipelines in the same project work correctly when using 
SAX_POI and directory + filemask.
   
   ### Issue Priority
   
   Priority: 3
   
   ### 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]

Reply via email to