Support Board
Date/Time: Tue, 11 Feb 2025 02:40:42 +0000
Post From: ACSIL: write to spreadsheet on a new row for each time
| [2020-08-22 14:15:24] |
| User420253 - Posts: 4 |
|
I have a logic that read a value from one spreadsheet and writes that value to another spreadsheet. However, I need a way to write to a new row for each time (now it overwrites the same cell each time). Any suggestions to how I can write to a new row (either by a counter) or by looking for the first row with no values? The value (source and writing) is updated each time a candle closes. Could this be used as counter? This is my code for reading and writing (for reference): // 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, 1, CellValueA4); Date Time Of Last Edit: 2020-08-22 16:44:31
|