Login Page - Create Account

Support Board


Date/Time: Tue, 28 May 2024 04:31:42 +0000



Post From: ACSIL: write to spreadsheet on a new row for each time

[2020-08-22 16:44:16]
User420253 - Posts: 4
I have an IF-function that updates (read and write) the cells every time a candle is closed. So I tried adding a counter to make it increase the row number for each iteration:

int Row = 1;

// IF function when candle closed:
{
// Get the value from cell A4 (if it exists) and write to cell B2 in other sheet:
double CellValueA4 = 0.00;
if (sc.GetSheetCellAsDouble(SheetHandle1, 0, 3, CellValueA4))
sc.SetSheetCellAsDouble(SheetHandle2, 1, 'Row', CellValueA4);

Row = Row + 1;
}

But I get this error when compiling:
warning: multi-character character constant [-Wmultichar]

Any takes?