weird characters

[ybomi]

Hi, I just encounter this problem. I intend to read from my excel file and display on an array. 

This is what i encountered, anyone know why?

[billko]

I thought this post was about me (a weird character)!  😄

Post some code so we can see what is going on.  Post the file, too.

[ybomi]

The excel file is confidential and the code is very simple.

the excel file content is similar to :

Time Length Distance

1           2             3

and so on.

[RavensFan]

Turn on the context help and read it for the function Read from Spreadsheet File.

It DOES NOT read Excel files.  It reads text files.

[johnsold]

1. Is the data file in the native Excel format (.xlsx) or is it a CSV formatted text file?

2. Is the language used in the data file one which uses unicode characters?

Lynn

[billko]

---

@RavensFan wrote:

Turn on the context help and read it for the function Read from Spreadsheet File.

It DOES NOT read Excel files.  It reads text files.

---

You beat me to it.  I was going to say the same thing almost word-for-word.  😉  I guess I am a weir d character

[ybomi]

@john the data file is in xls format and the language is arial. not sure on what is unicode characters.

[RavensFan]

Arial is a font, not a language.  As I said, that function does not read Excel files.  All you are seeing is the underlying binary bytes that make up the proprietary .xls format.

[ybomi]

even if it is in csv format, it still have the same problem 

[RavensFan]

No, it won't have the same problem if it is in CSV format.

Attach your .CSV file.