5
$\begingroup$

It seems mma9 works fine, but with mma10 it fail to load a file name with Chinese characters. I use MacBook Pro(Retina) with OSX 10.10.2, and Mathematica 10.0.0.0. I need the file name with Chinese characters, and how can I fix it?

Here is my code:

In[309]:= Import["20150226-9999指數.xls", {"Data", -1}]
During evaluation of In[309]:= Import::fnfnd: File /Users/TWSE-data/20150226-9999指數.xls not found. >>

Out[309]= $Failed

Let me clear situation now:

.txt file format works fine, but not for .xls file with Chinese character It may be system dependent problem.

In[37]:= Import["4拷貝.txt"]

Out[37]= "this is test file"

In[38]:= Import["20150226-9999TWRI拷貝.xls"]

During evaluation of In[38]:= Import::fnfnd: File /Users/TWSE-data/20150226-9999TWRI拷貝.xls not found. >>

Out[38]= $Failed

In[39]:= Import["20150226-9999TWRI.xls"]

Out[39]= {{{92.48, 92.48, 92.48, 92.48, 0., 0.}, {92.48, 92.48, 92.48,
    92.48, 0., 0.}}}

In[40]:= $Version

Out[40]= "10.0 for Mac OS X x86 (64-bit) (December 4, 2014)"
$\endgroup$
  • $\begingroup$ Upgrade to Mathematica 10.0.2. $\endgroup$ – Szabolcs Mar 9 '15 at 18:14
  • $\begingroup$ Yes, it seeems that, i check all the path and file name, only mma10.0.0.0 will cause the issue. $\endgroup$ – Cheng-Sheng Yan Mar 9 '15 at 18:43
  • $\begingroup$ path seems can work, but file name with Chinese character seems not work still with mma10.0.2 $\endgroup$ – Cheng-Sheng Yan Mar 10 '15 at 3:32
  • $\begingroup$ I cannot reproduce this problem $\endgroup$ – Szabolcs Mar 10 '15 at 3:48
  • $\begingroup$ Thank you for trying, I can open file with .txt format, but still can't open .xls file name with Chinese character. Please see re-edit question. My issue is the "file name", not "path" with Chinese characters. $\endgroup$ – Cheng-Sheng Yan Mar 10 '15 at 13:22
6
$\begingroup$

I can reproduce this problem on OS X with Mathematica 10.0.2, but with XLS and XLSX files only. Thus it's different from this bug which existed in version 10.0.0 and affected all files, and was fixed later.

I believe that this is a bug and you should report this to Wolfram Support so it can be fixed. Mathematica.SE is not a website run by Wolfram Research and reporting bugs only here won't get them fixed.


Here's a workaround that doesn't require renaming the file:

In[1]:= Import["~/Desktop/中.xlsx", "XLSX"]

During evaluation of In[1]:= Import::fnfnd: File /Users/szhorvat/Desktop/中.xlsx not found. >>

During evaluation of In[1]:= Import::fmterr: Cannot import data as XLSX format. >>

Out[1]= $Failed

In[2]:= stream = OpenRead["~/Desktop/中.xlsx"]
Out[2]= InputStream["/Users/szhorvat/Desktop/中.xlsx", 3]

In[3]:= Import[stream, "XLSX"]
Out[3]= {{{1.}, {2.}, {3.}}}

In[4]:= Close[stream]
Out[4]= "/Users/szhorvat/Desktop/中.xlsx"

You could package this up into a function for convenience.

$\endgroup$

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.