Login Page - Create Account

Support Board


Date/Time: Tue, 26 Nov 2024 15:48:54 +0000



Open Spreadsheet Error

View Count: 242

[2023-11-17 07:52:27]
Sierra_Chart Engineering - Posts: 17182
Is it actually a text file?

Is the character encoding ASCII?
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing
[2023-11-17 14:34:00]
netxqy - Posts: 4
Hello,
I use the menu, File >>> Open Spreadsheet, "File Type" select "Comma Separated Values (*.csv)"
Open a file named Data.csv.
It's a text file. Encoding is ASCII.


The content of the Data.csv file is as follows.
A,1,10.1
B,2,20.2


An error occurred.
"Error reading the spreadsheet file. The file type is not supported. A new spreadsheet will be created."


Could you please tell me how to solve this problem?
Thank you very much for your help.
Date Time Of Last Edit: 2023-11-17 14:34:45
attachmentData.csv - Attached On 2023-11-17 14:33:47 UTC - Size: 18 B - 209 views
[2023-11-17 14:43:45]
Sierra_Chart Engineering - Posts: 17182
The fields need to be tab delimited. Not comma delimited.

And also the text editor we use shows that the encoding was UTF-8.
Sierra Chart Support - Engineering Level

Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy:
https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation

For the most reliable, advanced, and zero cost futures order routing, use the Teton service:
Sierra Chart Teton Futures Order Routing

To post a message in this thread, you need to log in with your Sierra Chart account:

Login

Login Page - Create Account