Take the following code ...
<cfspreadsheet action="read" src="#z.xlsfile#" query="data" headerrow="1" excludeHeaderRow="true" />
<cfoutput>
<cfloop query="data">
#data["Doc Type"][data.currentrow]# - #replace(data["Doc Type"][data.currentrow],' ','$','all')#<br>
#data["Doc No"][data.currentrow]# - #replace(data["Doc No"][data.currentrow],' ','$','all')#<br>
#data["Doc Rev"][data.currentrow]# - #replace(data["Doc Rev"][data.currentrow],' ','$','all')#<br>
#data["File Name"][data.currentrow]# - #replace(data["File Name"][data.currentrow],' ','$','all')#<br>
<hr>
</cfloop>
</cfoutput>
<cfabort>
The XLS file that is being read has cell data that has leading and trailing spaces. On one ColdFusion server, the output does not display spaces, as if it <cfspreadsheet>automatically cropped all the data. On a different server this is not the case. I think maybe it has poi.jarbeen changed? Has anyone else experienced this? I could not find anyone complaining about this.
This ColdFusion server will automatically crop the data ...
Version: 2016,0,02,299200
Update Level: chf20160002.jar
Is not...
Version: 10,0,19,298511
Update Level: chf10000019.jar
source
share