<div>
Worked okay for me.<br />
<br />
1. Can you upload a sample .xls that causes a problem on your end?<br />
2. What is your CF version? &lt;cfdump var=&quot;#server#&quot;&gt;
</div>


<div>
You are right !!! CFSPREADSHEET reads the ñ character <br />
<br />
Further analyses in the code revealed the following<br />
<br />
When I create a CSV containg the ñ character, the ñ is shown when the CSV file is opened with Notepad<br />
However, when opening the CSV file with Excel, the ñ is converted to Ã±<br />
<br />
<br />
EXAMPLE<br />
<br />
Opened with NOTEPAD<br />
===============<br />
Jeandru Castañeda<br />
<br />
When opened with Excel<br />
======================<br />
Jeandru CastaÃ±eda<br />
<br />
<br />
Code used to create CSV file is<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfsetting showDebugOutput=&quot;No&quot;&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfheader name=&quot;Content-disposition&quot;<wbr /> value=&quot;attachment;filename<wbr />=#fileName<wbr />Csv#&quot;&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfcontent type=&quot;UTF-8&quot;&gt;<br />
&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;cfoutput&gt;#word#&lt;/cfoutput<wbr />&gt;
</div>


<div>
<div class="content wysiwyg-content">
I am reading an excel file using &lt;cfspreadsheet action=&quot;read&quot; src=&quot;#theFile#&quot; query=&quot;data&quot; headerrow=&quot;1&quot;&gt;. However,letter ñ in data is converted to n in query=&quot;data&quot;. <br />
<br />
How can I prevent translation from ñ to n
</div>
</div>


I am reading an excel file using <cfspreadsheet action="read" src="#theFile#" query="data" headerrow="1">. However,letter ñ in data is converted to n in query="data". 

How can I prevent translation from ñ to n

Coldfusion reading Excel file translates ñ into n

ColdFusion is a server-side rapid application development platform originally created by Allaire and now sold by Adobe, implementing the dynamic general purpose CFML programming language. The term ColdFusion is sometimes colloquially used to refer to the CFML language (Cold Fusion Markup Language), but can also include discussions of the server software implementation. ColdFusion runs using a customised version of Apache Tomcat. Earlier versions are bundled with JRun.