Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 07:30:02 +0000



[Programming Help] - GetSpreadsheetSheetHandleByName Path Not Working in Acsil

View Count: 245

[2023-09-11 19:39:03]
User584005 - Posts: 27
I'm trying to reference a spreadsheet using the full path/extension but I can't seem to get it to find the file.
I know I can use the file name only without the extension but I want to be able to reference files in places other than the Data Folder.

For example if I have

const char* SheetCollectionName = "C:\\SierraChart\\Spreadsheets\\Tickers.scss";
const char* SheetName = "Sheet1";
void* SheetHandle = sc.GetSpreadsheetSheetHandleByName(SheetCollectionName, SheetName, false);

The sheet will be not be recognized. The only way it will is if i put the sheet in the Data folder and change the code to
const char* SheetCollectionName = "Tickers";

When I referenced ACSILSpreadsheetInteraction.cpp, it had a comment saying
  // This can either contain a complete path and file extension, or just
  // the name of the spreadsheet file itself without the extension.

Am I misunderstanding or coding this incorrectly?

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

Login

Login Page - Create Account